select a.* from shop_goods a left join shop_goods_cate b on a.index_no = b.goods_idx left join shop_cate c on b.gcate = c.catecode left join shop_cate d on c.catecode = d.catecode where a.shop_state = 0 and a.shop_open = 0 and a.isopen < 3 and c.u_hide = 0 and (left(a.user_id,3)='AP-' or a.user_id = 'admin' ) and find_in_set('admin', a.use_hide) = '0' and left(b.gcate,0)='' and (a.saccount > a.account and a.account > 0) group by a.index_no order by a.listup desc, a.index_no desc limit 30360, 24

126 : Incorrect key file for table '/home/MYSQL_TMP/#sql_44cd_21.MYI'; try to repair it

error file : /shop/list.php