• Error type: MySQL Error
• Source, line: Parser::tws_shop_topic[1302]
• Error message: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'id IN(3662,3663,3664,3691,3704,3768,3778,3789,3804,3808,3823,3829,4710,4711,4...' at line 23

 SELECT DISTINCT id
                        FROM (
                            SELECT s.id
                            FROM ms_store s, ms_topic_store ts
                            WHERE s.no_visible=0
                                AND ( s.kind_key = 'kDefault' OR s.kind_key = 'kEBook' OR s.kind_key = 'kComplect' )
                                AND s.price2 > s.price
                                AND s.price > 0
                                AND ts.store_id = s.id
                            UNION ALL
                            SELECT s.id
                            FROM ms_store s
                                JOIN ms_topic_store ts ON s.id = ts.store_id   
                                JOIN ms_disc_group dg ON s.disc_group_id = dg.id  
                                JOIN ms_disc_rate dr ON dr.group_id = dg.id
                            WHERE dr.kind_key = 'kOrder'
                                AND dr.from_sum = 0
                                AND dr.begin_time < '2024-04-25 01:23:23'
                                AND dr.end_time > '2024-04-25 01:23:23'
                                AND (s.price - (s.price / 100 * dr.disc_proc)) < s.price
                                AND s.no_visible = 0
                                AND ( s.kind_key = 'kDefault' OR s.kind_key = 'kEBook' OR s.kind_key = 'kComplect' )
                        ) AS tblWHERE id IN(3662,3663,3664,3691,3704,3768,3778,3789,3804,3808,3823,3829,4710,4711,4722,4758,5153,5469,6851,8316,8321,8346,8353,8365,8407,8408,8409,8412,8413,12350,31148,31262,32322,32356,32716,33424,33426,33429,33461,33473,33478,33483,33980,33981,33983,33990,34018,34019,34038,35214,38887,38889,38890,38915,38947,39357,39958,40175,40176,40197,40198,40199,40388,40804,45950,46276,46489,46490,46809,47089,52416,52765,52919,57255,57839,57840,57841,57843,57845,62133,62134,62922,63933,63935,77292,77789,78064,88362,91912,112134,114515,116097,117872,118191,119656,120360,120365,122285,127408,127418,128482,129016,131027,132481,132580,137590,140324,141275,154008,161103,174079,174611,174612,175846,177156,177450,178223,180037,180806,180808,181508,183394,189844,191141,192700,193184,194466,197499,199679,199680,202355,204355,204368,254314,254319,254348,254379,254506,255412,255415,3785,4754,5157,8344,8415,8419,31151,32506,33989,34017,37107,37242,37771,38945,39961,40188,40191,40353,40591,40592,40593,46740,46824,46834,46849,49212,49381,54261,54425,63934,85939,91917,99616,115068,115069,115447,116005,116010,122564,149785,161649,161650,161652,161653,189471,191710,192291,192562,193442,194688,194859,254336,254399,254431,269491,3699,3702,3780,4744,4818,4893,7965,8278,8319,8328,8335,8336,8339,8351,8352,8356,8360,8373,8646,32337,32358,32505,32507,32760,33425,33442,33972,33973,33974,33975,33976,33977,33978,33979,34613,34652,34709,37244,37246,37416,37497,37615,37616,40104,40177,40335,40349,40362,40390,40645,42181,46275,46487,46488,49389,49390,49398,49404,49413,49414,56659,64939,68638,68714,75712,75716,77365,88075,88366,88367,90120,91918,93081,111090,113470,114251,114342,115515,115593,120816,121097,122657,128535,149771,150838,151381,156626,156975,159329,159538,159556,177580,186255,186258,190045,190318,190363,192342,236535,243087,243270,254339,261336,273909,3685,3745,3746,3747,3748,3749,3750,3751,3752,3753,3754,3756,3816,4752,5158,5349,8363,32263,32329,32330,32347,32348,32415,32424,32465,32471,32478,32485,32518,33480,34618,37248,38837,39847,39931,46272,46736,46800,46814,49407,49409,116049,117104,132575,132581,132582,153076,180735,190842,192309,193167,193711,193897,194292,3679,3680,3681,3686,3769,33416,33417,34179,34190,40182,46830,46835,57256,63620,112127,114740,114741,115448,129010,139821,161039,190581,191946,192692,194363,194858,254318,261334,3667,3668,3682,4717,8259,8432,8434,38376,39946,39949,40189,40594,40596,40608,46184,62124,62125,116022,116023,134643,150547,177832,192130,202301,254403,254415,256801,5152,7848,191704,4615,4705,4746,4748,4749,5009,5010,5013,5015,8295,8301,8306,8326,8396,10193,11200,30510,32497,32533,33985,35064,37247,37770,38866,39134,40389,40653,47097,49393,49399,49440,56700,57267,62379,62380,62381,62382,62383,62387,78921,91058,127034,129021,129022,131690,131692,134878,141832,142109,150180,159537,160344,160345,160346,175479,177109,177111,177641,177695,178533,178544,179463,180249,180730,180733,180739,186284,186285,186286,186315,186690,186694,190092,190477,193454,194003,194072,195313,199671,199674,199678,202371,203327,204142,204299,243903,245644,245645,245646,245648,245649,245650,254327,254368,255009,255416,255794,255796,255797,255798,255799,255800,255801,255802,255803,256948,256949,256950,256951,258517,261337,261338,261453,261454,261455,263675,264244,264245,264246,264247,264248,264717,264718,264719,264720,264721,265290,265869,266833,266834,269020,269021,269022,269492,269494,269593,269594,269595,269596,272468,273296,273878,273881,273882,275503,275504,3670,3694,3737,3738,3739,3755,3757,3758,3770,3786,3805,3827,3838,4236,4237,4686,4707,4709,4715,4727,4728,4729,5159,8304,8305,8362,8372,8424,11018,32367,32369,32370,32371,32373,32374,32384,32458,33452,33457,33471,33472,33475,33476,34006,34176,34191,34192,38573,38574,38575,39942,40103,40171,40172,40173,40582,42670,49405,49425,49426,49427,189571,191040,191217,194073,254410,254416,255004,255008,264645,3777,3784,3822,4720,4726,4730,4731,4733,7882,7883,8309,8313,8324,8325,8329,8333,8337,8340,8347,8348,8349,8354,8358,8359,8364,8425,8428,32261,32324,32331,32345,33459,33944,33986,34014,34015,34016,35215,37267,37619,37620,38038,38361,38378,38967,39956,40181,40242,40341,40945,46192,46788,46789,46792,46799,46815,47094,49383,59165,75715,91911,91916,98290,114997,115467,116009,116015,116050,129011,129013,129024,129025,129033,129034,129035,129036,161658,177108,177627,177628,190256,192679,193002,193071,193121,193490,193853,194835,196484,255005,261333,269488,269489,3741,3762,3766,3767,3830,3889,3893,3894,5087,5917,5918,8308,8310,8433,11024,32334,32487,32488,32520,33423,33427,33460,33987,33996,38363,38965,39959,40174,40347,46264,46265,46794,46858,47099,94390,98289,113492,114484,116024,116035,129017,129018,129020,153295,161643,161648,174113,175358,184811,189549,190474,191627,193669,254417,261335,269490,3700,3764,3765,3783,4743,5946,7849,8286,8293,8374,8410,30177,31065,33997,33999,34020,34490,35342,37240,37241,37249,37410,39080,39934,40200,40583,40584,47093,49391,56658,75745,88308,89125,90477,115463,115973,116008,116034,121417,129037,184135,191418,192127,192234,193997,194321,254648,3743,3759,3781,3782,3801,4234,4706,4761,8318,8338,8392,8420,10291,32326,32335,32382,32405,32508,32511,32536,33466,33467,33484,33485,39382,40345,40644,40742,40966,42589,45906,49376,49377,49380,49386,49387,49395,49397,49408,54262,54427,57375,64214,67315,67317,75714,77364,98291,116037,117131,125908,129014,129580,133177,134629,140354,161646,161647,161672,174070,176430,190692,194575,194866,195317,240323,266197,3760,3761,4235,5154,8317,8341,8383,8391,10471,31041,31042,32365,32389,32402,32410,32451,32455,32460,32477,32492,32517,32521,32528,32531,32532,32535,33456,37415,37769,40581,40646,46186,46850,48041,49306,49374,49378,49411,49416,67298,75711,78693,88078,88305,90480,92493,113485,115471,117511,119892,128506,129012,132579,142127,142338,142446,149864,150187,150188,150190,150191,150192,150193,153140,153478,177578,177625,177632,177633,177636,178434,179780,180734,180736,180737,180805,180809,181795,193980,263360,3763,4232,4233,4735,33464,33481,36635,41557,42946,46326,47132,49406,49410,49428,75708,78319,121815,122289,142470,191397,192632,193693,194011,8330,32351,32353,32361,32503,32580,37198,37245,38372,38373,40338,47098,129582,181793,190877,254316,3828,4239,5155,5347,32355,32475,32476,33998,34451,36313,39292,42686,46844,67316,90030,116004,135735,155060,187221,194019,239435,254335,4737,4740,5156,8292,8303,32268,32336,32416,32481,34003,34189,34650,37784,39141,40647,45901,49375,54263,92383,129019,142075,177593,193510,3744,4614,4718,4725,4766,4770,8270,8315,8357,8448,8449,8451,10458,10466,10468,10469,10470,10662,10758,11598,12343,12778,12779,31146,31207,32260,32323,32327,32354,32390,32398,32412,32413,32430,32432,32486,32542,32543,34638,35216,37261,37262,37264,37484,37925,39687,39960,46735,57266,66861,77223,77363,89696,94388,97684,113493,128670,142294,150189,150209,150244,153600,174143,180738,191092,193332,194280,261525,3740,4738,4739,4751,8287,8421,33991,33994,33995,34008,38360,38946,39950,39951,39952,39953,39954,46491,46737,46739,46791,46840,46845,46847,46848,57257,129015,161660,192219,193295,193500,193726,193848,194300,254390,3616,3742,3896,4741,4750,4759,4760,30180,30181,33035,33036,33428,48037,48038,61656,84930,87553,93599,119788,152084,160188,187968,188882,188883,188884,189145,189295,190271,193341,199570,265286,8320,8327,8405,8406,8414,8416,8422,8423,8426,8435,32264,32448,32472,32474,32479,32539,33945,33946,33971,33982,33993,34000,34007,34009,34010,34011,34012,34013,34174,35204,37622,38367,38368,38377,39224,39947,39962,39964,40105,40756,41000,46798,46817,46825,46831,46836,46837,46851,46852,46853,47090,47095,47372,49372,49373,49388,49392,57254,65918,75709,77752,91616,91913,92072,94152,116039,123835,126248,126250,126501,128611,134735,134761,153294,159069,161635,161638,161668,176417,176418,176439,178559,181185,181187,181800,189901,190617,191967,193056,193374,193415,193821,195467,206126,254317,254362,254430,255125,8652,8653,38364,39945,59166,59167,59168,59169,116014,117759,5896,9928,11017,11019,11020,11021,11022,11023,11025,11026,11027,39409,115070,115071,115072,115073,115074,115075,115092,115093,115094,115095,115096,115097,115098,115103,115104,115105,115106,115107,115108,115109,115110,115131,115132,115133,115134,115135,115410,115446,115449,115450,115466,115468,115469,115470,116031,116032,116048,117487,129970,174245,174297,177800,180217,186287,186288,186289,186290,186291,186292,186322,186692,186695,3799,4762,4763,4764,4765,4767,4768,4769,4875,5148,5151,5565,5645,8298,8299,8300,8366,10455,10456,10457,10472,10473,10474,10475,10664,11199,32332,32494,32499,32500,32501,33474,33477,34642,38365,38366,39963,40180,43064,48036,48040,52364,63931,63932,64216,89080,94386,112642,125565,128560,128750,142060,150195,150196,150197,150200,150202,152987,154560,155118,155216,161674,175362,178537,189768,192890,193761,204360,254432,255418,255421,8271,8288,8312,8417,8418,31181,33988,34167,34201,37083,37250,37352,38974,38975,40106,40187,40654,42588,49401,56796,75713,77110,89938,99614,111721,124667,150446,153250,159536,193382,198030,202300,243039,255006,255007,259470,8331,8334,8427,33479,34172,36802,36803,37197,47096,117760,127799,140521,175364,184248,191351,194508,199667,199675,199676,8342,8343,8403,32340,34004,34643,34657,38369,40190,46801,49384,49415,62251,140801,161628,161629,191345,254411,4712,8367,8368,8369,8370,8371,31186,32325,32328,32394,32395,32435,32436,32437,32438,32440,32441,32484,32522,32525,32529,33482,37239,37779,39125,40658,90481,92494,92495,92496,92497,98293,112487,129023,151895,153038,153301,153302,177581,177640,179781,179782,179783,179784,179785,180732,180740,180741,203108,203109,203110,255126,8277,8311,8314,32758,40192,46802,66839,119863,129009,134646,141723,153405,187193,192645,4723,8294,10588,11854,12362,32489,32490,32759,33623,34149,34558,39275,39423,41560,46448,49369,49370,49371,49417,49418,49419,49421,49424,53929,56756,58145,68640,68642,76922,81400,87638,87730,88051,89166,90208,91591,92305,92740,112203,112915,114252,114259,115052,115820,116044,116045,116069,116550,117083,117508,123903,124572,124655,128713,131660,131664,133174,137510,139268,140811,140821,142233,142291,142292,150493,150722,150845,151388,152132,152499,153273,153522,154273,174548,177040,178284,180318,193399,193402,194274,198854,198855,202870,205277,236271,256803,263673,3779,8375,8404,255003,7658,7659,7660,7662,10160,10161,10162,10163,10164,10290,10303,10306,10829,10830,10831,10834,31179,31672,31697,31728,32785,32948,34693,34694,34695,34696,34697,34698,34699,34700,34701,34702,34936,36199,36931,36932,36933,36934,37318,38013,39171,39299,39358,39359,39569,39571,39572,39573,39574,39575,39576,40391,41070,41071,41072,41073,41074,41075,41076,41077,41078,41079,41080,41081,41082,41083,41084,41085,41086,41087,41088,41089,41090,41091,46024,46492,46493,47056,48020,49420,49422,49423,54264,54397,54428,58965,63163,77424,77432,77484,78103,78104,78105,78106,78107,78108,78192,78227,78228,78229,78230,78231,78232,78233,78260,78261,78262,78263,78270,78272,78273,78274,78275,78276,78277,78278,78279,78280,78282,78283,78284,78285,78286,78287,78288,78289,78290,78292,78293,78294,78295,78296,78297,78298,78299,78301,78786,79508,81337,81338,81339,81340,81341,81342,94391,94393,94394,94395,94396,94397,94399,94400,111724,114255,114703,114704,117132,117624,119837,119840,134861,139578,140352,140353,140536,141602,141787,149583,150445,151936,157079,187161,193074,193112,193703,193877,194020,194131,194143,195766,203699,32267,32363,33419,34001,34002,34005,37621,49385,49394,49396,49412,177623,180731,32379,32380,32392,32463,37237,45904,49382,49402,114887,115827,129391,142296,159539,191399,194433,194831,255002,33470,40178,40193,40342,37485,37494,37495,37496,39943,39944,39999,40000,40579,46818,46819,46820,46821,115444,115464,115465,115484,116006,116007,116016,254387,255413,255414,14464,33441,37486,38062,39955,39957,46171,46826,46827,46828,46854,49403,62127,63068,114256,116040,135738,192957,202226,254428,37501,38362,40580,46183,46790,46795,46796,46839,46857,49400,62126,75710,112488,114739,116046,116047,116051,116052,119482,123879,129244,179628,183388,190697,194177,238472,254361,254394,254398,255417,255422,37614,39104,46185,46797,46816,46832,46833,46838,57251,57252,87681,87682,92488,141390,174091,175138,194439,37618,38374,38375,39932,39933,46191,46274,46485,46486,115400,116025,116033,116041,116042,193363,46182,116043,134644,199666,257114,257115,269487,75726,75727,75734,75735,79699,81309,81314,81348,81389,88082,89639,89726,90088,91635,92860,94141,94155,94181,94198,99765,100362,100370,114262,114392,115055,115329,115547,115560,115606,115835,115836,116229,118519,118572,118573,118704,118706,118738,122678,122680,123838,123908,123909,123911,124579,124580,124666,125544,125670,126276,126812,126821,126822,127059,127223,127224,127303,129321,129324,129341,129390,129677,130369,131909,132320,134711,134824,134894,138359,138761,139694,140642,150448,150695,150966,150967,151724,153654,174221,175461,176849,176861,176884,176892,177270,177281,177515,177715,178131,179960,180097,180098,186447,186594,189599,190070,190460,190855,190981,191105,191234,191556,191565,191753,191910,192076,192081,192096,192440,193113,193208,193258,193324,193646,194718,196496,197780,198555,198556,202354,202635,203293,203296,203297,204957,205187,205792,229507,239385,241931,243023,252270,252531,254649,255419,255420,264414,267774,273906,273907,273908,273914,273917,273919,273921,273922,274131,111716,111717,111718,111719,111720,111722,111723,111725,159055,159056,159057,159058,159059,159060,159061,159062,159063,159064,159065,159066,159068,159095)