Movielogr

SELECT GET_LOCK('7f5b3e49eb5afe93bd8ff99a46f0a77b', 300) AS ci_session_lock ?>

SELECT `data`
FROM `ml_sessions`
WHERE `id` = '704936ebd9632f9c5cd133f2fb9d718752b5d510'
AND `ip_address` = '216.73.216.6' ?>

SELECT genre, genre_name 
             FROM (
                    SELECT genre_id_01 AS genre 
                    FROM ml_movies 
                    UNION ALL 
                    SELECT genre_id_02 
                    FROM ml_movies 
                    UNION ALL 
                    SELECT genre_id_03 
                    FROM ml_movies
                 ) AS T1 
                 JOIN ml_lookup_genres AS LG ON (T1.genre = LG.genre_id)
             GROUP BY genre ?>

SELECT genre, 
             COUNT(genre) AS genre_count, 
             genre_name 
             FROM (
                    SELECT genre_id_01 AS genre 
                    FROM ml_movies 
                    UNION ALL 
                    SELECT genre_id_02 
                    FROM ml_movies 
                    UNION ALL 
                    SELECT genre_id_03 
                    FROM ml_movies
                 ) AS T1 
             JOIN ml_lookup_genres AS LG ON (T1.genre = LG.genre_id)
             GROUP BY genre 
             ORDER BY genre_count DESC 
             LIMIT 10, 10 ?>

Array
(
)