MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => select g.goods_id, g.goods_name,g.cat_id, g.goods_name_style, g.market_price, g.shop_price AS org_price, g.promote_price,promote_start_date,promote_end_date, IFNULL(mp.user_price, g.shop_price * '1') AS shop_price, g.goods_thumb, goods_img, b.brand_name,g.is_xunjia, g.is_best, g.is_new, g.is_hot, g.is_promote, RAND() AS rnd from `dpr`.`dpr_goods` g left join `dpr`.`dpr_brand` b on g.brand_id=b.brand_id LEFT JOIN `dpr`.`dpr_member_price` AS mp ON mp.goods_id = g.goods_id AND mp.user_rank = '0' where g.is_on_sale=1 AND g.is_alone_sale=1 AND g.is_delete=0 AND g.is_xunjia = 0 order by ((case when g.keywords like '%SIEMENS%' OR g.goods_name like '%SIEMENS%' THEN 12 ELSE 0 END) + (case when g.keywords like '%Matrix%' OR g.goods_name like '%Matrix%' THEN 11 ELSE 0 END) + (case when g.keywords like '%Allen-Bradley%' OR g.goods_name like '%Allen-Bradley%' THEN 10 ELSE 0 END) + (case when g.keywords like '%IFM%' OR g.goods_name like '%IFM%' THEN 9 ELSE 0 END) + (case when g.keywords like '%NOVOTECHNIK%' OR g.goods_name like '%NOVOTECHNIK%' THEN 8 ELSE 0 END) + (case when g.keywords like '%PHOENIX%' OR g.goods_name like '%PHOENIX%' THEN 7 ELSE 0 END) + (case when g.keywords like '%OMRON%' OR g.goods_name like '%OMRON%' THEN 6 ELSE 0 END) + (case when g.keywords like '%Festo%' OR g.goods_name like '%Festo%' THEN 5 ELSE 0 END) + (case when g.keywords like '%JUMO%' OR g.goods_name like '%JUMO%' THEN 3 ELSE 0 END) + (case when g.keywords like '%HYDAC%' OR g.goods_name like '%HYDAC%' THEN 2 ELSE 0 END) + (case when g.keywords like '%Bimba%' OR g.goods_name like '%Bimba%' THEN 1 ELSE 0 END)(case when g.keywords like '%MULTI-CONTA%' OR g.goods_name like '%MULTI-CONTA%' THEN 0 ELSE 0 END)) DESC limit 6 ) [2] => Array ( [error] => 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 '(case when g.keywords like '%MULTI-CONTA%' OR g.goods_name like '%MULTI-CONTA%' ' at line 1 ) [3] => Array ( [errno] => 1064 ) )