Portale:Fisiologia-generale - portali

Approfondosci

Immagine del giorno

                     
    
    SELECT FABMEDIA.master_ID,
            FABMEDIA.ID AS media_ID, 
             FABMEDIA.user_ID, 
             FABMEDIA.title, 
             FABMEDIA.trackback, 
             MASTER.filename, 
             MASTER.extension
    FROM fabcms_fabmedia FABMEDIA
    
    JOIN ( 
         SELECT ID FROM
                 ( SELECT Y.ID
                 
                   FROM ( SELECT 1 + (1573 - 1 + 1 - 50) * RAND(240419) 
                       AS start FROM DUAL ) AS init
                   JOIN fabcms_fabmedia Y
                   LEFT JOIN fabcms_fabmedia_masters AS MASTER_SUB
                     ON Y.master_ID = MASTER_SUB.ID
                   WHERE  Y.ID > init.start
                       AND Y.enabled = 1
                        /* Filters */
                         AND  ( Y.tags LIKE '%fisiologia%' )  MASTER_SUB.subtype = 'foto' 
                     ORDER BY Y.ID
                     LIMIT 50           -- Inflated to deal with gaps
                 ) Z ORDER BY RAND()
                
                LIMIT 1                -- number of rows desired (change to 1 if looking for a single row)
              ) T ON FABMEDIA.ID = T.ID
    
    LEFT JOIN fabcms_fabmedia_masters AS MASTER
    ON MASTER.ID = FABMEDIA.master_ID