Movielogr

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

SELECT GET_LOCK('6348ee63c408c3d5a1e1c1a8199c7c70', 300) AS ci_session_lock ?>

SELECT `data`
FROM `ml_sessions`
WHERE `id` = '98a587607e5e5485dda09f54d6fb8a19fe750cc6'
AND `ip_address` = '216.73.216.6' ?>

SELECT `username`, `user_id`, `email_address`, `bio`, `website`
FROM `ml_users`
WHERE `username` = 'phixed'
 LIMIT 1 ?>

SELECT `star_rating`
FROM `ml_users`
WHERE `ml_users`.`user_id` = 82
 LIMIT 1 ?>

SELECT `MV`.`title_id`, `MV`.`movie_id`, `date_created`, `date_viewed`, `title`, `prefix`, `MP`.`filename`
FROM `ml_movies` `MV`
JOIN `ml_movie_titles` `MT` ON `MT`.`title_id` = `MV`.`title_id`
JOIN `ml_movie_posters` `MP` ON `MP`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 82
ORDER BY `date_viewed` DESC, `date_created` DESC
 LIMIT 10 ?>

SELECT L.list_id, COUNT(DISTINCT(JTL.title_id)) AS total, COUNT(DISTINCT(MV.title_id)) AS seen, title, prefix, timestamp
FROM `ml_lists` `L`
LEFT JOIN `ml_junction_titles_lists` `JTL` ON `L`.`list_id` = `JTL`.`list_id`
LEFT JOIN `ml_movies` `MV` ON `JTL`.`title_id` = `MV`.`title_id` AND `MV`.`user_id` =82
WHERE `L`.`user_id` = 82
GROUP BY `L`.`list_id`
ORDER BY `timestamp` 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`
WHERE `EV`.`user_id` = 82
ORDER BY `event_start_date` DESC
 LIMIT 10 ?>

SELECT `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`
WHERE `MV`.`user_id` = 82
GROUP BY `DR`.`director_id`
ORDER BY `total_viewed` DESC, `movies_viewed` DESC
 LIMIT 10 ?>

SELECT `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`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2026'
GROUP BY `DR`.`director_id`
ORDER BY `total_viewed` DESC, `movies_viewed` DESC
 LIMIT 10 ?>

SELECT `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`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2025'
GROUP BY `DR`.`director_id`
ORDER BY `total_viewed` DESC, `movies_viewed` DESC
 LIMIT 10 ?>

SELECT `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`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2026'
AND MONTH(MV.date_viewed) = '04'
GROUP BY `DR`.`director_id`
ORDER BY `total_viewed` DESC, `movies_viewed` DESC
 LIMIT 10 ?>

SELECT `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`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2026'
AND MONTH(MV.date_viewed) = '03'
GROUP BY `DR`.`director_id`
ORDER BY `total_viewed` DESC, `movies_viewed` DESC
 LIMIT 10 ?>

SELECT `actor_name`, `JMA`.`tmdb_actor_id`, COUNT(JMA.tmdb_actor_id) AS total_viewed, COUNT(DISTINCT MV.title_id) AS movies_viewed
FROM `ml_movies` `MV`
JOIN `ml_junction_movies_actors` `JMA` ON `JMA`.`title_id` = `MV`.`title_id`
JOIN `ml_actors_new` `ACT` ON `JMA`.`tmdb_actor_id` = `ACT`.`tmdb_actor_id`
WHERE `MV`.`user_id` = 82
GROUP BY `ACT`.`actor_id`
ORDER BY `total_viewed` DESC, `movies_viewed` DESC
 LIMIT 10 ?>

SELECT `actor_name`, `JMA`.`tmdb_actor_id`, COUNT(JMA.tmdb_actor_id) AS total_viewed, COUNT(DISTINCT MV.title_id) AS movies_viewed
FROM `ml_movies` `MV`
JOIN `ml_junction_movies_actors` `JMA` ON `JMA`.`title_id` = `MV`.`title_id`
JOIN `ml_actors_new` `ACT` ON `JMA`.`tmdb_actor_id` = `ACT`.`tmdb_actor_id`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2026'
GROUP BY `ACT`.`actor_id`
ORDER BY `total_viewed` DESC, `movies_viewed` DESC
 LIMIT 10 ?>

SELECT `actor_name`, `JMA`.`tmdb_actor_id`, COUNT(JMA.tmdb_actor_id) AS total_viewed, COUNT(DISTINCT MV.title_id) AS movies_viewed
FROM `ml_movies` `MV`
JOIN `ml_junction_movies_actors` `JMA` ON `JMA`.`title_id` = `MV`.`title_id`
JOIN `ml_actors_new` `ACT` ON `JMA`.`tmdb_actor_id` = `ACT`.`tmdb_actor_id`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2025'
GROUP BY `ACT`.`actor_id`
ORDER BY `total_viewed` DESC, `movies_viewed` DESC
 LIMIT 10 ?>

SELECT `actor_name`, `JMA`.`tmdb_actor_id`, COUNT(JMA.tmdb_actor_id) AS total_viewed, COUNT(DISTINCT MV.title_id) AS movies_viewed
FROM `ml_movies` `MV`
JOIN `ml_junction_movies_actors` `JMA` ON `JMA`.`title_id` = `MV`.`title_id`
JOIN `ml_actors_new` `ACT` ON `JMA`.`tmdb_actor_id` = `ACT`.`tmdb_actor_id`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2026'
AND MONTH(MV.date_viewed) = '04'
GROUP BY `ACT`.`actor_id`
ORDER BY `total_viewed` DESC, `movies_viewed` DESC
 LIMIT 10 ?>

SELECT `actor_name`, `JMA`.`tmdb_actor_id`, COUNT(JMA.tmdb_actor_id) AS total_viewed, COUNT(DISTINCT MV.title_id) AS movies_viewed
FROM `ml_movies` `MV`
JOIN `ml_junction_movies_actors` `JMA` ON `JMA`.`title_id` = `MV`.`title_id`
JOIN `ml_actors_new` `ACT` ON `JMA`.`tmdb_actor_id` = `ACT`.`tmdb_actor_id`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2026'
AND MONTH(MV.date_viewed) = '03'
GROUP BY `ACT`.`actor_id`
ORDER BY `total_viewed` DESC, `movies_viewed` DESC
 LIMIT 10 ?>

SELECT COUNT(title_id) as total_viewed
FROM `ml_movies`
WHERE `user_id` = 82 ?>

SELECT `MT`.`title_id`
FROM `ml_movie_titles` `MT`
JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 82
AND `date_viewed` > '2026-03-27' ?>

SELECT `MT`.`title_id`
FROM `ml_movie_titles` `MT`
JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 82
AND `date_viewed` > '2026-03-04' ?>

SELECT `MT`.`title_id`
FROM `ml_movie_titles` `MT`
JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 82
AND `date_viewed` > '2025-04-03' ?>

SELECT `MT`.`title_id`
FROM `ml_movie_titles` `MT`
JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2026' ?>

SELECT genre, COUNT(DISTINCT(title_id)) AS genre_count, genre_name
            FROM (SELECT DISTINCT(title_id), genre_id_01 AS genre
            FROM ml_movies
            WHERE user_id = 82 UNION ALL
            SELECT DISTINCT(title_id), genre_id_02
            FROM ml_movies
            WHERE user_id = 82 UNION ALL
            SELECT DISTINCT(title_id), genre_id_03
            FROM ml_movies
            WHERE user_id = 82) 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 ?>

SELECT genre, COUNT(DISTINCT(title_id)) AS genre_count, genre_name
            FROM (SELECT DISTINCT(title_id), genre_id_01 AS genre
            FROM ml_movies
            WHERE user_id = 82 AND YEAR(ml_movies.date_viewed) = 2026 UNION ALL
            SELECT DISTINCT(title_id), genre_id_02
            FROM ml_movies
            WHERE user_id = 82 AND YEAR(ml_movies.date_viewed) = 2026 UNION ALL
            SELECT DISTINCT(title_id), genre_id_03
            FROM ml_movies
            WHERE user_id = 82 AND YEAR(ml_movies.date_viewed) = 2026) 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 ?>

SELECT genre, COUNT(DISTINCT(title_id)) AS genre_count, genre_name
            FROM (SELECT DISTINCT(title_id), genre_id_01 AS genre
            FROM ml_movies
            WHERE user_id = 82 AND YEAR(ml_movies.date_viewed) = 2025 UNION ALL
            SELECT DISTINCT(title_id), genre_id_02
            FROM ml_movies
            WHERE user_id = 82 AND YEAR(ml_movies.date_viewed) = 2025 UNION ALL
            SELECT DISTINCT(title_id), genre_id_03
            FROM ml_movies
            WHERE user_id = 82 AND YEAR(ml_movies.date_viewed) = 2025) 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 ?>

SELECT genre, COUNT(DISTINCT(title_id)) AS genre_count, genre_name
            FROM (SELECT DISTINCT(title_id), genre_id_01 AS genre
            FROM ml_movies
            WHERE user_id = 82 AND YEAR(ml_movies.date_viewed) = 2026 AND MONTH(ml_movies.date_viewed) = 04 UNION ALL
            SELECT DISTINCT(title_id), genre_id_02
            FROM ml_movies
            WHERE user_id = 82 AND YEAR(ml_movies.date_viewed) = 2026 AND MONTH(ml_movies.date_viewed) = 04 UNION ALL
            SELECT DISTINCT(title_id), genre_id_03
            FROM ml_movies
            WHERE user_id = 82 AND YEAR(ml_movies.date_viewed) = 2026 AND MONTH(ml_movies.date_viewed) = 04) 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 ?>

SELECT genre, COUNT(DISTINCT(title_id)) AS genre_count, genre_name
            FROM (SELECT DISTINCT(title_id), genre_id_01 AS genre
            FROM ml_movies
            WHERE user_id = 82 AND YEAR(ml_movies.date_viewed) = 2026 AND MONTH(ml_movies.date_viewed) = 03 UNION ALL
            SELECT DISTINCT(title_id), genre_id_02
            FROM ml_movies
            WHERE user_id = 82 AND YEAR(ml_movies.date_viewed) = 2026 AND MONTH(ml_movies.date_viewed) = 03 UNION ALL
            SELECT DISTINCT(title_id), genre_id_03
            FROM ml_movies
            WHERE user_id = 82 AND YEAR(ml_movies.date_viewed) = 2026 AND MONTH(ml_movies.date_viewed) = 03) 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 ?>

SELECT `MV`.`title_id`, `prefix`, `title`, MAX(MV.movie_id) AS movie_id, MAX(MV.rating_id) AS rating_id, MAX(star_rating) AS star_rating
FROM `ml_movies` `MV`
JOIN `ml_movie_titles` `MT` ON `MV`.`title_id` = `MT`.`title_id`
JOIN `ml_movie_ratings_five_star` `STR` ON `MV`.`rating_id` = `STR`.`rating_id`
WHERE `MV`.`user_id` = 82
GROUP BY `MV`.`title_id`
ORDER BY MAX(star_rating) DESC, MAX(DATE(MV.date_created)) DESC, `title` ASC
 LIMIT 10 ?>

SELECT `MV`.`title_id`, `prefix`, `title`, MAX(MV.movie_id) AS movie_id, MAX(MV.rating_id) AS rating_id, MAX(star_rating) AS star_rating
FROM `ml_movies` `MV`
JOIN `ml_movie_titles` `MT` ON `MV`.`title_id` = `MT`.`title_id`
JOIN `ml_movie_ratings_five_star` `STR` ON `MV`.`rating_id` = `STR`.`rating_id`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2026'
GROUP BY `MV`.`title_id`
ORDER BY MAX(star_rating) DESC, MAX(DATE(MV.date_created)) DESC, `title` ASC
 LIMIT 10 ?>

SELECT `MV`.`title_id`, `prefix`, `title`, MAX(MV.movie_id) AS movie_id, MAX(MV.rating_id) AS rating_id, MAX(star_rating) AS star_rating
FROM `ml_movies` `MV`
JOIN `ml_movie_titles` `MT` ON `MV`.`title_id` = `MT`.`title_id`
JOIN `ml_movie_ratings_five_star` `STR` ON `MV`.`rating_id` = `STR`.`rating_id`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2025'
GROUP BY `MV`.`title_id`
ORDER BY MAX(star_rating) DESC, MAX(DATE(MV.date_created)) DESC, `title` ASC
 LIMIT 10 ?>

SELECT `MV`.`title_id`, `prefix`, `title`, MAX(MV.movie_id) AS movie_id, MAX(MV.rating_id) AS rating_id, MAX(star_rating) AS star_rating
FROM `ml_movies` `MV`
JOIN `ml_movie_titles` `MT` ON `MV`.`title_id` = `MT`.`title_id`
JOIN `ml_movie_ratings_five_star` `STR` ON `MV`.`rating_id` = `STR`.`rating_id`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2026'
AND MONTH(MV.date_viewed) = '04'
GROUP BY `MV`.`title_id`
ORDER BY MAX(star_rating) DESC, MAX(DATE(MV.date_created)) DESC, `title` ASC
 LIMIT 10 ?>

SELECT `MV`.`title_id`, `prefix`, `title`, MAX(MV.movie_id) AS movie_id, MAX(MV.rating_id) AS rating_id, MAX(star_rating) AS star_rating
FROM `ml_movies` `MV`
JOIN `ml_movie_titles` `MT` ON `MV`.`title_id` = `MT`.`title_id`
JOIN `ml_movie_ratings_five_star` `STR` ON `MV`.`rating_id` = `STR`.`rating_id`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2026'
AND MONTH(MV.date_viewed) = '03'
GROUP BY `MV`.`title_id`
ORDER BY MAX(star_rating) DESC, MAX(DATE(MV.date_created)) DESC, `title` ASC
 LIMIT 10 ?>

SELECT `MV`.`title_id`, `prefix`, `title`, MAX(MV.movie_id) AS movie_id, MAX(MV.rating_id) AS rating_id, MAX(star_rating) AS star_rating
FROM `ml_movies` `MV`
JOIN `ml_movie_titles` `MT` ON `MV`.`title_id` = `MT`.`title_id`
JOIN `ml_movie_ratings_five_star` `STR` ON `MV`.`rating_id` = `STR`.`rating_id`
WHERE `MV`.`user_id` = 82
GROUP BY `MV`.`title_id`
ORDER BY MAX(star_rating) ASC, MAX(MV.date_created) DESC, `title` ASC
 LIMIT 10 ?>

SELECT `MV`.`title_id`, `prefix`, `title`, MAX(MV.movie_id) AS movie_id, MAX(MV.rating_id) AS rating_id, MAX(star_rating) AS star_rating
FROM `ml_movies` `MV`
JOIN `ml_movie_titles` `MT` ON `MV`.`title_id` = `MT`.`title_id`
JOIN `ml_movie_ratings_five_star` `STR` ON `MV`.`rating_id` = `STR`.`rating_id`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2026'
GROUP BY `MV`.`title_id`
ORDER BY MAX(star_rating) ASC, MAX(MV.date_created) DESC, `title` ASC
 LIMIT 10 ?>

SELECT `MV`.`title_id`, `prefix`, `title`, MAX(MV.movie_id) AS movie_id, MAX(MV.rating_id) AS rating_id, MAX(star_rating) AS star_rating
FROM `ml_movies` `MV`
JOIN `ml_movie_titles` `MT` ON `MV`.`title_id` = `MT`.`title_id`
JOIN `ml_movie_ratings_five_star` `STR` ON `MV`.`rating_id` = `STR`.`rating_id`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2025'
GROUP BY `MV`.`title_id`
ORDER BY MAX(star_rating) ASC, MAX(MV.date_created) DESC, `title` ASC
 LIMIT 10 ?>

SELECT `MV`.`title_id`, `prefix`, `title`, MAX(MV.movie_id) AS movie_id, MAX(MV.rating_id) AS rating_id, MAX(star_rating) AS star_rating
FROM `ml_movies` `MV`
JOIN `ml_movie_titles` `MT` ON `MV`.`title_id` = `MT`.`title_id`
JOIN `ml_movie_ratings_five_star` `STR` ON `MV`.`rating_id` = `STR`.`rating_id`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2026'
AND MONTH(MV.date_viewed) = '04'
GROUP BY `MV`.`title_id`
ORDER BY MAX(star_rating) ASC, MAX(MV.date_created) DESC, `title` ASC
 LIMIT 10 ?>

SELECT `MV`.`title_id`, `prefix`, `title`, MAX(MV.movie_id) AS movie_id, MAX(MV.rating_id) AS rating_id, MAX(star_rating) AS star_rating
FROM `ml_movies` `MV`
JOIN `ml_movie_titles` `MT` ON `MV`.`title_id` = `MT`.`title_id`
JOIN `ml_movie_ratings_five_star` `STR` ON `MV`.`rating_id` = `STR`.`rating_id`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2026'
AND MONTH(MV.date_viewed) = '03'
GROUP BY `MV`.`title_id`
ORDER BY MAX(star_rating) ASC, MAX(MV.date_created) DESC, `title` ASC
 LIMIT 10 ?>

SELECT `MV`.`rating_id`, COUNT(DISTINCT(MV.title_id)) AS movies, `star_rating`
FROM `ml_movies` `MV`
JOIN `ml_movie_ratings_five_star` `STR` ON `MV`.`rating_id` = `STR`.`rating_id`
WHERE `MV`.`user_id` = 82
GROUP BY `MV`.`rating_id`
ORDER BY `movies` DESC
 LIMIT 10 ?>

SELECT `MV`.`rating_id`, COUNT(DISTINCT(MV.title_id)) AS movies, `star_rating`
FROM `ml_movies` `MV`
JOIN `ml_movie_ratings_five_star` `STR` ON `MV`.`rating_id` = `STR`.`rating_id`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2026'
GROUP BY `MV`.`rating_id`
ORDER BY `movies` DESC
 LIMIT 10 ?>

SELECT `MV`.`rating_id`, COUNT(DISTINCT(MV.title_id)) AS movies, `star_rating`
FROM `ml_movies` `MV`
JOIN `ml_movie_ratings_five_star` `STR` ON `MV`.`rating_id` = `STR`.`rating_id`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2025'
GROUP BY `MV`.`rating_id`
ORDER BY `movies` DESC
 LIMIT 10 ?>

SELECT `MV`.`rating_id`, COUNT(DISTINCT(MV.title_id)) AS movies, `star_rating`
FROM `ml_movies` `MV`
JOIN `ml_movie_ratings_five_star` `STR` ON `MV`.`rating_id` = `STR`.`rating_id`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2026'
AND MONTH(MV.date_viewed) = '04'
GROUP BY `MV`.`rating_id`
ORDER BY `movies` DESC
 LIMIT 10 ?>

SELECT `MV`.`rating_id`, COUNT(DISTINCT(MV.title_id)) AS movies, `star_rating`
FROM `ml_movies` `MV`
JOIN `ml_movie_ratings_five_star` `STR` ON `MV`.`rating_id` = `STR`.`rating_id`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2026'
AND MONTH(MV.date_viewed) = '03'
GROUP BY `MV`.`rating_id`
ORDER BY `movies` DESC
 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`
