Говорите
00:05

Подбор параметров
Цена
От
До
2090
20565
39040
57515
75990
Цвет
Бренд
Ширина, см
От
До
18.0
24.0
30.0
36.0
42.0
Высота, см
От
До
18.0
96.0
174.0
252.0
330.0
Глубина, см
От
До
14.0
62.5
111.0
159.5
208.0
Гарантия производителя, мес
От
До
12
24
36
48
60
Тип управления
Страна производитель
Коллекция
Сортировать по:
Показывать по:

MySQL Query Error: SELECT DISTINCT BE.ID as ID,BE.IBLOCK_ID as IBLOCK_ID,BE.CODE as CODE,BE.XML_ID as XML_ID,BE.NAME as NAME,BE.ACTIVE as ACTIVE,IF(EXTRACT(HOUR_SECOND FROM BE.ACTIVE_FROM)>0, DATE_FORMAT(BE.ACTIVE_FROM, '%d.%m.%Y %H:%i:%s'), DATE_FORMAT(BE.ACTIVE_FROM, '%d.%m.%Y')) as DATE_ACTIVE_FROM,IF(EXTRACT(HOUR_SECOND FROM BE.ACTIVE_TO)>0, DATE_FORMAT(BE.ACTIVE_TO, '%d.%m.%Y %H:%i:%s'), DATE_FORMAT(BE.ACTIVE_TO, '%d.%m.%Y')) as DATE_ACTIVE_TO,BE.SORT as SORT,BE.PREVIEW_TEXT as PREVIEW_TEXT,BE.PREVIEW_TEXT_TYPE as PREVIEW_TEXT_TYPE,BE.DETAIL_TEXT as DETAIL_TEXT,BE.DETAIL_TEXT_TYPE as DETAIL_TEXT_TYPE,DATE_FORMAT(BE.DATE_CREATE, '%d.%m.%Y %H:%i:%s') as DATE_CREATE,BE.CREATED_BY as CREATED_BY,BE.TAGS as TAGS,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,BE.MODIFIED_BY as MODIFIED_BY,BE.IBLOCK_SECTION_ID as IBLOCK_SECTION_ID,B.DETAIL_PAGE_URL as DETAIL_PAGE_URL,BE.DETAIL_PICTURE as DETAIL_PICTURE,BE.PREVIEW_PICTURE as PREVIEW_PICTURE,L.DIR as LANG_DIR,BE.XML_ID as EXTERNAL_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 , PRC_1.PRICE_SCALE as SCALED_PRICE_1, PRD.TYPE as TYPE, PRD.AVAILABLE as AVAILABLE, PRD.BUNDLE as BUNDLE, PRD.QUANTITY as QUANTITY, IF (PRD.QUANTITY_TRACE = 'D', 'Y', PRD.QUANTITY_TRACE) as QUANTITY_TRACE, IF (PRD.CAN_BUY_ZERO = 'D', 'Y', PRD.CAN_BUY_ZERO) as CAN_BUY_ZERO, PRD.MEASURE as MEASURE, IF (PRD.SUBSCRIBE = 'D', 'N', PRD.SUBSCRIBE) as SUBSCRIBE, PRD.VAT_ID as VAT_ID, PRD.VAT_INCLUDED as VAT_INCLUDED, PRD.WEIGHT as WEIGHT, PRD.WIDTH as WIDTH, PRD.LENGTH as LENGTH, PRD.HEIGHT as HEIGHT, PRD.PRICE_TYPE as PAYMENT_TYPE, PRD.RECUR_SCHEME_LENGTH as RECUR_SCHEME_LENGTH, PRD.RECUR_SCHEME_TYPE as RECUR_SCHEME_TYPE, PRD.TRIAL_PRICE_ID as TRIAL_PRICE_ID, PRD.QUANTITY_TRACE as QUANTITY_TRACE_RAW, PRD.CAN_BUY_ZERO as CAN_BUY_ZERO_RAW, PRD.SUBSCRIBE as SUBSCRIBE_RAW, PRD.PURCHASING_PRICE as PURCHASING_PRICE, PRD.PURCHASING_CURRENCY as PURCHASING_CURRENCY, PRD.BARCODE_MULTI as BARCODE_MULTI, PRD.WITHOUT_ORDER as WITHOUT_ORDER 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 INNER JOIN b_iblock_property FP0 ON FP0.IBLOCK_ID = B.ID AND FP0.CODE='CATALOG_PRICE_2' LEFT JOIN b_iblock_property FP1 ON FP1.IBLOCK_ID = B.ID AND FP1.CODE='OUT_OF_PRODUCTION' INNER JOIN b_iblock_property FP2 ON FP2.IBLOCK_ID = B.ID AND FP2.CODE='BRAND' INNER 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 INNER JOIN b_iblock_element_property FPV2 ON FPV2.IBLOCK_PROPERTY_ID = FP2.ID AND FPV2.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_iblock_property_enum FPEN0 ON FPEN0.PROPERTY_ID = FPV1.IBLOCK_PROPERTY_ID AND FPV1.VALUE_ENUM = FPEN0.ID INNER JOIN b_iblock_21_index FC on FC.ELEMENT_ID = BE.ID left join b_catalog_price as PRC_1 on (PRC_1.PRODUCT_ID = BE.ID and PRC_1.CATALOG_GROUP_ID = 1 and ((PRC_1.QUANTITY_FROM <= 1 or PRC_1.QUANTITY_FROM IS NULL) and (PRC_1.QUANTITY_TO >= 1 or PRC_1.QUANTITY_TO IS NULL))) left join b_catalog_product as PRD on (PRD.ID = BE.ID) WHERE 1=1 AND ( (FC.SECTION_ID = 419 AND FC.FACET_ID = 1 AND FC.VALUE_NUM = 0 AND FC.VALUE in (0)) AND (((BE.DETAIL_PICTURE IS NOT NULL))) AND (((BE.ID IS NULL OR NOT (BE.ID IN ('66786', '67075', '67074'))))) AND ((( BE.IBLOCK_SECTION_ID IS NULL OR NOT (BE.IBLOCK_SECTION_ID = '433')))) AND (EXISTS ( SELECT IBLOCK_ID FROM b_iblock_site WHERE IBLOCK_ID = B.ID AND (((SITE_ID='s1'))) )) AND (((BE.ACTIVE_TO >= now() OR BE.ACTIVE_TO IS NULL) AND (BE.ACTIVE_FROM <= now() OR BE.ACTIVE_FROM IS NULL))) AND ((((BE.ACTIVE='Y')))) AND ((((BE.IBLOCK_ID = '21')))) AND ((((FPV0.VALUE > '0')))) AND ((( FPEN0.VALUE IS NULL OR NOT (FPEN0.VALUE LIKE 'Y')))) AND ((((FPV2.VALUE LIKE 'bosch')) OR ((FPV2.VALUE LIKE 'neff')) OR ((FPV2.VALUE LIKE 'smeg')) OR ((FPV2.VALUE LIKE 'teka')) OR ((FPV2.VALUE LIKE 'zigmund_and_shtain')) OR ((FPV2.VALUE LIKE 'körting')) OR ((FPV2.VALUE LIKE 'Liebherr')) OR ((FPV2.VALUE LIKE 'Asko')) OR ((FPV2.VALUE LIKE 'blanko')) OR ((FPV2.VALUE LIKE 'gorenie')) OR ((FPV2.VALUE LIKE 'omoikiri')) OR ((FPV2.VALUE LIKE 'hitachi')) OR ((FPV2.VALUE LIKE 'fulgor')) OR ((FPV2.VALUE LIKE 'kuppersbusch')) OR ((FPV2.VALUE LIKE 'bonecrusher')) OR ((FPV2.VALUE LIKE 'graude')) OR ((FPV2.VALUE LIKE 'lava')) OR ((FPV2.VALUE LIKE 'schaub_lorenz')) OR ((FPV2.VALUE LIKE 'maunfeld')) OR ((FPV2.VALUE LIKE 'dunavox')) OR ((FPV2.VALUE LIKE 'elica')) OR ((FPV2.VALUE LIKE 'lex')) OR ((FPV2.VALUE LIKE 'faber')) OR ((FPV2.VALUE LIKE 'kronasteel')) OR ((FPV2.VALUE LIKE 'granfest')) OR ((FPV2.VALUE LIKE 'elikor')) OR ((FPV2.VALUE LIKE 'emap')) OR ((FPV2.VALUE LIKE 'simfer')) OR ((FPV2.VALUE LIKE 'coldvine')) OR ((FPV2.VALUE LIKE 'oulin')) OR ((FPV2.VALUE LIKE 'jackys')) OR ((FPV2.VALUE LIKE 'meyvel')) OR ((FPV2.VALUE LIKE 'hyundai')) OR ((FPV2.VALUE LIKE 'kaiser')) OR ((FPV2.VALUE LIKE 'evelux')) OR ((FPV2.VALUE LIKE 'bertazzoni')) OR ((FPV2.VALUE LIKE 'cata')) OR ((FPV2.VALUE LIKE 'deditrich')) OR ((FPV2.VALUE LIKE 'vzug')) OR ((FPV2.VALUE LIKE 'barier')) OR ((FPV2.VALUE LIKE 'falmec')) OR ((FPV2.VALUE LIKE 'millen')) OR ((FPV2.VALUE LIKE 'granula')) OR ((FPV2.VALUE LIKE 'alpicool')) OR ((FPV2.VALUE LIKE 'akvafor')) OR ((FPV2.VALUE LIKE 'haier')) OR ((FPV2.VALUE LIKE 'delvento')) OR ((FPV2.VALUE LIKE 'aeg')) OR ((FPV2.VALUE LIKE 'history')))) AND ((((PRC_1.PRICE > '10')))) ) AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL))) AND (( B.ID IN ( SELECT IBLOCK_ID FROM b_iblock_group IBG WHERE IBG.GROUP_ID IN (2) AND IBG.PERMISSION >= 'R' AND (IBG.PERMISSION='X' OR B.ACTIVE='Y') ) OR (B.RIGHTS_MODE = 'E' AND EXISTS ( SELECT ER.ELEMENT_ID FROM b_iblock_element_right ER INNER JOIN b_iblock_right IBR ON IBR.ID = ER.RIGHT_ID INNER JOIN b_user_access UA ON UA.ACCESS_CODE = IBR.GROUP_CODE AND UA.USER_ID = 0 WHERE ER.ELEMENT_ID = BE.ID AND IBR.OP_EREAD = 'Y' )) )) ORDER BY PRC_1.PRICE_SCALE asc ,BE.ID desc LIMIT 0, 16[[1021] Disk full (/tmp/#sql_5e6_27.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]

DB query error.
Please try later.