SELECT A.*,case A.cat_order when 0 then 999 else A.cat_order end as cat_orders,B.sCort, (SELECT GROUP_CONCAT(keyword SEPARATOR ',') as bs from cps_pcat_keywords where cat_id = A.cat_id and state = 1) AS cat_keywords, count(C.pro_id) as cat_pro_nums from cps_product_category A ,cps_product_category B left join cps_product C on C.cat_id = B.cat_id and C.pro_state=1 where substring(B.sCort,1,length(A.sCort))=A.sCort and A.cat_state = 1 and A.cat_parentid = 0 group by A.cat_id order by A.cat_orderTable './jpfw_oajewelry/cps_product' is marked as crashed and should be repaired