| 0.0007 |
SELECT 1
FROM `ml_sessions`
WHERE `id` = 'afaed296901dd0aac1323a51218095f40371102c'
AND `ip_address` = '216.73.216.111'
|
| 0.0002 |
SELECT GET_LOCK('01a5a80447c3de00401841cab14f6151', 300) AS ci_session_lock
|
| 0.0003 |
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'afaed296901dd0aac1323a51218095f40371102c'
AND `ip_address` = '216.73.216.111'
|
| 0.0003 |
SELECT `username`, `user_id`, `email_address`, `bio`, `website`
FROM `ml_users`
WHERE `username` = 'deadbeatatdawn'
LIMIT 1
|
| 0.0003 |
SELECT `star_rating`
FROM `ml_users`
WHERE `ml_users`.`user_id` = 60
LIMIT 1
|
| 0.0004 |
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` = 60
ORDER BY `date_viewed` DESC, `date_created` DESC
LIMIT 10
|
| 0.0007 |
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` =60
WHERE `L`.`user_id` = 60
GROUP BY `L`.`list_id`
ORDER BY `timestamp` DESC
LIMIT 10
|
| 0.0004 |
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` = 60
ORDER BY `event_start_date` DESC
LIMIT 10
|
| 0.0005 |
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` = 60
GROUP BY `DR`.`director_id`
ORDER BY `total_viewed` DESC, `movies_viewed` DESC
LIMIT 10
|
| 0.0005 |
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` = 60
AND YEAR(MV.date_viewed) = '2025'
GROUP BY `DR`.`director_id`
ORDER BY `total_viewed` DESC, `movies_viewed` DESC
LIMIT 10
|
| 0.0004 |
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` = 60
AND YEAR(MV.date_viewed) = '2024'
GROUP BY `DR`.`director_id`
ORDER BY `total_viewed` DESC, `movies_viewed` DESC
LIMIT 10
|
| 0.0005 |
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` = 60
AND YEAR(MV.date_viewed) = '2025'
AND MONTH(MV.date_viewed) = '12'
GROUP BY `DR`.`director_id`
ORDER BY `total_viewed` DESC, `movies_viewed` DESC
LIMIT 10
|
| 0.0004 |
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` = 60
AND YEAR(MV.date_viewed) = '2025'
AND MONTH(MV.date_viewed) = '11'
GROUP BY `DR`.`director_id`
ORDER BY `total_viewed` DESC, `movies_viewed` DESC
LIMIT 10
|
| 0.0005 |
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` = 60
GROUP BY `ACT`.`actor_id`
ORDER BY `total_viewed` DESC, `movies_viewed` DESC
LIMIT 10
|
| 0.0003 |
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` = 60
AND YEAR(MV.date_viewed) = '2025'
GROUP BY `ACT`.`actor_id`
ORDER BY `total_viewed` DESC, `movies_viewed` DESC
LIMIT 10
|
| 0.0003 |
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` = 60
AND YEAR(MV.date_viewed) = '2024'
GROUP BY `ACT`.`actor_id`
ORDER BY `total_viewed` DESC, `movies_viewed` DESC
LIMIT 10
|
| 0.0003 |
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` = 60
AND YEAR(MV.date_viewed) = '2025'
AND MONTH(MV.date_viewed) = '12'
GROUP BY `ACT`.`actor_id`
ORDER BY `total_viewed` DESC, `movies_viewed` DESC
LIMIT 10
|
| 0.0003 |
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` = 60
AND YEAR(MV.date_viewed) = '2025'
AND MONTH(MV.date_viewed) = '11'
GROUP BY `ACT`.`actor_id`
ORDER BY `total_viewed` DESC, `movies_viewed` DESC
LIMIT 10
|
| 0.0002 |
SELECT COUNT(title_id) as total_viewed
FROM `ml_movies`
WHERE `user_id` = 60
|
| 0.0003 |
SELECT `MT`.`title_id`
FROM `ml_movie_titles` `MT`
JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 60
AND `date_viewed` > '2025-12-16'
|
| 0.0003 |
SELECT `MT`.`title_id`
FROM `ml_movie_titles` `MT`
JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 60
AND `date_viewed` > '2025-11-23'
|
| 0.0003 |
SELECT `MT`.`title_id`
FROM `ml_movie_titles` `MT`
JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 60
AND `date_viewed` > '2024-12-23'
|
| 0.0003 |
SELECT `MT`.`title_id`
FROM `ml_movie_titles` `MT`
JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 60
AND YEAR(MV.date_viewed) = '2025'
|
| 0.0006 |
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 = 60 UNION ALL
SELECT DISTINCT(title_id), genre_id_02
FROM ml_movies
WHERE user_id = 60 UNION ALL
SELECT DISTINCT(title_id), genre_id_03
FROM ml_movies
WHERE user_id = 60) 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
|
| 0.0005 |
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 = 60 AND YEAR(ml_movies.date_viewed) = 2025 UNION ALL
SELECT DISTINCT(title_id), genre_id_02
FROM ml_movies
WHERE user_id = 60 AND YEAR(ml_movies.date_viewed) = 2025 UNION ALL
SELECT DISTINCT(title_id), genre_id_03
FROM ml_movies
WHERE user_id = 60 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
|
| 0.0006 |
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 = 60 AND YEAR(ml_movies.date_viewed) = 2024 UNION ALL
SELECT DISTINCT(title_id), genre_id_02
FROM ml_movies
WHERE user_id = 60 AND YEAR(ml_movies.date_viewed) = 2024 UNION ALL
SELECT DISTINCT(title_id), genre_id_03
FROM ml_movies
WHERE user_id = 60 AND YEAR(ml_movies.date_viewed) = 2024) 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
|
| 0.0006 |
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 = 60 AND YEAR(ml_movies.date_viewed) = 2025 AND MONTH(ml_movies.date_viewed) = 12 UNION ALL
SELECT DISTINCT(title_id), genre_id_02
FROM ml_movies
WHERE user_id = 60 AND YEAR(ml_movies.date_viewed) = 2025 AND MONTH(ml_movies.date_viewed) = 12 UNION ALL
SELECT DISTINCT(title_id), genre_id_03
FROM ml_movies
WHERE user_id = 60 AND YEAR(ml_movies.date_viewed) = 2025 AND MONTH(ml_movies.date_viewed) = 12) 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
|
| 0.0005 |
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 = 60 AND YEAR(ml_movies.date_viewed) = 2025 AND MONTH(ml_movies.date_viewed) = 11 UNION ALL
SELECT DISTINCT(title_id), genre_id_02
FROM ml_movies
WHERE user_id = 60 AND YEAR(ml_movies.date_viewed) = 2025 AND MONTH(ml_movies.date_viewed) = 11 UNION ALL
SELECT DISTINCT(title_id), genre_id_03
FROM ml_movies
WHERE user_id = 60 AND YEAR(ml_movies.date_viewed) = 2025 AND MONTH(ml_movies.date_viewed) = 11) 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
|
| 0.0005 |
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` = 60
GROUP BY `MV`.`title_id`
ORDER BY MAX(star_rating) DESC, MAX(DATE(MV.date_created)) DESC, `title` ASC
LIMIT 10
|
| 0.0003 |
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` = 60
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
|
| 0.0003 |
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` = 60
AND YEAR(MV.date_viewed) = '2024'
GROUP BY `MV`.`title_id`
ORDER BY MAX(star_rating) DESC, MAX(DATE(MV.date_created)) DESC, `title` ASC
LIMIT 10
|
| 0.0003 |
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` = 60
AND YEAR(MV.date_viewed) = '2025'
AND MONTH(MV.date_viewed) = '12'
GROUP BY `MV`.`title_id`
ORDER BY MAX(star_rating) DESC, MAX(DATE(MV.date_created)) DESC, `title` ASC
LIMIT 10
|
| 0.0003 |
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` = 60
AND YEAR(MV.date_viewed) = '2025'
AND MONTH(MV.date_viewed) = '11'
GROUP BY `MV`.`title_id`
ORDER BY MAX(star_rating) DESC, MAX(DATE(MV.date_created)) DESC, `title` ASC
LIMIT 10
|
| 0.0003 |
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` = 60
GROUP BY `MV`.`title_id`
ORDER BY MAX(star_rating) ASC, MAX(MV.date_created) DESC, `title` ASC
LIMIT 10
|
| 0.0003 |
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` = 60
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
|
| 0.0003 |
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` = 60
AND YEAR(MV.date_viewed) = '2024'
GROUP BY `MV`.`title_id`
ORDER BY MAX(star_rating) ASC, MAX(MV.date_created) DESC, `title` ASC
LIMIT 10
|
| 0.0003 |
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` = 60
AND YEAR(MV.date_viewed) = '2025'
AND MONTH(MV.date_viewed) = '12'
GROUP BY `MV`.`title_id`
ORDER BY MAX(star_rating) ASC, MAX(MV.date_created) DESC, `title` ASC
LIMIT 10
|
| 0.0004 |
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` = 60
AND YEAR(MV.date_viewed) = '2025'
AND MONTH(MV.date_viewed) = '11'
GROUP BY `MV`.`title_id`
ORDER BY MAX(star_rating) ASC, MAX(MV.date_created) DESC, `title` ASC
LIMIT 10
|
| 0.0004 |
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` = 60
GROUP BY `MV`.`rating_id`
ORDER BY `movies` DESC
LIMIT 10
|
| 0.0003 |
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` = 60
AND YEAR(MV.date_viewed) = '2025'
GROUP BY `MV`.`rating_id`
ORDER BY `movies` DESC
LIMIT 10
|
| 0.0003 |
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` = 60
AND YEAR(MV.date_viewed) = '2024'
GROUP BY `MV`.`rating_id`
ORDER BY `movies` DESC
LIMIT 10
|
| 0.0003 |
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` = 60
AND YEAR(MV.date_viewed) = '2025'
AND MONTH(MV.date_viewed) = '12'
GROUP BY `MV`.`rating_id`
ORDER BY `movies` DESC
LIMIT 10
|
| 0.0003 |
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` = 60
AND YEAR(MV.date_viewed) = '2025'
AND MONTH(MV.date_viewed) = '11'
GROUP BY `MV`.`rating_id`
ORDER BY `movies` DESC
LIMIT 10
|
| 0.0004 |
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` = 60
GROUP BY `JMT`.`tag_id`
ORDER BY `tag_count` DESC
LIMIT 10
|
| 0.0003 |
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` = 60
AND YEAR(MV.date_viewed) = '2025'
GROUP BY `JMT`.`tag_id`
ORDER BY `tag_count` DESC
LIMIT 10
|
| 0.0005 |
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` = 60
AND YEAR(MV.date_viewed) = '2024'
GROUP BY `JMT`.`tag_id`
ORDER BY `tag_count` DESC
LIMIT 10
|
| 0.0005 |
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` = 60
AND YEAR(MV.date_viewed) = '2025'
AND MONTH(MV.date_viewed) = '12'
GROUP BY `JMT`.`tag_id`
ORDER BY `tag_count` DESC
LIMIT 10
|
| 0.0005 |
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` = 60
AND YEAR(MV.date_viewed) = '2025'
AND MONTH(MV.date_viewed) = '11'
GROUP BY `JMT`.`tag_id`
ORDER BY `tag_count` DESC
LIMIT 10
|
| 0.0004 |
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` = 60
GROUP BY `DV`.`device_id`
ORDER BY `device_count` DESC
|
| 0.0002 |
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` = 60
AND YEAR(MV.date_viewed) = '2025'
GROUP BY `DV`.`device_id`
ORDER BY `device_count` DESC
|
| 0.0002 |
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` = 60
AND YEAR(MV.date_viewed) = '2024'
GROUP BY `DV`.`device_id`
ORDER BY `device_count` DESC
|
| 0.0002 |
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` = 60
AND YEAR(MV.date_viewed) = '2025'
AND MONTH(MV.date_viewed) = '12'
GROUP BY `DV`.`device_id`
ORDER BY `device_count` DESC
|
| 0.0003 |
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` = 60
AND YEAR(MV.date_viewed) = '2025'
AND MONTH(MV.date_viewed) = '11'
GROUP BY `DV`.`device_id`
ORDER BY `device_count` DESC
|
| 0.0002 |
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` = 60
GROUP BY `FM`.`format_id`
ORDER BY `format_count` DESC
|
| 0.0003 |
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` = 60
AND YEAR(MV.date_viewed) = '2025'
GROUP BY `FM`.`format_id`
ORDER BY `format_count` DESC
|
| 0.0003 |
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` = 60
AND YEAR(MV.date_viewed) = '2024'
GROUP BY `FM`.`format_id`
ORDER BY `format_count` DESC
|
| 0.0003 |
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` = 60
AND YEAR(MV.date_viewed) = '2025'
AND MONTH(MV.date_viewed) = '12'
GROUP BY `FM`.`format_id`
ORDER BY `format_count` DESC
|
| 0.0003 |
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` = 60
AND YEAR(MV.date_viewed) = '2025'
AND MONTH(MV.date_viewed) = '11'
GROUP BY `FM`.`format_id`
ORDER BY `format_count` DESC
|
| 0.0004 |
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` = 60
GROUP BY `SC`.`source_id`
ORDER BY `source_count` DESC
|
| 0.0004 |
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` = 60
AND YEAR(MV.date_viewed) = '2025'
GROUP BY `SC`.`source_id`
ORDER BY `source_count` DESC
|
| 0.0004 |
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` = 60
AND YEAR(MV.date_viewed) = '2024'
GROUP BY `SC`.`source_id`
ORDER BY `source_count` DESC
|
| 0.0004 |
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` = 60
AND YEAR(MV.date_viewed) = '2025'
AND MONTH(MV.date_viewed) = '12'
GROUP BY `SC`.`source_id`
ORDER BY `source_count` DESC
|
| 0.0004 |
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` = 60
AND YEAR(MV.date_viewed) = '2025'
AND MONTH(MV.date_viewed) = '11'
GROUP BY `SC`.`source_id`
ORDER BY `source_count` DESC
|
| 0.0004 |
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` = 60
GROUP BY `title_id`
ORDER BY `title_count` DESC, MAX(date_viewed) DESC
LIMIT 10
|
| 0.0004 |
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` = 60
GROUP BY YEAR(date_viewed)
ORDER BY `year` DESC
LIMIT 10
|
| 0.0003 |
SELECT `MT`.`title_id`
FROM `ml_movie_titles` `MT`
JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 60
AND YEAR(MV.date_viewed) = '2025'
|
| 0.0003 |
SELECT `MT`.`title_id`
FROM `ml_movie_titles` `MT`
JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 60
AND YEAR(MV.date_viewed) = 2024
|
| 0.0004 |
SELECT `MV`.`movie_id`
FROM `ml_movies` `MV`
JOIN `ml_movie_titles` `MT` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 60
AND YEAR(MV.date_viewed) = 2025
AND MONTH(MV.date_viewed) = 12
GROUP BY `MV`.`movie_id`
|
| 0.0003 |
SELECT `MV`.`movie_id`
FROM `ml_movies` `MV`
JOIN `ml_movie_titles` `MT` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 60
AND YEAR(MV.date_viewed) = 2025
AND MONTH(MV.date_viewed) = 11
GROUP BY `MV`.`movie_id`
|
