Склад:
115201, г. Москва, 2-ой Котляковский пер., д. 1, стр. 10
Офис:
115201, г. Москва, 2-ой Котляковский пер., д. 1, стр. 6
Информация
О нас
Оплата и доставка
Блог
В розницу
В корп. отдел
Контакты
Войти на сайт
/
Регистрация
Войти на сайт:
Электронная почта:
Пароль:
Вход
Напомнить пароль
Регистрация
Войти через соц.сети
ВКонтакте
Facebook
Используйте вашу учетную запись VKontakte для входа на сайт.
Используйте вашу учетную запись на Facebook.com для входа на сайт.
Бесплатный звонок по РФ
+7 (499) 348-11-41
info@megamind.ru
В корзине пусто :(
Каталог продукции
Все подарки
Хиты продаж
В розницу
В Корп. отдел
Контакты
Оплата и доставка
О нас
Блог
Специальные подборки
Быстрый подбор
Каталог продукции на складе
Онлайн прайс-лист
Скоро в наличии
Полный каталог товаров
Подарки на праздники
Подарки для мужчин
Подарки для женщин
Подарки для детей
Товары на заказ
Хиты
FILE: /var/www/www-root/data/www/megamind.ru/bitrix/modules/iblock/classes/mysql/iblockelement.php
LINE: 802
MySQL Query Error: SELECT DISTINCT BE.ID as ID,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,UNIX_TIMESTAMP(BE.TIMESTAMP_X) as TIMESTAMP_X_UNIX,BE.MODIFIED_BY as MODIFIED_BY,DATE_FORMAT(BE.DATE_CREATE, '%d.%m.%Y %H:%i:%s') as DATE_CREATE,UNIX_TIMESTAMP(BE.DATE_CREATE) as DATE_CREATE_UNIX,BE.CREATED_BY as CREATED_BY,BE.IBLOCK_ID as IBLOCK_ID,BE.IBLOCK_SECTION_ID as IBLOCK_SECTION_ID,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 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 ACTIVE_TO,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.NAME as NAME,BE.PREVIEW_PICTURE as PREVIEW_PICTURE,BE.PREVIEW_TEXT as PREVIEW_TEXT,BE.PREVIEW_TEXT_TYPE as PREVIEW_TEXT_TYPE,BE.DETAIL_PICTURE as DETAIL_PICTURE,BE.DETAIL_TEXT as DETAIL_TEXT,BE.DETAIL_TEXT_TYPE as DETAIL_TEXT_TYPE,BE.SEARCHABLE_CONTENT as SEARCHABLE_CONTENT,BE.WF_STATUS_ID as WF_STATUS_ID,BE.WF_PARENT_ELEMENT_ID as WF_PARENT_ELEMENT_ID,BE.WF_LAST_HISTORY_ID as WF_LAST_HISTORY_ID,BE.WF_NEW as WF_NEW,if (BE.WF_DATE_LOCK is null, 'green', if(DATE_ADD(BE.WF_DATE_LOCK, interval 60 MINUTE)<now(), 'green', if(BE.WF_LOCKED_BY=0, 'yellow', 'red'))) as LOCK_STATUS,BE.WF_LOCKED_BY as WF_LOCKED_BY,DATE_FORMAT(BE.WF_DATE_LOCK, '%d.%m.%Y %H:%i:%s') as WF_DATE_LOCK,BE.WF_COMMENTS as WF_COMMENTS,BE.IN_SECTIONS as IN_SECTIONS,BE.SHOW_COUNTER as SHOW_COUNTER,DATE_FORMAT(BE.SHOW_COUNTER_START, '%d.%m.%Y %H:%i:%s') as SHOW_COUNTER_START,BE.SHOW_COUNTER_START as SHOW_COUNTER_START_X,BE.CODE as CODE,BE.TAGS as TAGS,BE.XML_ID as XML_ID,BE.XML_ID as EXTERNAL_ID,BE.TMP_ID as TMP_ID,concat('(',U.LOGIN,') ',ifnull(U.NAME,''),' ',ifnull(U.LAST_NAME,'')) as USER_NAME,concat('(',UL.LOGIN,') ',ifnull(UL.NAME,''),' ',ifnull(UL.LAST_NAME,'')) as LOCKED_USER_NAME,concat('(',UC.LOGIN,') ',ifnull(UC.NAME,''),' ',ifnull(UC.LAST_NAME,'')) as CREATED_USER_NAME,L.DIR as LANG_DIR,B.LID as LID,B.IBLOCK_TYPE_ID as IBLOCK_TYPE_ID,B.CODE as IBLOCK_CODE,B.NAME as IBLOCK_NAME,B.XML_ID as IBLOCK_EXTERNAL_ID,B.DETAIL_PAGE_URL as DETAIL_PAGE_URL,B.LIST_PAGE_URL as LIST_PAGE_URL,B.CANONICAL_PAGE_URL as CANONICAL_PAGE_URL,DATE_FORMAT(BE.DATE_CREATE, '%Y.%m.%d') as CREATED_DATE,if(BE.WF_STATUS_ID = 1, 'Y', 'N') as BP_PUBLISHED , CAT_PR.QUANTITY as CATALOG_QUANTITY, IF (CAT_PR.QUANTITY_TRACE = 'D', 'Y', CAT_PR.QUANTITY_TRACE) as CATALOG_QUANTITY_TRACE, CAT_PR.QUANTITY_TRACE as CATALOG_QUANTITY_TRACE_ORIG, CAT_PR.WEIGHT as CATALOG_WEIGHT, CAT_PR.VAT_ID as CATALOG_VAT_ID, CAT_PR.VAT_INCLUDED as CATALOG_VAT_INCLUDED, 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, CAT_PR.PURCHASING_PRICE as CATALOG_PURCHASING_PRICE, CAT_PR.PURCHASING_CURRENCY as CATALOG_PURCHASING_CURRENCY, CAT_PR.QUANTITY_RESERVED as CATALOG_QUANTITY_RESERVED, IF (CAT_PR.SUBSCRIBE = 'D', 'Y', CAT_PR.SUBSCRIBE) as CATALOG_SUBSCRIBE, CAT_PR.SUBSCRIBE as CATALOG_SUBSCRIBE_ORIG, 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_PR.TYPE as CATALOG_TYPE, CAT_PR.AVAILABLE as CATALOG_AVAILABLE, CAT_PR.BUNDLE as CATALOG_BUNDLE, CAT_PR.PRICE_TYPE as CATALOG_PRICE_TYPE, CAT_PR.RECUR_SCHEME_LENGTH as CATALOG_RECUR_SCHEME_LENGTH, CAT_PR.RECUR_SCHEME_TYPE as CATALOG_RECUR_SCHEME_TYPE, 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, 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_TRACE_ORIG, CAT_VAT.RATE as CATALOG_VAT, CAT_P2.ID as CATALOG_PRICE_ID_2, CAT_P2.CATALOG_GROUP_ID as CATALOG_GROUP_ID_2, CAT_P2.PRICE as CATALOG_PRICE_2, CAT_P2.CURRENCY as CATALOG_CURRENCY_2, CAT_P2.QUANTITY_FROM as CATALOG_QUANTITY_FROM_2, CAT_P2.QUANTITY_TO as CATALOG_QUANTITY_TO_2, CAT_P2.EXTRA_ID as CATALOG_EXTRA_ID_2, 'Оптовая от 25' as CATALOG_GROUP_NAME_2, 'N' as CATALOG_CAN_ACCESS_2, 'N' as CATALOG_CAN_BUY_2, CAT_P3.ID as CATALOG_PRICE_ID_3, CAT_P3.CATALOG_GROUP_ID as CATALOG_GROUP_ID_3, CAT_P3.PRICE as CATALOG_PRICE_3, CAT_P3.CURRENCY as CATALOG_CURRENCY_3, CAT_P3.QUANTITY_FROM as CATALOG_QUANTITY_FROM_3, CAT_P3.QUANTITY_TO as CATALOG_QUANTITY_TO_3, CAT_P3.EXTRA_ID as CATALOG_EXTRA_ID_3, 'Оптовая от 50' as CATALOG_GROUP_NAME_3, 'N' as CATALOG_CAN_ACCESS_3, 'N' as CATALOG_CAN_BUY_3, CAT_P10.ID as CATALOG_PRICE_ID_10, CAT_P10.CATALOG_GROUP_ID as CATALOG_GROUP_ID_10, CAT_P10.PRICE as CATALOG_PRICE_10, CAT_P10.CURRENCY as CATALOG_CURRENCY_10, CAT_P10.QUANTITY_FROM as CATALOG_QUANTITY_FROM_10, CAT_P10.QUANTITY_TO as CATALOG_QUANTITY_TO_10, CAT_P10.EXTRA_ID as CATALOG_EXTRA_ID_10, 'Оптовая от 10' as CATALOG_GROUP_NAME_10, 'N' as CATALOG_CAN_ACCESS_10, 'N' as CATALOG_CAN_BUY_10 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 ( 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 (110))) ) BES ON BES.IBLOCK_ELEMENT_ID = BE.ID left join b_catalog_product as CAT_PR on (CAT_PR.ID = BE.ID) left join b_catalog_iblock as 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 as 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)) left join b_catalog_price as CAT_P2 on (CAT_P2.PRODUCT_ID = BE.ID and CAT_P2.CATALOG_GROUP_ID = 2) left join b_catalog_price as CAT_P3 on (CAT_P3.PRODUCT_ID = BE.ID and CAT_P3.CATALOG_GROUP_ID = 3) left join b_catalog_price as CAT_P10 on (CAT_P10.PRODUCT_ID = BE.ID and CAT_P10.CATALOG_GROUP_ID = 10) LEFT JOIN b_user U ON U.ID=BE.MODIFIED_BY LEFT JOIN b_user UL ON UL.ID=BE.WF_LOCKED_BY LEFT JOIN b_user UC ON UC.ID=BE.CREATED_BY WHERE 1=1 AND ( ((((BE.ACTIVE='Y')))) AND ( ( ((((BE.IBLOCK_ID = '6')))) AND ((((CAT_P2.PRICE > '0')))) AND ((((CAT_P3.PRICE > '0')))) AND ((((CAT_P10.PRICE > '0')))) ) OR ( (BE.ID IN ( SELECT FPV0.VALUE_NUM 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='CML2_LINK' LEFT JOIN b_iblock_element_property FPV0 ON FPV0.IBLOCK_PROPERTY_ID = FP0.ID AND FPV0.IBLOCK_ELEMENT_ID = BE.ID left join b_catalog_price as CAT_P2 on (CAT_P2.PRODUCT_ID = BE.ID and CAT_P2.CATALOG_GROUP_ID = 2) left join b_catalog_product as CAT_PR on (CAT_PR.ID = BE.ID) left join b_catalog_iblock as 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 as 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)) left join b_catalog_price as CAT_P3 on (CAT_P3.PRODUCT_ID = BE.ID and CAT_P3.CATALOG_GROUP_ID = 3) left join b_catalog_price as CAT_P10 on (CAT_P10.PRODUCT_ID = BE.ID and CAT_P10.CATALOG_GROUP_ID = 10) WHERE 1=1 AND ( ((((BE.IBLOCK_ID = '33')))) AND ((((CAT_P2.PRICE > '0')))) AND ((((CAT_P3.PRICE > '0')))) AND ((((CAT_P10.PRICE > '0')))) ) AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL))) AND (((FPV0.VALUE_NUM IS NOT NULL))) )) ) ) AND ((((CAT_PR.QUANTITY > '0')))) ) AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL)))
[[126] Incorrect key file for table '/tmp/#sql_2e9_2.MYI'; try to repair it]
DB query error.
Please try later.
