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