• Error type: MySQL Error
• Source, line: Parser::tws_shop_search[1515]
• 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(117694,175268,176215,176216,176824,178398,178396,178397,178455,43079,18...' 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 IN('kDefault', 'kCertificate', 'kEBook', 'kComplect', 'kMarkdown')
                                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 < '2025-11-29 11:02:48'
                                AND dr.end_time > '2025-11-29 11:02:48'
                                AND (s.price - (s.price / 100 * dr.disc_proc)) < s.price
                                AND s.no_visible = 0
                                AND s.kind_key IN('kDefault', 'kCertificate', 'kEBook', 'kComplect', 'kMarkdown')
                        ) AS tblWHERE id IN(117694,175268,176215,176216,176824,178398,178396,178397,178455,43079,180590,180712,180717,187181,187192,187183,190332,195414,195415,195411,195455,195406,64480,190577,190076,193708,192748,194673,192298,194354,198103,179669,197892,198637,78015,199460,199715,197950,202868,202869,203246,199338,203636,205194,205279,205276,205282,205290,205296,199535,206834,227410,228526,228564,227330,228747,229701,228997,229952,229930,235916,236479,236544,236668,236634,236438,237158,228411,237247,239393,239387,239436,239437,239535,239599,240614,241107,241966,241969,88013,244143,244129,244131,244617,245179,246617,246780,240515,45926,252813,253465,129736,195609,63624,254655,254834,254599,141744,199724,255376,59137,255467,236673,259129,259130,256592,256594,256760,259131,259642,240328,256346,261221,261258,261263,117601,129373,150382,149554,264938,117571,124923,88530,114124,255358,114133,114119,267878,264708,267780,267779,267781,266958,268313,241733,126341,186587,256286,269411,269413,266724,269861,269884,114115,52594,270537,270540,270552,150383,271635,271728,271777,270538,270539,273844,273250,156596,268587,273905,41404,274413,274469,156594,273865,273289,41402,275657,112663,276257,239799,276711,244112,279470,279482,266074,280758,280947,280948,280951,281147,280950,281211,282144,282336,119493,282998,282994,283019,283180,283878,283881,283828,283829,283830,283945,284260,286219,195821,288265,177039,289194,289264,289267,112589,289603,289728,290324,290328,290369,290523,290733,259117,199694,291963,292248,292296,292300,292309,292336,292308,292312,292316,202976,292965,132393,292966,292916,294042,289299,294159,294173,294186,294188,294369,252796,294444,239389,239753,294446,153628,156595,294448,268242,294711,294484,294487,294681,294685,141922,294874,130819,294879,294954,295002,141662,295081,295085,292294,296393,297546,297681,297821,297835,296154,296158,296156,298211,299164,299715,299778,300272,300296,300295,300507,300912,301106,301876,302138,302139,302189,124292,302829,63905,100201,114961,303564,303566,303726,303728,303795,305216,292259,305687,305684,142466,124922,127438,139975,195851,306683,306843,305930,306915,306890,307031,307177,307838,308094,308096,203280,308242,193357,306914,308537,308736,308749,308670,308710,308745,308652,308694,308724,308730,308660,308729,308665,308689,308697,308743,308876,308657,308741,309074,115845,150371,282145,180748,286220,63206,259564,41597,199462,240319,239597,199713,241930,138750,203257,289266,228688,297680,142348,204429,205273,309428,283056,243272,52723,48771,59004,78409,132319,180117,41409,309712,309602,195407,259443,59012,236268,272902,276719,261238,271776,309905,229712,42453,229706,186268,252797,256207,310169,150373,180589,114971,252821,259543,99548,111692,253463,310063,187893,229716,253464,203309,246982,138748,150449,310072,310544,310556,310558,310632,310634,305865,46346,310781,310788,311408,311411,311417,311419,311587,311592,246781,311820,312038,312108,312023,312711,313067,312651,312660,312666,313145,312334,313196,191680,313401,313405,313396,313525,42965,316028,316036,316049,313270,313272,313273,317575,313194,316556,316594,318070,316653,316252)