- 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(5756,5757,5758,5759,5760,5761,5762,5763,5764,5765,5766,5767,5768,5769,5770' 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 13:10:39'
AND dr.end_time > '2024-04-27 13:10:39'
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(5756,5757,5758,5759,5760,5761,5762,5763,5764,5765,5766,5767,5768,5769,5770,5771,5772,5773,5774,5775,9971,28801,28802,28803,28804,28805,28806,29949,33257,51643,53198,53298,53443,53444,53445,56670,56671,56672,57922,58397,59203,59205,59762,59782,59799,59818,61834,61841,61853,62012,62085,63401,63508,63596,63597,64242,64704,64855,64856,64857,64858,64859,64860,64861,64878,64879,65406,65407,66091,66551,67012,67755,67756,67757,67758,67759,67760,67761,68348,68349,68650,68951,68952)