Москва
8 (495) 180-04-87
Санкт-Петербург
8 (812) 409-98-35
Бесплатно по РФ
8 (800) 550-97-33
Часы работы: Пн-Пт: 9:00 - 20:00, Онлайн-заказ: круглосуточно
Заказать звонок Звонок заказан
Перезвонить вам?
Корзина
0 руб
Фильтр по параметрам Скрыть фильтр
Loading...
Наши услуги
Статьи
Свет для офиса
14.03.2018
Свет для офиса
В офисе основную роль играет освещение. Ведь именно благодаря грамотному освещению работники чувствуют с...
Модные люстры в 2018 году
09.03.2018
Модные люстры в 2018 году
При планировании ремонта или обновлении дизайна квартиры, дома или любого помещения не лишним будет посм...
Все статьи

Люстры, светильники, бра, настольные лампы, торшеры по самым выгодным ценам!


MySQL Query Error: SELECT DISTINCT BE.ID as ID,BE.NAME as NAME,BE.CODE as CODE,BE.IBLOCK_SECTION_ID as IBLOCK_SECTION_ID,B.DETAIL_PAGE_URL as DETAIL_PAGE_URL,BE.DETAIL_PICTURE as DETAIL_PICTURE,BE.PREVIEW_TEXT as PREVIEW_TEXT,BE.PREVIEW_TEXT_TYPE as PREVIEW_TEXT_TYPE,L.DIR as LANG_DIR,BE.ACTIVE as ACTIVE,BE.SORT as SORT,BE.XML_ID as EXTERNAL_ID,B.IBLOCK_TYPE_ID as IBLOCK_TYPE_ID,BE.IBLOCK_ID as IBLOCK_ID,B.CODE as IBLOCK_CODE,B.XML_ID as IBLOCK_EXTERNAL_ID,B.LID as LID , CAT_P4.ID as CATALOG_PRICE_ID_4, CAT_P4.CATALOG_GROUP_ID as CATALOG_GROUP_ID_4, CAT_P4.PRICE as CATALOG_PRICE_4, CAT_P4.CURRENCY as CATALOG_CURRENCY_4, CAT_P4.QUANTITY_FROM as CATALOG_QUANTITY_FROM_4, CAT_P4.QUANTITY_TO as CATALOG_QUANTITY_TO_4, 'Розничная' as CATALOG_GROUP_NAME_4, 'Y' as CATALOG_CAN_ACCESS_4, 'Y' as CATALOG_CAN_BUY_4, CAT_P4.EXTRA_ID as CATALOG_EXTRA_ID_4, CAT_PR.QUANTITY as CATALOG_QUANTITY, CAT_PR.QUANTITY_RESERVED as CATALOG_QUANTITY_RESERVED, IF (CAT_PR.QUANTITY_TRACE = 'D', 'N', CAT_PR.QUANTITY_TRACE) as CATALOG_QUANTITY_TRACE, CAT_PR.QUANTITY_TRACE as CATALOG_QUANTITY_TRACE_ORIG, IF (CAT_PR.CAN_BUY_ZERO = 'D', 'N', 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', 'N', 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, CAT_PR.AVAILABLE 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_ID as CATALOG_VAT_ID, 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, CAT_PR.BUNDLE as CATALOG_BUNDLE 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='HIDE' LEFT JOIN b_iblock_element_property FPV0 ON FPV0.IBLOCK_PROPERTY_ID = FP0.ID AND FPV0.IBLOCK_ELEMENT_ID = BE.ID INNER JOIN ( SELECT DISTINCT BSE.IBLOCK_ELEMENT_ID FROM b_iblock_section_element BSE INNER JOIN b_iblock_section BSubS ON BSE.IBLOCK_SECTION_ID = BSubS.ID INNER JOIN b_iblock_section BS ON (BSubS.IBLOCK_ID=BS.IBLOCK_ID AND BSubS.LEFT_MARGIN>=BS.LEFT_MARGIN AND BSubS.RIGHT_MARGIN<=BS.RIGHT_MARGIN) WHERE ((BS.ID IN (250))) ) BES ON BES.IBLOCK_ELEMENT_ID = BE.ID left join b_catalog_price CAT_P4 on (CAT_P4.PRODUCT_ID = BE.ID AND CAT_P4.CATALOG_GROUP_ID = 4) and ((CAT_P4.QUANTITY_FROM <= 1 OR CAT_P4.QUANTITY_FROM IS NULL) AND (CAT_P4.QUANTITY_TO >= 1 OR CAT_P4.QUANTITY_TO IS NULL)) 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 ( (((( (upper(BE.TAGS) like upper('%для%') and BE.TAGS is not null) AND (upper(BE.TAGS) like upper('%прихожей%') and BE.TAGS is not null) )))) AND ((((CAT_P4.PRICE >= '0')))) AND ((((BE.IBLOCK_ID = '12')))) AND ((((BE.ACTIVE='Y')))) AND ( 1=1 ) AND ((( FPV0.VALUE_NUM IS NULL OR NOT (FPV0.VALUE_NUM = '1')))) ) AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL))) ORDER BY BE.ACTIVE desc ,if(BE.PREVIEW_PICTURE is null, 0, 1) desc ,BE.SORT asc LIMIT 0, 40[[126] Incorrect key file for table '/tmp/#sql_3570_1.MYI'; try to repair it]

DB query error.
Please try later.