Qrong query!: Got error 28 from storage engine
SELECT count(1) as 'count', tb2.* FROM `a_items` AS tb1 LEFT JOIN `a_content` AS tb2 ON tb1.`manufacture` = tb2.`id` AND tb2.`type` = 'manufacturer' WHERE tb1.`parent` = '587' AND tb1.`status` = 'enabled' AND tb2.`status` = 'enabled' GROUP BY tb1.`manufacture` ORDER BY `count` DESC LIMIT 4