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_86 as PROPERTY_STRIP_COUNT , B.PROPERTY_55 as PROPERTY_THICKNESS , B.PROPERTY_56 as PROPERTY_CHAMFER , B.PROPERTY_54 as PROPERTY_SURFACE
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-26 04:54:29' AND (C.REGION IN ()) AND C.PRICE>0 AND A.IBLOCK_SECTION_ID IN (9499,7386,7352,13689,13690,13691,13692,2186,4313,4197,3286,6183,4527,4526,3285,4198,3289,3268,5411,5899,5900,5016,5438) 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 (9499,7386,7352,13689,13690,13691,1' at line 8]
DB query error.
Please try later.
|
|
