SELECT STRAIGHT_JOIN /* All Country page 18 */ a.adid, a.area, a.adtitle, a.addesc, a.cityid, a.subcatid, a.catid, a.createdon,
scat.subcatname, scat.catid, cat.catname, ct.cityname
FROM clf_ads a
INNER JOIN clf_cities ct ON a.cityid = ct.cityid
INNER JOIN clf_subcats scat ON a.subcatid = scat.subcatid
INNER JOIN clf_cats cat ON a.catid = cat.catid
WHERE a.enabled = '1' AND a.verified = '1' AND a.expireson >= NOW()
AND a.cityid = 58
ORDER BY a.createdon DESC
LIMIT 1700, 100MySQL server has gone away |
|