- 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(4125,4127,4128,4129,4132,4133,4134,4138,4139,4140,4141,4143,4150,4151,4183' 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 10:52:04'
AND dr.end_time > '2024-04-27 10:52:04'
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(4125,4127,4128,4129,4132,4133,4134,4138,4139,4140,4141,4143,4150,4151,4183,4195,4219,19045,19046,19047,19049,19050,19053,19062,19063,19065,19068,19071,22573,22574,22575,22576,22580,22587,22588,24558,24562,24564,30239,31144,32971,32973,32974,32975,32978,32979,51854,52528,52529,52530,52531,52542,52543,52544,52545,52546,52547,52548,52549,52550,52551,52552,52553,52554,52555,52556,52557,52558,52559,52560,52561,52562,52563,52564,53043,53045,54715,57108,57109,57110,57854,57855,57857,57858,57859,57860,57861,57862,59190,59191,59581,59748,59749,59750,59751,59752,59753,59754,60943,60946,60947,61539,63218,63255,63605,63606,68704)