SELECT A.*,case A.cat_order when 0 then 999 else A.cat_order end as cat_orders,B.sCort, count(C.pro_id) as cat_pro_nums from bb_product_category A ,bb_product_category B left join bb_product C on C.cat_id = B.cat_id and C.pro_state=1 and C.pro_bbt_state <> 2 and C.pro_online_date<='2024-07-21 17:33:38' and C.pro_online_date!='0000-00-00 00:00:00' and C.user_id = '1415' and C.com_id = '1675' where A.user_id = '1415' and A.com_id = '1675' 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)