1
MySQL Error[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 '13434,13435,13261,13453,13464,13469,13491,13611,13545,10568,13594,13595,13598,13' at line 1
MySQL Query:SELECT xgtpoi.poi_id,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 STRAIGHT_JOIN lym_xl_goods_tag_poi xgtpoi ON xg.goods_id=xgtpoi.goods_id WHERE FIND_IN_SET('54',xg.cate_id) AND xgtpoi.poi_id = 19587 AND xg.goods_id IN (189786,189813,189759,189854,189844,189449,189204,185083,188905,189345,189430,189793,189804,189810,189852,189424,189357,189526,188428,189749,189578,189329,189755,189239,189080,181558,189732,189731,189501,189815,180198,189775,188200,189846,189864,189367,189361,182900,184602,189458,189550,188458,189598,189684,188915,189797,189303,186457,188257,189081,185897,189528,185773,189336,188457,189856,189853,189843,189841,189832,182294,183598,189365,189396,189448,189474,189525,189389,188818,188918,188913,188191,188275,185900,185744,187251,189783,188698,186338,188394,189751,189858,189855,189851,189842,189834,189495,189467,186358,189344,189358,185198,189773,189306,189803,189807,187993,189849,189861,188932,189341,189840,189838,189323,182794,189547,189190,189809,189556,189724,189533,188520,189537,189599,189376,189752,184452,189762,186800,187304,186819,187015,182944,189726,189549,186270,187291,189531,189847,162518,189758,189725,188783,188366,184630,189229,188968,188969,189747,189734,187402,189729,189770,175958,121101,187437,189730,188827,189587,181472,189355,189836,189362,189487,189498,189805,189290,189548,188526,189481,186087,189483,163006,156825,189393,183569,189392,180233,180234,174146,186111,184509,188263,177619,171452,189203,189098,185341,189023,189363,185861,189824,222,183934,189295,176459,189787,189833,233,189780,189733,186617,189494,189735,237,189789,189790,189788,189860,221,165653,179911,176535,162447,189405,163328) AND xg.days >= 10 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,13339,13568,5215,13529,462,13409,13530,13612,10791,13614,12507,13544,13498,13617,13619,13620,13621,13622) 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]