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('80',xg.cate_id) AND xgtpoi.poi_id = 12887 AND xg.goods_id IN (189761,189812,188982,189288,183601,186361,189694,189742,189635,189203,189813,175607,188981,189711,181447,186549,189628,189643,189657,189709,189710,189736,189738,189771,189848,189839,189669,189668,189759,189805,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,189430,189804,189810,185045,189693,167376,188980,181390,189532,189613,189637,189740,189741,189745,189859,189845,188428,189239,189080,184516,189564,189447,189450,189445,180198,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,188200,182676,189846,189823,185341,189023,184602,189478,189598,189081,189689,189528,185773,189336,186457,189352,178329,189161,181812,189817,185897,176983,188973,189579,189294,189370,189766,189765,183607,181644,176485,148886,176531,188457,189856,189841,189363,185861,188394,180738,178595,189369,189186,182267,189563,189782,158376,188674,176389,185039,188931,189781,179173,182296,185899,186047,186830,188972,189118,189767,186613,180134,179188,176529,160780,157183,12757,187357,189842,189834,189462,189348,156952,13235,178077,176492,158252,159405,188983,188984,188653,181954,186481,179345,176526,176490,165096,166339,163353,183542,189849,189341,189475,189019,189426,176471,173389,12752,182563,189323,189824,179127,184495,173387,114788,157845,189006,181389,178070,189441,182841,187862,185974,189115,176482,189769,182860,189556,189724,186602,189533,188520,189537,189599,189376,189752,184452,186800,187304,186819,189808,187015,182944,187291,189531,222,184630,189229,188968,188969,189734,189789,187402,183934,188827,181409,189587,189763,188668,189764,181472,189355,189811,189852,189863,189290,189362,189357,189526,189749,189578,189329,189755,189732,189501,189815,189728,189775,189772,188265,189351,189367,182900,188458,185600,189619,189189,189295,176459,188257,189750,189843,189365,189396,189448,189474,189525,189389,189530,188818,188913,188275,188429,185744,187251,189783,189798,182375,166480,185873,189751,189855,189851,189829,189865,189548,188526,186358,189344,189358,189509,189394,189349,189748,185198,189803,189807,187993,189822,189861,21888,189494,188932,189444,189330,189482,189768,189838,183524,189801,189442,188369,189862,186087,189490,189726,189549,162518,189725,188783,188366,189729,163006,188967,189770,175958,187437,189730,189735,189800,189737,189802,189739,189424,189550,189797,189832,189816,189758,189826,189825,189831,188263,189361,189458,189684,188915,189853,189773,177619,182794,171452,189747,189731,189547,189190,189847,189449,189204,185083,188905,189793,189836,189542,189098,181558,182560,186270,189345,188918,185900,189858,178130,189850,189833,233,189827,189498,237,185972,186617,186339,221,189864,164958,189487,176423,189733,189303,189835,179911,189306) 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]