• Error type: MySQL Error
• Source, line: Parser::tws_shop_topic[1289]
• 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(55338,59585,59598,59599,59604,59613,59648,60374,60376,60387,60397,60443,65' 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'
                                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-27 12:23:30'
                                AND dr.end_time > '2024-04-27 12:23:30'
                                AND (s.price - (s.price / 100 * dr.disc_proc)) < s.price
                                AND s.no_visible = 0
                                AND s.kind_key = 'kDefault' 
                        ) AS tblWHERE id IN(55338,59585,59598,59599,59604,59613,59648,60374,60376,60387,60397,60443,65175,65176,65177,65178,65179,65180,65181,65182,65183,65184,65185,65186,65187,65189,65190,65191,65192,65193,65194,65195,65196,65197,65198,65199,65200,65201,65202,65204,65205,65206,65207,65208,65209,65423,65424,65429,65430,65431,65671,66330,66331,66332,66333,66334,66335,66336,66337,66338,66339,66340,66341,66342,66343,66344,67195,67196,67197,67198,67199,67200,67201,67202,67203,67204,67205,67206,67207,67208,67209,67210,67211,67212,67213,67214,67215,67216,67217,67218,67219,67220,67221,67222,67223,67224,67225,67226,67227,67228,67229,67230,67231,67232,67233,67234,67235,67236,67237,67238,67239,67240,67241,67242,67243,67244,67245,67246,67247,67248,67249,67250,67251,67252,67253,67254,67255,67256,67257,67258,67259,67260,67261,67262,67263,67264,67266,67267,67268,67269,67270,67271,67272,67273,67274,67275,67277,68193,68195,68196,68197,68198,68199,68200,68201,68202,68203,68204,68205,68206,68559,68560)