DB function failed with error number 1030
Got error 28 from storage engine SQL=SELECT c.id, c.name, COUNT(bs.id) AS total FROM jos_city AS c INNER JOIN jos_building_site AS bs ON bs.property_id_1 = c.id WHERE bs.public= 1 AND bs.is_preempt = 0 AND ( bs.publish_up <= '2010-03-10%' AND ( bs.publish_down >= '2010-03-10%' OR bs.publish_down >= '0000-00-00') ) GROUP BY bs.property_id_1 ORDER BY bs.property_id_1