SELECT /* main count 1147 */ COUNT(*) as adcnt FROM clf_ads a WHERE a.cityid = 1147 AND a.catid = 1Table './muamatc_classified/clf_ads#P#india' is marked as crashed and should be repaired