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