157
MySQL Query Error: SELECT A.ID,A.NAME as NAME,A.CODE as CODE, A.PREVIEW_PICTURE as PREVIEW_PICTURE, A.IBLOCK_SECTION_ID as SECTION_ID,
A.DETAIL_PICTURE as DETAIL_PICTURE,A.PREVIEW_TEXT as PREVIEW_TEXT,A.DETAIL_TEXT as DETAIL_TEXT,
A.XML_ID as XML_ID,B.PROPERTY_90 AS FORUM_MESSAGE, B.PROPERTY_155 as MOTHER, MIN(C.PRICE) as DTM, MAX(C.TIMESTAMP_X) as PRICE_DATE
, B.PROPERTY_294 as PROPERTY_COUNTRY_PRODUCER , B.PROPERTY_167 as PROPERTY_VID1
FROM b_iblock_element A
LEFT JOIN b_iblock_element_prop_s8 B ON (A.ID=B.IBLOCK_ELEMENT_ID)
LEFT JOIN alexkova_priceplatform C ON (C.PRODUCT_CODE=A.XML_ID)
WHERE A.IBLOCK_ID=8 AND A.ACTIVE='Y' AND C.TIMESTAMP_X > '2023-04-25 18:24:28' AND (C.REGION IN ()) AND C.PRICE>0 AND A.IBLOCK_SECTION_ID IN (8946,8947,8948,8949,9392,9594,9595,9596,8852,7533,8515,8516,8517,8518,8530,8533,8534,6133,7868,9593,9592,7869,15992,15993,15995,7534,7535,7536,7919,7914,8557,8556,7449,7450,7451,2194,3167,3168,2195,3822,3673,3753,3751,9411,9412,9413,3674,3678,3679,3680,6231,6232,2181,2182,2183,2184,6757,6758,6759,4974,5901,5902,5903,3808,3809,3810,6017,6018,3821,6693,3874,3812,6754,6755,6756,5423,3817,3805,3806,3807,6541,3818,3878,3879,3911,3912,6131,3813,3875,3876,3877,5154,6459,6015,6016,6985,7072,7861,7865,7862,7866) GROUP BY A.ID ORDER BY A.SORT DESC, PRICE_DATE desc[You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) AND C.PRICE>0 AND A.IBLOCK_SECTION_ID IN (8946,8947,8948,8949,9392,9594,9595' at line 8]
DB query error.
Please try later.
|
|
