Movielogr

SELECT 1
FROM `ml_sessions`
WHERE `id` = 'cc13b8c03fe3d51093831f5633cbc1f5ba3869bd'
AND `ip_address` = '216.73.216.6' ?>

SELECT GET_LOCK('feeeb5d55151f3ec58e2f1741672e187', 300) AS ci_session_lock ?>

SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'cc13b8c03fe3d51093831f5633cbc1f5ba3869bd'
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 20, 10 ?>

Array
(
)