SELECT A.*,case A.cat_order when 0 then 999 else A.cat_order end as cat_orders,B.sCort
					from bb_product_category A ,bb_product_category B 
					where A.user_id = '2650' and A.com_id = '2717' 
					and substring(B.sCort,1,length(A.sCort))=A.sCort
					and A.cat_state = 1 and A.cat_parentid = 10425
					 and A.cat_bbt_state <> 2
					group by A.cat_id
					order by A.cat_orderGot error 24 from storage engine