In Cinemas Now
UFO UFO
SELECT rev_dvd.*, rev_films.*, rev_bluray.productid AS blurayproductid, rev_regions.name AS regionname, rev_ratings2.name AS ratingname FROM `rev_films` LEFT JOIN `rev_dvd` ON rev_films.dvdid = rev_dvd.id LEFT JOIN `rev_bluray` ON rev_films.blurayid = rev_bluray.id LEFT JOIN `rev_regions` ON rev_films.region = rev_regions.id LEFT JOIN `rev_ratings2` ON rev_dvd.rating = rev_ratings2.id WHERE rev_dvd.deleted = '0' and rev_dvd.date < NOW() ORDER BY rev_dvd.order ASC LIMIT 0,2 Revolver Entertainment | Award Winning Film Distribution