MST3Kdb.com - The Mystery Science Theater 3000 database

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=5))) ORDER BY season ASC, episodeNum ASC;


3 Results							displayed in Ultimate QuickRef View™


	Ep #	Av	Title	Year	C/BW	Genre	Synopsis	Rating



	510	fc	LASSIE: THE PAINTED HILLS	1951	CLR	WS	A prospector finds gold but is betrayed by his partner. His dog Shep (played by Lassie) seeks out justice for him.



		u	short: BODY CARE AND GROOMING	1950	BW	ED	A college co-ed is not going to land a man, if she looks sloppy and smells bad.



	511	Pv6	GUNSLINGER	1956	CLR	WS	After her husband is gunned down, Rose Hood takes his place as sheriff of a small Western town.



	Ep #	Av	Title	Year	C/BW	Genre	Synopsis	Rating



	611	fc	LAST OF THE WILD HORSES	1948	BW	WS	A cowboy must clear himself of a murder he did not commit. Remedy helps out. Dr. F & Frank riff!

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