query:SELECT DISTINCT Movies.id, episodeNum, title, year, cbw, synopsis, rating, season, hasShort, parentMovieId, avail, availLoc FROM (Movies INNER JOIN MovieGenreLists As g1 ON Movies.id=g1.movieId INNER JOIN MovieGenreLists AS g2 ON Movies.id=g2.movieId) WHERE ((parentMovieId=0) AND ((g1.genreId=12))) ORDER BY season ASC, episodeNum ASC;
1 Results displayed in Ultimate QuickRef View™
Ep # Av Title Year C/BW Genre Synopsis Rating
MC01PsREEFER MADNESS1936BWED A dramatizaion of what happens when a complete square gets hooked on The Reefer, goes insane and shoots his girlfriend. Very factual.3.53.53.53.5

    MST3Kdb.com design and original content © 2005 BoB McClure
    Mystery Science Theater 3000 © Best Brains, Inc.   -   All other imagery and information © its respective owner or else public domain