Ковролин для дома
Регион:
|
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_102 as PROPERTY_TYPE , B.PROPERTY_101 as PROPERTY_NAP_CONTAINS , B.PROPERTY_97 as PROPERTY_NAP_TYPE , B.PROPERTY_98 as PROPERTY_NAP_LENGTH , B.PROPERTY_99 as PROPERTY_BASE , B.PROPERTY_103 as PROPERTY_WIDTH_M 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 23:59:26' AND (C.REGION IN ()) AND C.PRICE>0 AND B.PROPERTY_102 IN ('Ковролин бытовой') AND A.IBLOCK_SECTION_ID IN (8323,9462,9474,9468,9469,1885,8542,13348,8860,1893,2627,3367,8032,8857,3369,3372,3373,8858,13209,3375,3376,3379,3380,3382,3383,3384,3390,3391,3395,3397,3398,3399,3400,3401,5682,3345,8825,5698,5700,2644,2660,2662,2667,3337,3352,8326,3353,3355,3357,3360,3361,3362,3363,3365,2623,3764,5458,8330,8853,5663,5664,5665,5459,5669,6441,2670,2671,2673,2733,5777,3339,3343,5771,3768,3350,4731,4224) 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 B.PROPERTY_102 IN ('Ковролин бытовой') AND' at line 8]
|