Disclaimer: ChinaDaily.com(dba China Daily Information) is in no way affiliated with China Daily Newspaper or chinadaily.com.cn
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '=en GROUP BY a.subcatid' at line 6SELECT a.subcatid, COUNT(adid) as sub_adcount FROM clf_ads a INNER JOIN clf_subcats scat ON scat.subcatid = a.subcatid AND (a.enabled = '1' AND a.verified = '1' AND a.expireson >= NOW()) INNER JOIN clf_cities ct ON a.cityid = ct.cityid WHERE scat.catid = 1 AND a.cityid = 4〈=en GROUP BY a.subcatid