WHERE `MV`.`user_id` = 82
GROUP BY `JMT`.`tag_id`
ORDER BY `tag_count` DESC
 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`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2026'
GROUP BY `JMT`.`tag_id`
ORDER BY `tag_count` DESC
 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`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2025'
GROUP BY `JMT`.`tag_id`
ORDER BY `tag_count` DESC
 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`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2026'
AND MONTH(MV.date_viewed) = '04'
GROUP BY `JMT`.`tag_id`
ORDER BY `tag_count` DESC
 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`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2026'
AND MONTH(MV.date_viewed) = '03'
GROUP BY `JMT`.`tag_id`
ORDER BY `tag_count` DESC
 LIMIT 10 ?>

SELECT `device_name`, COUNT(DISTINCT(title_id)) AS device_count, `DV`.`device_id`
FROM `ml_movies` `MV`
LEFT JOIN `ml_lookup_devices` `DV` ON `MV`.`device_id` = `DV`.`device_id`
WHERE `MV`.`user_id` = 82
GROUP BY `DV`.`device_id`
ORDER BY `device_count` DESC ?>

SELECT `device_name`, COUNT(DISTINCT(title_id)) AS device_count, `DV`.`device_id`
FROM `ml_movies` `MV`
LEFT JOIN `ml_lookup_devices` `DV` ON `MV`.`device_id` = `DV`.`device_id`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2026'
GROUP BY `DV`.`device_id`
ORDER BY `device_count` DESC ?>

