- 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(6568,6569,6570,6585,16378,16382,16383,16389,16402,16426,16427,16429,16430,' 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 05:41:55'
AND dr.end_time > '2024-04-27 05:41:55'
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(6568,6569,6570,6585,16378,16382,16383,16389,16402,16426,16427,16429,16430,16433,16435,16436,16449,16450,16452,16453,16458,53640,53641,53642,53647,53648,53652,53653,54444,58568,58569,58570,58571,58586,63280,63285,63434,64241,64309,64310,64316,64337,64338,64339,64340,64727,64728,64729,65119,65120,65121,65122,65277,65278,65279,65755,66111,66112,66113,66114,66115,66116,66117,66425,66426,66427,66430,66434,66435,66436,66440,66450,66451,66452,66482,67393,67394,67395,67564,67565,67566,67567,67568,67569,67570,67607,67608,67609,67628,67641,67642,67645,67646,67652,67654,68218,68219,68220,68230,68231,68671,68672,68673,68674)