SELECT t.id, t.title, t.production_year, mii.info AS votes, mii2.info AS rating
FROM title t
JOIN movie_info_idx mii ON mii.movie_id = t.id
JOIN movie_info_idx mii2 ON mii2.movie_id = t.id
WHERE t.production_year >= 2008
AND t.kind_id = 1
AND mii.info_type_id = 100
AND mii2.info_type_id = 101
AND mii.info > 100000
ORDER BY mii2.info desc;
SELECT t.id, t.title, t.production_year, mii.info AS votes, mii2.info AS rating FROM title t JOIN movie_info_idx mii ON mii.movie_id = t.id JOIN movie_info_idx mii2 ON mii2.movie_id = t.id WHERE t.production_year >= 2008 AND t.kind_id = 1 AND mii.info_type_id = 100 AND mii2.info_type_id = 101 AND mii.info > 100000 ORDER BY mii2.info desc;