SELECT `device_name`, COUNT(DISTINCT(title_id)) AS device_count, `DV`.`device_id`
FROM `ml_movies` `MV`
LEFT JOIN `ml_lookup_devices` `DV` ON `MV`.`device_id` = `DV`.`device_id`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2025'
GROUP BY `DV`.`device_id`
ORDER BY `device_count` DESC ?>

SELECT `device_name`, COUNT(DISTINCT(title_id)) AS device_count, `DV`.`device_id`
FROM `ml_movies` `MV`
LEFT JOIN `ml_lookup_devices` `DV` ON `MV`.`device_id` = `DV`.`device_id`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2026'
AND MONTH(MV.date_viewed) = '04'
GROUP BY `DV`.`device_id`
ORDER BY `device_count` DESC ?>

SELECT `device_name`, COUNT(DISTINCT(title_id)) AS device_count, `DV`.`device_id`
FROM `ml_movies` `MV`
LEFT JOIN `ml_lookup_devices` `DV` ON `MV`.`device_id` = `DV`.`device_id`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2026'
AND MONTH(MV.date_viewed) = '03'
GROUP BY `DV`.`device_id`
ORDER BY `device_count` DESC ?>

SELECT `format_name`, COUNT(DISTINCT(MV.title_id)) AS format_count, `FM`.`format_id`
FROM `ml_movies` `MV`
LEFT JOIN `ml_lookup_formats` `FM` ON `MV`.`format_id` = `FM`.`format_id`
WHERE `MV`.`user_id` = 82
GROUP BY `FM`.`format_id`
ORDER BY `format_count` DESC ?>

SELECT `format_name`, COUNT(DISTINCT(MV.title_id)) AS format_count, `FM`.`format_id`
FROM `ml_movies` `MV`
LEFT JOIN `ml_lookup_formats` `FM` ON `MV`.`format_id` = `FM`.`format_id`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2026'
GROUP BY `FM`.`format_id`
ORDER BY `format_count` DESC ?>

SELECT `format_name`, COUNT(DISTINCT(MV.title_id)) AS format_count, `FM`.`format_id`
FROM `ml_movies` `MV`
LEFT JOIN `ml_lookup_formats` `FM` ON `MV`.`format_id` = `FM`.`format_id`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2025'
GROUP BY `FM`.`format_id`
ORDER BY `format_count` DESC ?>

SELECT `format_name`, COUNT(DISTINCT(MV.title_id)) AS format_count, `FM`.`format_id`
FROM `ml_movies` `MV`
LEFT JOIN `ml_lookup_formats` `FM` ON `MV`.`format_id` = `FM`.`format_id`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2026'
AND MONTH(MV.date_viewed) = '04'
GROUP BY `FM`.`format_id`
ORDER BY `format_count` DESC ?>

SELECT `format_name`, COUNT(DISTINCT(MV.title_id)) AS format_count, `FM`.`format_id`
FROM `ml_movies` `MV`
LEFT JOIN `ml_lookup_formats` `FM` ON `MV`.`format_id` = `FM`.`format_id`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2026'
AND MONTH(MV.date_viewed) = '03'
GROUP BY `FM`.`format_id`
ORDER BY `format_count` DESC ?>

