- 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(2276,2277,2278,2279,2281,2283,2803,2804,2807,2813,2814,2826,2828,2830,3372' 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-25 20:54:14'
AND dr.end_time > '2024-04-25 20:54:14'
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(2276,2277,2278,2279,2281,2283,2803,2804,2807,2813,2814,2826,2828,2830,3372,4963,4977,7035,7036,9368,9369,9370,9371,9372,9374,9376,9377,10424,10786,11099,11100,11173,11174,11191,22621,23016,26333,28522,31210,31216,31217,31219,31237,31239,31240,31241,32510,32513,32514,32962,32964,32965,32966,32967,32968,33434,51697,51884,52060,52093,54714,55012,55013,58323,58460,59726,60039,60082,60893,60894,60895,60896,60897,60898,62596,62597,62598,62599,62600,62601,62602,62603,62604,62605,62606,62607,62608,62609,62610,62611,62612,62613,62614,62615,62616,62617,62618,62619,62620,62621,62622,62623,62624,62625,62626,62627,62628,62629,62630,62631,62632,62633,62634,63342,63355,63356,63357,63358,63359,63360,63361,63362,63367,63368,63369,63370,63371,63372,63373,63374,63375,63376,63377,63385,63594,63602,63603,63604,63623,63998,64238,64239,64240,65845,67443,67444,68524)