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 = '3676' and A.com_id = '3670' and substring(B.sCort,1,length(A.sCort))=A.sCort and A.cat_state = 1 and A.cat_parentid = 0 and A.cat_bbt_state <> 2 group by A.cat_id order by A.cat_orderCan't create/write to file '/data/tmp/#sql_45c_0.MAI' (Errcode: 28)