SELECT `source_name`, COUNT(DISTINCT(MV.movie_id)) AS source_count, `SC`.`source_id`
FROM `ml_movies` `MV`
LEFT JOIN `ml_lookup_sources` `SC` ON `MV`.`source_id` = `SC`.`source_id`
WHERE `MV`.`user_id` = 82
GROUP BY `SC`.`source_id`
ORDER BY `source_count` DESC ?>

SELECT `source_name`, COUNT(DISTINCT(MV.movie_id)) AS source_count, `SC`.`source_id`
FROM `ml_movies` `MV`
LEFT JOIN `ml_lookup_sources` `SC` ON `MV`.`source_id` = `SC`.`source_id`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2026'
GROUP BY `SC`.`source_id`
ORDER BY `source_count` DESC ?>

SELECT `source_name`, COUNT(DISTINCT(MV.movie_id)) AS source_count, `SC`.`source_id`
FROM `ml_movies` `MV`
LEFT JOIN `ml_lookup_sources` `SC` ON `MV`.`source_id` = `SC`.`source_id`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2025'
GROUP BY `SC`.`source_id`
ORDER BY `source_count` DESC ?>

SELECT `source_name`, COUNT(DISTINCT(MV.movie_id)) AS source_count, `SC`.`source_id`
FROM `ml_movies` `MV`
LEFT JOIN `ml_lookup_sources` `SC` ON `MV`.`source_id` = `SC`.`source_id`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2026'
AND MONTH(MV.date_viewed) = '04'
GROUP BY `SC`.`source_id`
ORDER BY `source_count` DESC ?>

