Movielogr

SELECT GET_LOCK('0ec0043c79b9d84ccfc02724a8698d54', 300) AS ci_session_lock ?>

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

Array
(
)