- 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(65903,65904,66050,66051,66052,66053,66054,66055,66056,66057,66058,66059,66' 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:17:32'
AND dr.end_time > '2024-04-27 13:17:32'
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(65903,65904,66050,66051,66052,66053,66054,66055,66056,66057,66058,66059,66060,66061,66062,66063,66064,66065,66066,66067,66068,66923,66924,66925,66926,66927,66928,66929,66930,66931,66932,66933,66934,66935,66936,66937,66938,66939,66940,66941,66942,66943,66944,66945,66946,66947,66948,66949,66950,66951,66952,66953,66954,66955,66956,66957,66958,66959,66960,66961,66962,66963,66964,66965,66966,66967,66968,66969,66970,66971,66972,66973,66974,66975,66976,66977,66978,66979,66980,66981,66982,66983,66984,66985,66986,66987,66988,66989,66990,66991,66992,66993,66994,66995,66996,67326,67327,67328,67329,67330,67331,67332,67333,67334,67335,67336,68103,68104,68105,68106,68107,68108,68109,68110,68525,68526,68527,68528,68529,68530,68531,68532,68533,68534,68535,68536,68537,68538,68539,68540,68541,68542)