SELECT DISTINCT filmId AS Id FROM STATS.StatsFilmTotals_1 WHERE filmId !="" ORDER BY total DESC LIMIT 100SELECT DISTINCT tvShowId AS Id FROM STATS.StatsTvTotals_1 WHERE tvShowId !="" ORDER BY total DESC LIMIT 100SELECT DISTINCT F.dvdId AS Id FROM KEVIN.Dvds F, STATS.StatsDvdTotals_1 T WHERE F.dvdId=T.dvdId ORDER BY total DESC LIMIT 100
The Simpsons Simpsons Roasting on an Open Fire | MovieWeb
