카베진

select * from g5_shop_item a, g5_shop_category b where (a.ca_id = b.ca_id and a.it_use = 1 and b.ca_use = 1) and (concat(REPLACE(a.it_name,' ',''),' ',a.it_explan2,' ',a.it_id,' ',a.it_basic,' ',a.it_1,' ',a.it_2,' ',a.it_3) like '%카베진%' ) order by it_soldout asc, it_sum_qty desc, it_time desc, it_order, it_id desc limit 0, 24