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 |