Conia

select DISTINCT(a.it_id), a.* from `g5_shop_item` a left join `g5_shop_item_option` b on (a.it_id = b.it_id) where a.it_lan like '%ko_KR%' and a.it_auction = '0' and a.it_creator = '' and ( upper(b.io_id) like '%Brown%' ) and ( a.ca_id like '3008%' or a.ca_id2 like '3008%' or a.ca_id3 like '3008%' ) and a.it_use = '1' and a.it_confirm = '1' and a.it_company = 'jn2726' order by a.it_order , a.it_id desc limit 0 , 20

1021 : Disk full (/tmp/#sql_140c_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

error file : /shop/myshop.php