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 '%MRO%' OR g.goods_name like '%MRO%' THEN 7 ELSE 0 END) + (case when g.keywords like '%MRO工业品%' OR g.goods_name like '%MRO工业品%' THEN 6 ELSE 0 END) + (case when g.keywords like '%mro行业%' OR g.goods_name like '%mro行业%' THEN 5 ELSE 0 END) + (case when g.keywords like '%mro采购%' OR g.goods_name like '%mro采购%' THEN 4 ELSE 0 END) + (case when g.keywords like '%mro平台%' OR g.goods_name like '%mro平台%' THEN 2 ELSE 0 END) + (case when g.keywords like '%mro商城%' OR g.goods_name like '%mro商城%' THEN 1 ELSE 0 END)(case when g.keywords like '%mro网站%' OR g.goods_name like '%mro网站%' 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 '%mro网站%' OR g.goods_name like '%mro网站%' THEN' at line 1 ) [3] => Array ( [errno] => 1064 ) )