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('50',xg.cate_id) AND xgtpoi.poi_id = 26727 AND xg.goods_id IN (189533,188520,189537,189599,189376,189752,184452,186800,187304,186819,187015,187291,189531,189847,184630,189229,188968,188969,187402,188827,181409,189587,188668,189764,181472,189761,189812,188982,189288,183601,186361,189694,189742,189635,189813,175607,188981,189711,181447,186549,189628,189643,189657,189709,189710,189736,189738,189771,189848,189839,189669,189668,189759,185428,189799,189305,189446,189796,179063,182532,182533,184457,186479,189188,189395,189480,189502,189529,189614,189659,189698,189700,189743,189746,189753,189754,189784,189821,189785,189818,189503,189449,189204,189497,185083,188905,189430,189793,185045,189693,167376,188980,181390,189532,189613,189637,189740,189741,189745,189836,189859,189852,189845,189819,189863,188428,184516,189564,189447,189450,189445,189527,189331,188979,153426,161806,181829,185969,187388,188467,189037,189147,189228,189366,189371,189378,189457,189636,189702,189744,182813,182061,179541,178432,162200,157181,189593,189081,189528,185773,189336,186457,189352,178329,189161,181812,189817,176983,188973,189579,189294,189370,189766,189765,181644,176485,148886,176531,188457,180738,188394,178595,189369,189186,182267,186674,189563,188674,176389,185039,188931,189781,179173,182296,185899,186830,188972,189118,189782,158376,186047,189767,186613,180134,179188,176529,160780,157183,12757,187357,189820,189462,189394,189349,156952,13235,159405,188983,188984,181954,186481,178077,176492,158252,188653,179345,176526,176490,165096,166339,163353,183542,187993,188932,189444,189341,189475,189019,189426,176471,173389,12752,189542,189323,185365,189342,179127,184495,114788,157845,189006,181389,173387,189801,189857,178070,189441,187862,185974,189115,176482,189769,189724,186602,188801,189800,189737,189802,189739,189203,189805,189804,189810,189098,189239,189080,181558,180198,188200,189846,189823,185341,189023,184602,189478,189598,189689,183607,189841,189363,182560,185861,189842,189834,189824,182841,182860,189808,182944,186270,222,189734,189789,183934,189763,189355,189345,189811,189486,189290,189362,189526,189578,189329,189755,189732,189815,189728,189775,189772,188265,189351,189367,182900,188458,189619,189189,189295,176459,188257,189750,189365,189396,189448,189474,189525,189389,189530,188818,188918,188913,188275,185900,185744,187251,189783,189798,166480,185873,189751,189858,189855,189851,189829,189865,189548,188526,189348,186358,189344,189358,189788,189803,189807,189569,189207,189822,189861,21888,189330,189768,176423,189838,182563,189833,189208,189442,233,189862,186087,176537,189756,186488,189726,189549,189757,189725,188783,188366,188550,185703,189729,163006,189498,188967,189770,175958,187437,189730,189735,237,186617,189424,189550,189797,189856,189832,189816,189758,189826,189825,189831,221,188191,188429,189773,188263,189361,189458,189684,188915,189853,177619,182794,171452,189747,189731,182676,189547,189190,189306,185897,189849,189556) 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]