Skip to content

Instantly share code, notes, and snippets.

@davejachimiak

davejachimiak/relevant_main_genres_query.sql

Created October 16, 2013 02:06
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save davejachimiak/7001555 to your computer and use it in GitHub Desktop.
Save davejachimiak/7001555 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
relevant_main_genres_query.sql
SELECT DISTINCT main_genres.*
FROM main_genres
JOIN movie_genres ON movie_genres.genre_id = main_genres.genre_id
JOIN netflix_instant_movies ON netflix_instant_movies.id = movie_genres.netflix_instant_movie_id
JOIN rotten_tomatoes ON rotten_tomatoes.netflix_instant_movie_id = netflix_instant_movies.id
JOIN netflix_instant_movie_imports ON netflix_instant_movie_imports.netflix_instant_movie_id = netflix_instant_movies.id
JOIN netflix_instant_imports ON netflix_instant_imports.id = netflix_instant_movie_imports.netflix_instant_import_id
WHERE netflix_instant_imports.id =
(SELECT id
FROM netflix_instant_imports
ORDER BY created_at DESC LIMIT 1)
AND rotten_tomatoes.critics_rating != '-1'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment