Бренд
Цвет
По помещениям
По применению
Стилистика
Материал плитки
Ширина плитки, см
Длина плитки, см
Особенности
Цена от
до
332,50 руб.
4 202 руб.

Дополнительные параметры поиска


MySQL Query Error: SELECT DISTINCT BE.ID as ID,BE.NAME as NAME,BE.IBLOCK_ID as IBLOCK_ID,B.DETAIL_PAGE_URL as DETAIL_PAGE_URL,BE.PREVIEW_PICTURE as PREVIEW_PICTURE,BE.DETAIL_PICTURE as DETAIL_PICTURE,BE.PREVIEW_TEXT as PREVIEW_TEXT, FPEN0.VALUE as PROPERTY_BRAND_F_VALUE, FPEN0.ID as PROPERTY_BRAND_F_ENUM_ID, FPV0.ID as PROPERTY_BRAND_F_VALUE_ID, FPEN1.VALUE as PROPERTY_NEW_VALUE, FPEN1.ID as PROPERTY_NEW_ENUM_ID, FPV1.ID as PROPERTY_NEW_VALUE_ID, FPV2.VALUE as PROPERTY_MAX_DISCOUNT_Z_IMG_VALUE, FPV2.ID as PROPERTY_MAX_DISCOUNT_Z_IMG_VALUE_ID,L.DIR as LANG_DIR,BE.SORT as SORT,BE.CODE as CODE,BE.XML_ID as EXTERNAL_ID,BE.IBLOCK_SECTION_ID as IBLOCK_SECTION_ID,B.IBLOCK_TYPE_ID as IBLOCK_TYPE_ID,B.CODE as IBLOCK_CODE,B.XML_ID as IBLOCK_EXTERNAL_ID,B.LID as LID,BE.PREVIEW_TEXT_TYPE as PREVIEW_TEXT_TYPE , CAT_P23.ID as CATALOG_PRICE_ID_23, CAT_P23.CATALOG_GROUP_ID as CATALOG_GROUP_ID_23, CAT_P23.PRICE as CATALOG_PRICE_23, CAT_P23.CURRENCY as CATALOG_CURRENCY_23, CAT_P23.QUANTITY_FROM as CATALOG_QUANTITY_FROM_23, CAT_P23.QUANTITY_TO as CATALOG_QUANTITY_TO_23, 'Уровень скидки -1' as CATALOG_GROUP_NAME_23, 'Y' as CATALOG_CAN_ACCESS_23, 'Y' as CATALOG_CAN_BUY_23, CAT_P23.EXTRA_ID as CATALOG_EXTRA_ID_23, CAT_PR.QUANTITY as CATALOG_QUANTITY, CAT_PR.QUANTITY_RESERVED as CATALOG_QUANTITY_RESERVED, IF (CAT_PR.QUANTITY_TRACE = 'D', 'Y', CAT_PR.QUANTITY_TRACE) as CATALOG_QUANTITY_TRACE, CAT_PR.QUANTITY_TRACE as CATALOG_QUANTITY_TRACE_ORIG, IF (CAT_PR.CAN_BUY_ZERO = 'D', 'Y', CAT_PR.CAN_BUY_ZERO) as CATALOG_CAN_BUY_ZERO, CAT_PR.CAN_BUY_ZERO as CATALOG_CAN_BUY_ZERO_ORIG, IF (CAT_PR.NEGATIVE_AMOUNT_TRACE = 'D', 'Y', CAT_PR.NEGATIVE_AMOUNT_TRACE) as CATALOG_NEGATIVE_AMOUNT_TRACE, CAT_PR.NEGATIVE_AMOUNT_TRACE as CATALOG_NEGATIVE_AMOUNT_ORIG, IF (CAT_PR.SUBSCRIBE = 'D', 'Y', CAT_PR.SUBSCRIBE) as CATALOG_SUBSCRIBE, CAT_PR.SUBSCRIBE as CATALOG_SUBSCRIBE_ORIG, IF ( CAT_PR.QUANTITY > 0 OR IF (CAT_PR.QUANTITY_TRACE = 'D', 'Y', CAT_PR.QUANTITY_TRACE) = 'N' OR IF (CAT_PR.CAN_BUY_ZERO = 'D', 'Y', CAT_PR.CAN_BUY_ZERO) = 'Y', 'Y', 'N' ) as CATALOG_AVAILABLE, CAT_PR.WEIGHT as CATALOG_WEIGHT, CAT_PR.WIDTH as CATALOG_WIDTH, CAT_PR.LENGTH as CATALOG_LENGTH, CAT_PR.HEIGHT as CATALOG_HEIGHT, CAT_PR.MEASURE as CATALOG_MEASURE, CAT_VAT.RATE as CATALOG_VAT, CAT_PR.VAT_INCLUDED as CATALOG_VAT_INCLUDED, CAT_PR.PRICE_TYPE as CATALOG_PRICE_TYPE, CAT_PR.RECUR_SCHEME_TYPE as CATALOG_RECUR_SCHEME_TYPE, CAT_PR.RECUR_SCHEME_LENGTH as CATALOG_RECUR_SCHEME_LENGTH, CAT_PR.TRIAL_PRICE_ID as CATALOG_TRIAL_PRICE_ID, CAT_PR.WITHOUT_ORDER as CATALOG_WITHOUT_ORDER, CAT_PR.SELECT_BEST_PRICE as CATALOG_SELECT_BEST_PRICE, CAT_PR.PURCHASING_PRICE as CATALOG_PURCHASING_PRICE, CAT_PR.PURCHASING_CURRENCY as CATALOG_PURCHASING_CURRENCY, CAT_PR.TYPE as CATALOG_TYPE FROM b_iblock B INNER JOIN b_lang L ON B.LID=L.LID INNER JOIN b_iblock_element BE ON BE.IBLOCK_ID = B.ID LEFT JOIN b_iblock_property FP0 ON FP0.IBLOCK_ID = B.ID AND FP0.CODE='BRAND_F' LEFT JOIN b_iblock_property FP1 ON FP1.IBLOCK_ID = B.ID AND FP1.CODE='NEW' LEFT JOIN b_iblock_property FP2 ON FP2.IBLOCK_ID = B.ID AND FP2.CODE='MAX_DISCOUNT_Z_IMG' INNER JOIN b_iblock_property FP3 ON FP3.IBLOCK_ID = B.ID AND FP3.ID=460 LEFT JOIN b_iblock_element_property FPV0 ON FPV0.IBLOCK_PROPERTY_ID = FP0.ID AND FPV0.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV1 ON FPV1.IBLOCK_PROPERTY_ID = FP1.ID AND FPV1.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_element_property FPV2 ON FPV2.IBLOCK_PROPERTY_ID = FP2.ID AND FPV2.IBLOCK_ELEMENT_ID = BE.ID INNER JOIN b_iblock_element_property FPV3 ON FPV3.IBLOCK_PROPERTY_ID = FP3.ID AND FPV3.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_property_enum FPEN0 ON FPEN0.PROPERTY_ID = FPV0.IBLOCK_PROPERTY_ID AND FPV0.VALUE_ENUM = FPEN0.ID LEFT JOIN b_iblock_property_enum FPEN1 ON FPEN1.PROPERTY_ID = FPV1.IBLOCK_PROPERTY_ID AND FPV1.VALUE_ENUM = FPEN1.ID LEFT JOIN b_catalog_price CAT_P23 ON (CAT_P23.PRODUCT_ID = BE.ID AND CAT_P23.CATALOG_GROUP_ID = 23) left join b_catalog_product CAT_PR on (CAT_PR.ID = BE.ID) left join b_catalog_iblock CAT_IB on ((CAT_PR.VAT_ID IS NULL OR CAT_PR.VAT_ID = 0) AND CAT_IB.IBLOCK_ID = BE.IBLOCK_ID) left join b_catalog_vat CAT_VAT on (CAT_VAT.ID = IF((CAT_PR.VAT_ID IS NULL OR CAT_PR.VAT_ID = 0), CAT_IB.VAT_ID, CAT_PR.VAT_ID)) WHERE 1=1 AND ( ((((BE.IBLOCK_ID = '24')))) AND ((((BE.ACTIVE='Y')))) AND (((BE.ID IN ('160166', '163621', '215745', '216442', '220264', '220930', '220945', '221917', '222671', '225454', '226360', '227806', '230261', '230262', '230263', '230265', '230360', '230364', '230365', '230366', '231065', '231802', '231896', '232673', '232699', '232700', '232702', '232703', '234146', '234548', '240967', '241340', '241343', '241635', '241636', '244978', '244992', '244994', '244995', '244999', '245008', '245212', '245223', '245224', '245225', '245287', '245288', '245324', '245387', '245393', '246865', '248496', '248757', '248758', '249574', '250213', '250296', '250297', '250299', '250362', '250367', '250368', '250370', '250371', '250547', '250814', '250815', '250816', '251035', '251050', '251396', '251397', '251398', '252940', '252941', '252942', '252943', '253228', '253245', '253258', '253259', '253309', '253311', '253972', '253994', '254679', '254680', '254681', '254682', '255044', '255331', '255366', '256139', '256197', '256198', '257087', '257088', '257089', '257313', '257445', '257563', '257708', '257709', '257737', '257738', '257739', '257803', '257838', '257839', '257840', '257841', '257939', '257940', '257941', '258011', '258012', '258013', '258240', '258251', '258265', '258325', '259032', '259716', '259952', '260019', '260024', '260123', '260269', '260270', '260271', '260582', '260583', '260585', '260586', '261544', '261545', '261546', '261616', '261617', '261618', '261619', '261620', '261621', '261622', '261971', '261991', '263173', '263250', '263426', '263427', '263448', '263450', '263451', '263453', '263631', '264002', '264003', '264303', '264304', '264305', '264306', '264309', '264615', '264616', '264901', '264904', '264905', '264906', '264907', '264908', '264909', '264911', '265048', '265476', '265477', '265478', '265479', '265480', '265481', '265482', '265643', '265871', '266440', '266441', '266675', '266676', '266858', '266859', '266861', '266862', '266863', '266864', '266865', '266867', '266868', '266869', '266870', '266873', '266874', '266875', '266876', '266878', '266879', '266885', '266886', '266887', '267013', '267014', '267015', '267131', '267138', '267151', '267152', '267284', '267285', '267286', '267287', '267422', '267450', '267466', '267511', '267512', '267513', '267514', '267515', '267516', '267517', '267518', '267519', '267520', '267521', '267522', '267523', '267702', '267703', '267704', '268107', '268108', '268109', '268110', '268111', '268112', '268113', '268115', '268290', '268291', '268292', '268293', '268294', '268295', '268296', '268297', '268298', '268318', '268319', '268320', '268461', '268501', '268512', '268513', '268514', '269601', '269602', '269603', '269705', '269828', '269858', '269934', '269935', '269936', '269938', '269939', '269940', '270008', '270009', '270010', '270140', '270141', '270211', '270212', '270213', '270214', '270215', '270260', '270378', '270379', '270802', '270999', '271176', '271178', '271257', '271282', '271283', '271284', '271285', '271286', '271287', '271288', '271289', '271290', '271291', '271292', '271293', '271304', '271322', '271323', '271324', '271325', '271326', '271327', '271328', '271450', '271833', '271834', '271835', '271911', '271987', '272233', '272245', '272256', '272257', '272259', '272474', '272475', '272476', '272477', '272478', '272479', '272480', '272595', '272626', '272627', '272628', '272629', '272639', '272688', '272821', '272822', '272823', '272824', '272825', '272826', '272827', '272828', '272829', '272830', '272832', '272833', '272834', '272835', '272836', '272837', '272838', '272839', '272840', '272841', '272877', '272878', '272929', '272945', '272946', '273013', '273014', '273182', '273265', '273622', '273626', '273742', '273743', '273744', '273746', '273747', '273749', '273817', '273818', '273936', '273937', '273938', '274148', '274149', '274150', '274151', '274152', '274153', '274297', '274300', '274412', '274446', '274447', '274563', '274579', '274580', '274581', '274582', '274583', '274584', '274585', '274586', '274663', '274754', '274765', '274792', '274793', '274794', '274795', '274836', '274837', '274838', '274839', '274840', '274841', '274842', '274843', '274844', '274845', '275015')))) AND ((((FPV3.VALUE_ENUM = '13824')))) ) AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL))) ORDER BY BE.SORT asc , CAT_P23.PRICE asc LIMIT 24, 24[[2006] MySQL server has gone away]

DB query error.
Please try later.