SELECT COUNT(*) AS adcount
FROM xzclf_events a
INNER JOIN xzclf_cities ct ON a.cityid = ct.cityid
LEFT OUTER JOIN xzclf_featured feat ON a.adid = feat.adid AND feat.adtype = 'E'
WHERE (starton <= '2009-07-14' AND endon >= '2009-07-14')
AND a.enabled = '1' AND a.verified = '1' AND a.expireson >= NOW() AND a.paid <> '0'
AND (feat.adid IS NULL OR feat.featuredtill < NOW())
AND a.cityid = 2313Unknown column 'a.paid' in 'where clause'