Керамогранит 600х600
Регион:
|
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_55 as PROPERTY_THICKNESS , B.PROPERTY_54 as PROPERTY_SURFACE , B.PROPERTY_291 as PROPERTY_SIZE , B.PROPERTY_728 as PROPERTY_DEKOR 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:47:49' AND (C.REGION IN ()) AND C.PRICE>0 AND B.PROPERTY_291 IN ('60х60 см') AND A.IBLOCK_SECTION_ID IN (7875,13966,13967,8555,8938,8939,8941,8942,8943,8945,8950,8951,8952,8957,8958,9036,9038,9039,13971,9040,13972,13973,13974,13975,9157,9158,9159,9160,9502,9503,13900,13901,13902,13903,13904,13905,13906,13907,13908,13633,13634,13649,13681,13814,13921,13939,13943,13948,14078,14097,14109,14124,14133,14137,14140,14178,14180,14197,14201,14203,14234,14131,13663,13664,13672,13665,13673,13666,13674,13667,13675,13668,13676,13677,13678,13679,13680,13686,13687,13770,13772,13688,13771,13773,13774,13775,13776,13777,13936,13937,13938,14121,14122,14123,14136,14153,14154,14167,14168,14170,14171,14206,14172,14173,14174,14176,14177,7489,14047,9237,14048,9238,14049,9239,13635,13636,7257,7258,7259,14050,7261,7262,7371,13992,2127,7817,9060,9859,13568,2129,9061,9362,9450,2130,9062,13570,13565,13571,13566,13572,2133,13567,2134,13574,9436,13576,2137,13577,2139,2140,7824,7825,2142,7826,2143,5778,2144,2141,2577,9455,9461,13578,13581,9456,13579,13582,8927,9207,9457,13580,13583,2578,9208,9458,13584,2579,9209,9459,13585,2580,9210,9460,13586,2581,9211,13587,2582,9212,13588,2583,9213,2584,2586,2587,5779,2588,5780,2589,2591,2592,2596,2598,2600,4388,7820,8333,8342,8926,13590,7821,8334,8343,13591,8344,8336,8337,9434,8339,4390,4391,4398,4585,13965,4609,3314,3315,3317,9448,14058,14067,14068,14069,14070,14071,14072,14073,14074,14075,14076,14077,5784,4627,4631,4635,4636,4638,4640,4642,4643,4644,4645,3318,4049,13817,4051,13669,13670,4379,13671,4380,9248,9249,4052,4053,14033,9225,4055,13991,7417,4057,13976,13977,13978,13979,13980,4059,13785,13786,13787,13788,13789,13790,13791,5781,4061,4062,4063,4064,4065,4066,4067,4072,9031,9032,9033,9034,9215,9035,9216,13637,9217,13638,13639,13640,13641,13642,13643,13644,13645,13646,13647,13648,4073,4439,4440,4441,4442,4443,4451,6052,4091,14155,14156,14157,4382,4384,4386,4529,9064,13818,13854,13864,13888,9065,13855,13865,13889,9066,13856,13866,13890,13857,13867,13891,13858,13868,13892,13859,13869,13893,13860,13870,13894,13861,13871,13895,13862,13872,13896,13863,13873,13897,13874,13898,13875,13899,13876,13877,13878,13879,5718,5721,5723,5725,5730,5735,5738,5744,5745,5747,5748,5749,5750,5752,5753,4571,4577,14035,14036,14037,4579,14034,4581,4583,4589,4593,4595,4597,4615,4619,4621,4625,4650,5110,5114,5123,13779,13780,5125,5460,7852,6050,6053,6104,6237,6308,6457,14051,14228,14052,9230,14053,9231,14054,9232,14055,9233,9234,9235,6637,6638,6817,6821,6833,6835,6839,6841,6885,7017,7018,7071,7096,7097,7098,9030,7102,7103,7109,7110,7111,13782,13783,13784,7114,7115,13781,7117,7118,7119,7120,7121,7122,7126,7127,13778,7128,7129,7135,7136,13650,13651,13652,13653,13654,13682,13683,13684,13685,13815,13816,13922,13923,13924,13925,13926,13927,13940,13941,13942,13944,13945,13946,13947,13949,14079,14080,14081,14082,14083,14084,14098,14099,14100,14101,14102,14103,14104,14110,14111,14112,14113,14114,14115,14116,14125,14126,14127,14128,14129,14130,14134,14135,14138,14139,14141,14142,14179,14181,14198,14199,14200,14202,14204,14235,14132) 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_291 IN ('60х60 см') AND A.IBLOCK_SECTION_ID' at line 8]
|