MySQL Error[1267]: Illegal mix of collations (gbk_chinese_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'
MySQL Query:SELECT xg.goods_id, xg.closed,xg.title, xg.price, xg.vip_price, xg.start_place, xg.start_nation, xg.start_province, xg.start_city, xg.default_image, xg.last_start_time, xg.special_price, allowance, store_id_n,xg.is_elect FROM lym_xl_goods xg WHERE FIND_IN_SET('3',xg.cate_id) AND xg.days >= 11 AND (xg.title LIKE '%北京延庆区反差婊哪里约(V电✅16511000789老李✅)[快速安排]最靠谱的外围模特经纪HcHylKOs9%' OR xg.start_place LIKE '%北京延庆区反差婊哪里约(V电✅16511000789老李✅)[快速安排]最靠谱的外围模特经纪HcHylKOs9%' OR xg.multitag LIKE '%北京延庆区反差婊哪里约(V电✅16511000789老李✅)[快速安排]最靠谱的外围模特经纪HcHylKOs9%' OR xg.cate_name LIKE '%北京延庆区反差婊哪里约(V电✅16511000789老李✅)[快速安排]最靠谱的外围模特经纪HcHylKOs9%') AND closed = 0 AND is_dispaly = 0 and store_id_n in (0000,13396,217,13421,13599,12606,13578,12175,13301,240,392,11054,13434,13435,13261,13453,13464,13469,13491,13611,13545,10568,13594,13595,13598,13609,13591,13403,13112,13523,11420,13514,13439,13342,13406,13568,5215,13529,462,13409,13530,13612,10791,13614,12507,13544,13498,13617) ORDER BY is_elect desc,store_id_n=12849 DESC, allowance=10 DESC, order_algorithm_max_long desc LIMIT 0,30
Wrong File: /core/model/mysql.php[398]
返回上一页
我们拥有100w+ 精准的户外爱好者用户
微信号:kongxg8264