Коммерческий линолеум
Регион:
|
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_55 as PROPERTY_THICKNESS , B.PROPERTY_99 as PROPERTY_BASE , B.PROPERTY_293 as PROPERTY_MATERIAL1 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 01:43:48' AND (C.REGION IN ()) AND C.PRICE>0 AND B.PROPERTY_102 IN ('Линолеум коммерческий, гетерогенный (защ.слой от 0,7мм)','Линолеум коммерческий, гомогенный') AND A.IBLOCK_SECTION_ID IN (9076,9077,9079,9078,9080,13222,13211,13212,13213,13214,13215,13216,13217,13219,2572,8856,7916,14554,2573,9789,7089,6772,8514,9790,9416,6773,7377,7917,6289,6993,6995,9419,6997,7000,2831,13195,13196,2832,13197,2833,13198,13199,2835,13200,2836,2837,2841,2843,2846,2847,2850,2851,2852,2854,2855,2858,2859,2860,2867,9023,9179,7441,2869,2871,2872,2873,2874,2875,3179,7928,3186,3189,5593,3191,3199,5594,5603,2803,13202,9815,9816,8919,9541,13203,9508,2809,2816,2817,2818,9506,5586,5587,9357,5588,2876,8624,9627,2877,2882,2886,2897,2904,3322,3323,4002,9625,13218,5058,5059,1830,13207,2826,9477,9475,9855,2827,2828,2829,2830,3320,5100,2862,9829,9827,2863,2865,2866,3324,3326,13208,5079) 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 ('Линолеум коммерческ' at line 8]
|