select *, case when model like '%씨즈 C's HM+ 여성 우드%' then 1 when ca_id3 like '001003002%' then 2 else 3 end as s_order from shop_goods where shop_state = '0' and isopen IN('1','2') and (use_aff = '0') and find_in_set('thejon', use_hide) = '0' and index_no NOT IN ('7688','7678','7675','7676','7671','7668','7667','7677','7660','7665','7679','7681','7683','7686','7680','7682','7684','7685','7687','7674','7673','7672','7670','7669','7663','7659','7661','7662','7664','7666','8177','8176','8175','8174','8173','8267') and (ca_id like '001003002%' or ca_id2 like '001003002%' or ca_id3 like '001003002%') order by s_order limit 15

1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's HM+ 여성 우드%' then 1 when ca_id3 like '001003002%' then 2 else 3 end as ' at line 1

error file : /shop/view.php