select title, vidMoviesRanked.vidMoviesID from vidMoviesRanked, vidImages, vidInventory left join daysUntilDue on vidMoviesRanked.vidMoviesID = daysUntilDue.vidMoviesID where (daysUntilDue.days=0) and (vidMoviesRanked.vidMoviesID = vidInventory.vidMoviesID) and (vidInventory.vidConditionID = 2) and (vidMoviesRanked.vidMoviesID = vidImages.vidMoviesID) and (vidImages.imageExists=1) and (1 and genres not like '%X30X%' and genres not like '%X14X%' and genres not like '%X66X%' and genres not like '%X12X%') group by vidMoviesRanked.vidMoviesID order by (sellPrice<=10) desc, vidMoviesID desc limit 0,70 /bargains.php no longer in database.Video Takeout