Корм для собак belcando для склонных к аллергии

%BITRIX_MAIL_EVENT_TEMPLATE_THEME_CALLBACK_STYLE%FILE: /var/www/bethowen.ru/bitrix/modules/iblock/classes/mysql/iblockelement.php
LINE: 784
MySQL Query Error:
SELECT DISTINCT BE.ID as ID, FPEN0.VALUE as PROPERTY_HIT_VALUE, FPEN0.ID as PROPERTY_HIT_ENUM_ID, FPV0.ID as PROPERTY_HIT_VALUE_ID, FPV1.VALUE as PROPERTY_SALE_TEXT_VALUE, FPV1.ID as PROPERTY_SALE_TEXT_VALUE_ID, FPEN1.VALUE as PROPERTY_WEIGHT_VALUE, FPEN1.ID as PROPERTY_WEIGHT_ENUM_ID, FPV2.ID as PROPERTY_WEIGHT_VALUE_ID, FPV3.VALUE as PROPERTY_CML2_ARTICLE_VALUE, FPV3.ID as PROPERTY_CML2_ARTICLE_VALUE_ID, FPEN2.VALUE as PROPERTY_DIMENSIONS_VALUE, FPEN2.ID as PROPERTY_DIMENSIONS_ENUM_ID, FPV4.ID as PROPERTY_DIMENSIONS_VALUE_ID, FPV5.VALUE as PROPERTY_WEIGHT_NUMBER_VALUE, FPV5.ID as PROPERTY_WEIGHT_NUMBER_VALUE_ID, FPV6.VALUE as PROPERTY_BARCODE_VALUE, FPV6.ID as PROPERTY_BARCODE_VALUE_ID, FPV7.VALUE as PROPERTY_PRICE_PER_1_PIECE_VALUE, FPV7.ID as PROPERTY_PRICE_PER_1_PIECE_VALUE_ID, FPV8.VALUE as PROPERTY_TYPE_PREFIX_VALUE, FPV8.ID as PROPERTY_TYPE_PREFIX_VALUE_ID, FPV9.VALUE as PROPERTY_VENDOR_VALUE, FPV9.ID as PROPERTY_VENDOR_VALUE_ID, FPV10.VALUE as PROPERTY_MODEL_VALUE, FPV10.ID as PROPERTY_MODEL_VALUE_ID, FPV11.VALUE as PROPERTY_STATUS_VALUE, FPV11.ID as PROPERTY_STATUS_VALUE_ID, FPV12.VALUE as PROPERTY_BRAND_VALUE, FPV12.ID as PROPERTY_BRAND_VALUE_ID, FPV13.VALUE as PROPERTY_CATEGORY_LVL_1_VALUE, FPV13.ID as PROPERTY_CATEGORY_LVL_1_VALUE_ID, FPV14.VALUE as PROPERTY_CATEGORY_LVL_2_VALUE, FPV14.ID as PROPERTY_CATEGORY_LVL_2_VALUE_ID, FPV15.VALUE as PROPERTY_CATEGORY_LVL_3_VALUE, FPV15.ID as PROPERTY_CATEGORY_LVL_3_VALUE_ID, FPV16.VALUE as PROPERTY_STORES_VALUE, FPV16.ID as PROPERTY_STORES_VALUE_ID, FPV17.VALUE as PROPERTY_STORES_ID_VALUE, FPV17.ID as PROPERTY_STORES_ID_VALUE_ID, FPV18.VALUE as PROPERTY_LINK_TO_SECOND_ITEM_VALUE, FPV18.ID as PROPERTY_LINK_TO_SECOND_ITEM_VALUE_ID, FPV19.VALUE as PROPERTY_WIDTH_VALUE, FPV19.ID as PROPERTY_WIDTH_VALUE_ID, FPV20.VALUE as PROPERTY_LENGTH_VALUE, FPV20.ID as PROPERTY_LENGTH_VALUE_ID, FPV21.VALUE as PROPERTY_HEIGHT_VALUE, FPV21.ID as PROPERTY_HEIGHT_VALUE_ID, FPV22.VALUE as PROPERTY_WEIGHT_BRUTTO_VALUE, FPV22.ID as PROPERTY_WEIGHT_BRUTTO_VALUE_ID, FPV23.VALUE as PROPERTY_PRICE_DATE_UPDATE_VALUE, FPV23.ID as PROPERTY_PRICE_DATE_UPDATE_VALUE_ID, FPV24.VALUE as PROPERTY_OZON_SECTION_ID_VALUE, FPV24.ID as PROPERTY_OZON_SECTION_ID_VALUE_ID, FPV25.VALUE as PROPERTY_OZON_ATTRIBUTESID_8229_VALUE, FPV25.ID as PROPERTY_OZON_ATTRIBUTESID_8229_VALUE_ID, FPV26.VALUE as PROPERTY_OZON_ATTRIBUTESID_4958_VALUE, FPV26.ID as PROPERTY_OZON_ATTRIBUTESID_4958_VALUE_ID
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=’HIT’
LEFT JOIN b_iblock_property FP1 ON FP1.IBLOCK_ID = B.ID AND FP1.CODE=’SALE_TEXT’
LEFT JOIN b_iblock_property FP2 ON FP2.IBLOCK_ID = B.ID AND FP2.CODE=’WEIGHT’
LEFT JOIN b_iblock_property FP3 ON FP3.IBLOCK_ID = B.ID AND FP3.CODE=’CML2_ARTICLE’
LEFT JOIN b_iblock_property FP4 ON FP4.IBLOCK_ID = B.ID AND FP4.CODE=’DIMENSIONS’
LEFT JOIN b_iblock_property FP5 ON FP5.IBLOCK_ID = B.ID AND FP5.CODE=’WEIGHT_NUMBER’
LEFT JOIN b_iblock_property FP6 ON FP6.IBLOCK_ID = B.ID AND FP6.CODE=’BARCODE’
LEFT JOIN b_iblock_property FP7 ON FP7.IBLOCK_ID = B.ID AND FP7.CODE=’PRICE_PER_1_PIECE’
LEFT JOIN b_iblock_property FP8 ON FP8.IBLOCK_ID = B.ID AND FP8.CODE=’TYPE_PREFIX’
LEFT JOIN b_iblock_property FP9 ON FP9.IBLOCK_ID = B.ID AND FP9.CODE=’VENDOR’
LEFT JOIN b_iblock_property FP10 ON FP10.IBLOCK_ID = B.ID AND FP10.CODE=’MODEL’
LEFT JOIN b_iblock_property FP11 ON FP11.IBLOCK_ID = B.ID AND FP11.CODE=’STATUS’
LEFT JOIN b_iblock_property FP12 ON FP12.IBLOCK_ID = B.ID AND FP12.CODE=’BRAND’
LEFT JOIN b_iblock_property FP13 ON FP13.IBLOCK_ID = B.ID AND FP13.CODE=’CATEGORY_LVL_1′
LEFT JOIN b_iblock_property FP14 ON FP14.IBLOCK_ID = B.ID AND FP14.CODE=’CATEGORY_LVL_2′
LEFT JOIN b_iblock_property FP15 ON FP15.IBLOCK_ID = B.ID AND FP15.CODE=’CATEGORY_LVL_3′
LEFT JOIN b_iblock_property FP16 ON FP16.IBLOCK_ID = B.ID AND FP16.CODE=’STORES’
LEFT JOIN b_iblock_property FP17 ON FP17.IBLOCK_ID = B.ID AND FP17.CODE=’STORES_ID’
LEFT JOIN b_iblock_property FP18 ON FP18.IBLOCK_ID = B.ID AND FP18.CODE=’LINK_TO_SECOND_ITEM’
LEFT JOIN b_iblock_property FP19 ON FP19.IBLOCK_ID = B.ID AND FP19.CODE=’WIDTH’
LEFT JOIN b_iblock_property FP20 ON FP20.IBLOCK_ID = B.ID AND FP20.CODE=’LENGTH’
LEFT JOIN b_iblock_property FP21 ON FP21.IBLOCK_ID = B.ID AND FP21.CODE=’HEIGHT’
LEFT JOIN b_iblock_property FP22 ON FP22.IBLOCK_ID = B.ID AND FP22.CODE=’WEIGHT_BRUTTO’
LEFT JOIN b_iblock_property FP23 ON FP23.IBLOCK_ID = B.ID AND FP23.CODE=’PRICE_DATE_UPDATE’
LEFT JOIN b_iblock_property FP24 ON FP24.IBLOCK_ID = B.ID AND FP24.CODE=’OZON_SECTION_ID’
LEFT JOIN b_iblock_property FP25 ON FP25.IBLOCK_ID = B.ID AND FP25.CODE=’OZON_ATTRIBUTESID_8229′
LEFT JOIN b_iblock_property FP26 ON FP26.IBLOCK_ID = B.ID AND FP26.CODE=’OZON_ATTRIBUTESID_4958′
INNER JOIN b_iblock_property FP27 ON FP27.IBLOCK_ID = B.ID AND FP27.ID=292
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
LEFT JOIN b_iblock_element_property FPV3 ON FPV3.IBLOCK_PROPERTY_ID = FP3.ID AND FPV3.IBLOCK_ELEMENT_ID = BE.ID
LEFT JOIN b_iblock_element_property FPV4 ON FPV4.IBLOCK_PROPERTY_ID = FP4.ID AND FPV4.IBLOCK_ELEMENT_ID = BE.ID
LEFT JOIN b_iblock_element_property FPV5 ON FPV5.IBLOCK_PROPERTY_ID = FP5.ID AND FPV5.IBLOCK_ELEMENT_ID = BE.ID
LEFT JOIN b_iblock_element_property FPV6 ON FPV6.IBLOCK_PROPERTY_ID = FP6.ID AND FPV6.IBLOCK_ELEMENT_ID = BE.ID
LEFT JOIN b_iblock_element_property FPV7 ON FPV7.IBLOCK_PROPERTY_ID = FP7.ID AND FPV7.IBLOCK_ELEMENT_ID = BE.ID
LEFT JOIN b_iblock_element_property FPV8 ON FPV8.IBLOCK_PROPERTY_ID = FP8.ID AND FPV8.IBLOCK_ELEMENT_ID = BE.ID
LEFT JOIN b_iblock_element_property FPV9 ON FPV9.IBLOCK_PROPERTY_ID = FP9.ID AND FPV9.IBLOCK_ELEMENT_ID = BE.ID
LEFT JOIN b_iblock_element_property FPV10 ON FPV10.IBLOCK_PROPERTY_ID = FP10.ID AND FPV10.IBLOCK_ELEMENT_ID = BE.ID
LEFT JOIN b_iblock_element_property FPV11 ON FPV11.IBLOCK_PROPERTY_ID = FP11.ID AND FPV11.IBLOCK_ELEMENT_ID = BE.ID
LEFT JOIN b_iblock_element_property FPV12 ON FPV12.IBLOCK_PROPERTY_ID = FP12.ID AND FPV12.IBLOCK_ELEMENT_ID = BE.ID
LEFT JOIN b_iblock_element_property FPV13 ON FPV13.IBLOCK_PROPERTY_ID = FP13.ID AND FPV13.IBLOCK_ELEMENT_ID = BE.ID
LEFT JOIN b_iblock_element_property FPV14 ON FPV14.IBLOCK_PROPERTY_ID = FP14.ID AND FPV14.IBLOCK_ELEMENT_ID = BE.ID
LEFT JOIN b_iblock_element_property FPV15 ON FPV15.IBLOCK_PROPERTY_ID = FP15.ID AND FPV15.IBLOCK_ELEMENT_ID = BE.ID
LEFT JOIN b_iblock_element_property FPV16 ON FPV16.IBLOCK_PROPERTY_ID = FP16.ID AND FPV16.IBLOCK_ELEMENT_ID = BE.ID
LEFT JOIN b_iblock_element_property FPV17 ON FPV17.IBLOCK_PROPERTY_ID = FP17.ID AND FPV17.IBLOCK_ELEMENT_ID = BE.ID
LEFT JOIN b_iblock_element_property FPV18 ON FPV18.IBLOCK_PROPERTY_ID = FP18.ID AND FPV18.IBLOCK_ELEMENT_ID = BE.ID
LEFT JOIN b_iblock_element_property FPV19 ON FPV19.IBLOCK_PROPERTY_ID = FP19.ID AND FPV19.IBLOCK_ELEMENT_ID = BE.ID
LEFT JOIN b_iblock_element_property FPV20 ON FPV20.IBLOCK_PROPERTY_ID = FP20.ID AND FPV20.IBLOCK_ELEMENT_ID = BE.ID
LEFT JOIN b_iblock_element_property FPV21 ON FPV21.IBLOCK_PROPERTY_ID = FP21.ID AND FPV21.IBLOCK_ELEMENT_ID = BE.ID
LEFT JOIN b_iblock_element_property FPV22 ON FPV22.IBLOCK_PROPERTY_ID = FP22.ID AND FPV22.IBLOCK_ELEMENT_ID = BE.ID
LEFT JOIN b_iblock_element_property FPV23 ON FPV23.IBLOCK_PROPERTY_ID = FP23.ID AND FPV23.IBLOCK_ELEMENT_ID = BE.ID
LEFT JOIN b_iblock_element_property FPV24 ON FPV24.IBLOCK_PROPERTY_ID = FP24.ID AND FPV24.IBLOCK_ELEMENT_ID = BE.ID
LEFT JOIN b_iblock_element_property FPV25 ON FPV25.IBLOCK_PROPERTY_ID = FP25.ID AND FPV25.IBLOCK_ELEMENT_ID = BE.ID
LEFT JOIN b_iblock_element_property FPV26 ON FPV26.IBLOCK_PROPERTY_ID = FP26.ID AND FPV26.IBLOCK_ELEMENT_ID = BE.ID
INNER JOIN b_iblock_element_property FPV27 ON FPV27.IBLOCK_PROPERTY_ID = FP27.ID AND FPV27.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 = FPV2.IBLOCK_PROPERTY_ID AND FPV2.VALUE_ENUM = FPEN1.ID
LEFT JOIN b_iblock_property_enum FPEN2 ON FPEN2.PROPERTY_ID = FPV4.IBLOCK_PROPERTY_ID AND FPV4.VALUE_ENUM = FPEN2.ID

WHERE 1=1
AND (

((((BE.IBLOCK_ID = ’27’))))
AND ((((FPV27.VALUE_NUM = ‘254506’))))
)
AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL)))

[[1116] Too many tables; MySQL can only use 61 tables in a join]