Table 'xzclf_ads' is marked as crashed and should be repairedSELECT 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())
INNER JOIN xzclf_countries c ON ct.countryid = c.countryid
WHERE ct.enabled = '1' AND c.enabled = '1'
GROUP BY ct.cityid