- 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(5907,5908,5909,5914,5915,5916,5917,5919,5920,5921,5922,5923,5924,5925,5926' 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 11:47:47'
AND dr.end_time > '2024-04-27 11:47:47'
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(5907,5908,5909,5914,5915,5916,5917,5919,5920,5921,5922,5923,5924,5925,5926,10167,10170,10172,24977,24978,24979,25115,25116,25117,25118,28201,28202,28203,28204,28205,28206,28208,28594,29641,29643,29644,29645,29646,29647,29649,29650,50706,50707,50708,51177,53182,53183,53185,53186,53324,53325,53327,53329,53588,53590,53591,53592,53600,53601,53602,53607,53612,53616,53618,53624,53625,53628,53654,53655,53797,53798,53799,53801,53802,53807,53808,53809,53810,53811,53812,53813,53814,53817,54275,54276,54277,54278,54279,54280,54281,54282,54352,54353,55236,55903,55904,55905,56885,56886,56887,56888,56889,56890,56891,57342,57343,57419,58332,58333,58334,58335,58336,58337,58338,58339,58340,58341,58342,58343,58344,58345,61253,61428,64737,64738,64739,64740,64741,64742,64845,66537,67870,68624,68625,68626,68627,68628,68629,68630,68631)