Movielogr

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

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

SELECT `data`
FROM `ml_sessions`
WHERE `id` = '84173ed6cce984c17e5dfdd5d8076abcbb12f9e0'
AND `ip_address` = '216.73.216.6' ?>

SELECT `MV`.`title_id`, `date_viewed`, `title`, `prefix`, `year`, `username`
FROM `ml_movie_titles` `MT`
JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
JOIN `ml_users` `MU` ON `MU`.`user_id` = `MV`.`user_id`
ORDER BY `date_viewed` DESC
 LIMIT 10 ?>

SELECT `MV`.`title_id`, COUNT(MV.title_id) AS title_count, `title`, `prefix`, `year`
FROM `ml_movie_titles` `MT`
JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
GROUP BY `title_id`
ORDER BY `title_count` DESC, MAX(date_viewed) DESC
 LIMIT 10 ?>

SELECT DISTINCT(JME.event_id), `event_title`, `event_start_date`, `event_end_date`
FROM `ml_junction_movies_events` `JME`
JOIN `ml_movie_events` `EV` ON `EV`.`event_id` = `JME`.`event_id`
ORDER BY `event_start_date` DESC
 LIMIT 10 ?>

SELECT L.list_id, COUNT(DISTINCT(JTL.title_id)) AS total, title, prefix, timestamp
FROM `ml_lists` `L`
LEFT JOIN `ml_junction_titles_lists` `JTL` ON `L`.`list_id` = `JTL`.`list_id`
GROUP BY `L`.`list_id`
ORDER BY `timestamp` DESC
 LIMIT 10 ?>

SELECT MAX(director_name) AS director_name, `DR`.`tmdb_director_id`, COUNT(DISTINCT(MV.title_id)) AS movies_viewed, COUNT(DISTINCT(MV.movie_id)) AS total_viewed
FROM `ml_movies` `MV`
JOIN `ml_junction_movies_directors` `JMD` ON `MV`.`title_id` = `JMD`.`title_id`
JOIN `ml_directors_new` `DR` ON `JMD`.`tmdb_director_id` = `DR`.`tmdb_director_id`
GROUP BY `DR`.`tmdb_director_id`
ORDER BY `total_viewed` DESC, `movies_viewed` DESC
 LIMIT 10 ?>

SELECT `actor_name`, `tmdb_actor_id`, `total_viewed`, `movies_viewed`
FROM `ml_lookup_top_actors`
ORDER BY `total_viewed` DESC, `movies_viewed` DESC
 LIMIT 10 ?>

SELECT COUNT(title_id) as weekly_viewed
FROM `ml_movies`
WHERE `date_viewed` > '2026-03-27' ?>

SELECT COUNT(title_id) as monthly_viewed
FROM `ml_movies`
WHERE `date_viewed` > '2026-03-04' ?>

SELECT COUNT(title_id) as yearly_viewed
FROM `ml_movies`
WHERE `date_viewed` > '2025-04-03' ?>

SELECT COUNT(title_id) as current_year_viewed
FROM `ml_movies` `MV`
WHERE YEAR(MV.date_viewed) = '2026' ?>

SELECT COUNT(title_id) as total_viewed
FROM `ml_movies` ?>

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, genre_name ASC
             LIMIT 10 ?>

SELECT `JMT`.`tag_id`, COUNT(JMT.tag_id) AS tag_count, `tag`
FROM `ml_junction_movies_tags` `JMT`
JOIN `ml_tags` `TG` ON `TG`.`tag_id` = `JMT`.`tag_id`
JOIN `ml_movies` `MV` ON `MV`.`movie_id` = `JMT`.`movie_id`
GROUP BY `JMT`.`tag_id`
ORDER BY `tag_count` DESC, `tag` ASC
 LIMIT 10 ?>

SELECT MAX(IF(device_name IS NULL, 'No device listed', device_name)) AS device_name, COUNT(MV.device_id) AS device_count, IF(MV.device_id IS NULL, 0, MV.device_id) AS device_id
FROM `ml_movies` `MV`
LEFT JOIN `ml_lookup_devices` `DV` ON `MV`.`device_id` = `DV`.`device_id`
GROUP BY `device_id`
ORDER BY `device_count` DESC, `device_name` ASC
 LIMIT 10 ?>

SELECT MAX(IF(format_name IS NULL, 'No format listed', format_name)) AS format_name, COUNT(MV.format_id) AS format_count, IF(MV.format_id IS NULL, 0, MV.format_id) AS format_id
FROM `ml_movies` `MV`
LEFT JOIN `ml_lookup_formats` `FM` ON `MV`.`format_id` = `FM`.`format_id`
GROUP BY `format_id`
ORDER BY `format_count` DESC, `format_name` ASC
 LIMIT 10 ?>

SELECT MAX(IF(source_name IS NULL, 'No source listed', source_name)) AS source_name, COUNT(MV.source_id) AS source_count, IF(MV.source_id IS NULL, 0, MV.source_id) AS source_id
FROM `ml_movies` `MV`
LEFT JOIN `ml_lookup_sources` `SC` ON `MV`.`source_id` = `SC`.`source_id`
GROUP BY `source_id`
ORDER BY `source_count` DESC, `source_name` ASC
 LIMIT 10 ?>

Array
(
)