SELECT `source_name`, COUNT(DISTINCT(MV.movie_id)) AS source_count, `SC`.`source_id`
FROM `ml_movies` `MV`
LEFT JOIN `ml_lookup_sources` `SC` ON `MV`.`source_id` = `SC`.`source_id`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2026'
AND MONTH(MV.date_viewed) = '03'
GROUP BY `SC`.`source_id`
ORDER BY `source_count` DESC ?>

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

SELECT YEAR(MV.date_viewed) as year, ROUND(SUM(MT.runtime)/60) AS hours_watched
FROM `ml_movies` `MV`
LEFT JOIN `ml_movie_titles` `MT` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 82
GROUP BY YEAR(date_viewed)
ORDER BY `year` DESC
 LIMIT 10 ?>

SELECT `MT`.`title_id`
FROM `ml_movie_titles` `MT`
JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = '2026' ?>

SELECT `MT`.`title_id`
FROM `ml_movie_titles` `MT`
JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = 2025 ?>

SELECT `MV`.`movie_id`
FROM `ml_movies` `MV`
JOIN `ml_movie_titles` `MT` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = 2026
AND MONTH(MV.date_viewed) = 4
GROUP BY `MV`.`movie_id` ?>

SELECT `MV`.`movie_id`
FROM `ml_movies` `MV`
JOIN `ml_movie_titles` `MT` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 82
AND YEAR(MV.date_viewed) = 2026
AND MONTH(MV.date_viewed) = 3
GROUP BY `MV`.`movie_id` ?>

Array
(
)