Unknown column 'c.countryid' in 'field list'SELECT ct.cityid, c.countryid, COUNT(*) as adcnt
FROM xzclf_ads a
INNER JOIN xzclf_cities ct ON ct.cityid = a.cityid AND (a.enabled = '1' AND a.verified = '1' AND a.expireson >= NOW() AND a.paid <> '0')
INNER JOIN xzclf_countries c ON ct.countryid = c.countryid
WHERE ct.enabled = '1' AND c.enabled = '1'
GROUP BY ct.cityid