SELECT count(distinct ci.item_id) as total_records, c.category_name as name, c.cat_file_name as file_name, GROUP_CONCAT(i.item_id) as item_ids, ci.sub_cat_id FROM categories c INNER JOIN categories_items ci ON c.cat_id = ci.sub_cat_id INNER JOIN items i ON ci.item_id = i.item_id INNER JOIN county_items cti ON i.item_id = cti.item_id WHERE ci.ikind_id='16' AND cti.county_id = '425' AND ci.cat_id = '5' AND i.item_status='live' GROUP BY ci.sub_cat_id ORDER BY category_name ASC [nativecode=1030 ** Got error 28 from storage engine]
Failed: DB Error: unknown error