| SELECT torrents.* , categories.name as catname , categories.image as catimage, users.username, users.class FROM torgenres LEFT JOIN torrents ON(torrents.id=torgenres.torid) LEFT JOIN categories ON (torrents.category=categories.id) LEFT JOIN users ON(torrents.owner=users.id) WHERE torgenres.genreid=47 AND torrents.moderated='yes' AND torrents.visible='yes' AND torrents.banned='no' GROUP BY torrents.id ORDER BY torrents.moderateddate DESC LIMIT 0, 20 |
