Table './porkypost/clf_ads' is marked as crashed and should be repairedSELECT ct.cityid, c.countryid, COUNT(*) as adcnt
FROM clf_ads a
INNER JOIN clf_cities ct ON ct.cityid = a.cityid AND (a.enabled = '1' AND a.verified = '1' AND a.expireson >= NOW())
INNER JOIN clf_countries c ON ct.countryid = c.countryid
WHERE ct.enabled = '1' AND c.enabled = '1'
GROUP BY ct.cityid