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_51 as PROPERTY_CLASS , B.PROPERTY_50 as PROPERTY_DECOR , B.PROPERTY_55 as PROPERTY_THICKNESS , B.PROPERTY_57 as PROPERTY_FORM , B.PROPERTY_54 as PROPERTY_SURFACE , B.PROPERTY_56 as PROPERTY_CHAMFER , B.PROPERTY_299 as PROPERTY_WATER_RESIST
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 05:59:41' AND (C.REGION IN ()) AND C.PRICE>0 AND A.IBLOCK_SECTION_ID IN (9608,9717,9720,9721,9719,9722,9723,9864,9015,8959,9000,8994,8995,9661,9614,9615,9617,13439,13433,13364,13423,13416,13428,13424,13434,13435,13367,13437,13362,13370,8851,9134,9193,9194,13250,9180,9135,13251,13252,9195,9282,13279,13361,9006,9007,13289,9008,8792,8793,8906,13347,8909,8967,13358,13359,13360,9377,9011,9013,9014,9012,1425,12110,9125,9124,9651,13349,7063,7819,13350,3203,9551,6713,1428,1430,1431,1434,1435,2372,9123,9177,13346,9542,9543,4193,4194,4195,2373,2375,2376,2377,2378,2379,2380,2381,9890,2318,9440,9441,9442,9443,9444,9445,9446,9447,1415,13223,8645,13224,13225,9122,9510,13226,3202,13227,9512,13228,7842,3793,5483,1418,1419,1420,1421,1422,1423,9566,9567,9568,9569,9571,5494,9572,9573,5497,5502,1401,9515,9201,9509,9399,6715,9400,1402,6716,9401,1403,1406,1407,1408,1409,1410,1411,1413,5479,4845,1747,13254,6628,1748,1753,8646,1755,9678,9679,2393,5481,2394,2395,2396,2400,2363,9024,2365,2366,2367,1788,8225,9750,9751,9752,1789,1790,1791,1795,1796,1797,1800,2368,13294,13295,13296,5606,5607,5609,5611,7187,2370,3929,2371,5127,9003,3729,7177,3730,5181,5182,5183,5184,3627,8990,8991,8992,13354,13355,13356,13357,5209,1396,1397,8536,8537,8429,1867,1868,1874,6707,13291,8976,13292,6708,6711,3898,8238,9601,9183,9599,13293,3899,5450,7182,7183,2352,13290,8508,9753,2358,2343,9574,9680,9575,9576,9577,9580,9581,9582,9583,9584,3727,9022,13230,6256,5160,7475,13231,7476,13232,5161,13233,13234,13235,13236,13237,2384,7130,8987,5503,2385,2386,2387,2388,1756,9553,9554,9555,9556,9557,9558,9559,9560,9561,9562,1398,13194,1399,1400,5378,2473,2336,7367,2432,9205,2437,2438,2439,2442,5582,3625,7178,5199,5200,1801,9766,9767,9768,9764,1802,1803,1804,1805,1806,1808,6235,9586,9588,9589,9590,2447,13255,13256,13257,13258,3623,3624,6531,3731,13240,13241,9741,13242,3732,5187,2307,9770,9774,9771,3616,8867,1854,1855,1856,1857,1858,1859,1439,1440,1441,3601,8937,3608,5319,9126,6714,13220,5513,5515,5518,5323,5521,9686,2310,2311,3619,3735,9739,4997,4998,4999,5003,5004,5005,5007,5009,3736,5010,2457,13297,13298,13299,13300,13301,2460,2463,2464,2465,3201,13353,6581,4829,9363,9364,3889,13238,6100,2359,9591,9130,9131,9132,2361,4837,4838,7070,3621,6583,5446,3733,4000,4001,4833,4160,5168,4161,2428,8018,9685,13221,8019,8020,7672,7601,8564,9745,7511,1424,7516,13351,13352,7518,7411,7412,7427,13365,13366,13417,13418,13419,13429,13430,13431,13432,13425,13426,13427,13436,13368,13369,13438,13371,13372,13373) 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 (9608,9717,9720,9721,9719,9722,9723' at line 8]
DB query error.
Please try later.
|
|
