select * from yc4_item a join yc4_category b on a.ca_id=b.ca_id where 1 and a.it_use=1 and b.ca_use=1 and (trim(BOTH '(주)' from a.it_maker) RLIKE '^(ㄱ|ㄴ)' or ( trim(both '(주)' from (a.it_maker)) >= '가' and trim(both '(주)' from (a.it_maker)) < '나')) group by a.it_maker order by binary(trim(BOTH '(주)' from a.it_maker)) asc

1 : Can't create/write to file '/tmp/#sql_140b_0.MYI' (Errcode: 28)

error file : /shop/topmaker.php