MySQL Query Error:
SELECT DISTINCT BE.ID as ID,BE.ACTIVE as ACTIVE,BE.NAME as NAME,BE.DETAIL_TEXT as DETAIL_TEXT,BE.PREVIEW_TEXT as PREVIEW_TEXT,BE.IBLOCK_SECTION_ID as IBLOCK_SECTION_ID, FPV0.VALUE as PROPERTY_USER_FRANCHISE_VALUE, FPV0.ID as PROPERTY_USER_FRANCHISE_VALUE_ID, FPV1.VALUE as PROPERTY_ARTICLE_VALUE, FPV1.ID as PROPERTY_ARTICLE_VALUE_ID, FPV2.VALUE as PROPERTY_ADVANTAGES_VALUE, FPV2.ID as PROPERTY_ADVANTAGES_VALUE_ID, FPV3.VALUE as PROPERTY_PROFITS_CALCULATION_VALUE, FPV3.ID as PROPERTY_PROFITS_CALCULATION_VALUE_ID, FPV4.VALUE as PROPERTY_PRESENTATION_VALUE, FPV4.ID as PROPERTY_PRESENTATION_VALUE_ID, FPV5.VALUE as PROPERTY_VIDEO_VALUE, FPV5.ID as PROPERTY_VIDEO_VALUE_ID, FPV6.VALUE as PROPERTY_BRAND_BANNER_VALUE, FPV6.ID as PROPERTY_BRAND_BANNER_VALUE_ID, FPV7.VALUE as PROPERTY_BRAND_VALUE, FPV7.ID as PROPERTY_BRAND_VALUE_ID, FPV8.VALUE as PROPERTY_BRAND_SIGNATURE_VALUE, FPV8.ID as PROPERTY_BRAND_SIGNATURE_VALUE_ID, FPV9.VALUE as PROPERTY_BRAND_PREVIEW_VALUE, FPV9.ID as PROPERTY_BRAND_PREVIEW_VALUE_ID, FPV10.VALUE as PROPERTY_LOGO_VALUE, FPV10.ID as PROPERTY_LOGO_VALUE_ID, FPEN0.VALUE as PROPERTY_BUSINESS_TYPE_VALUE, FPEN0.ID as PROPERTY_BUSINESS_TYPE_ENUM_ID, FPV11.ID as PROPERTY_BUSINESS_TYPE_VALUE_ID, FPV12.VALUE as PROPERTY_TOTAL_INVESTMENT_VALUE, FPV12.ID as PROPERTY_TOTAL_INVESTMENT_VALUE_ID, FPV13.VALUE as PROPERTY_PAYBACK_PERIOD_VALUE, FPV13.ID as PROPERTY_PAYBACK_PERIOD_VALUE_ID, FPV14.VALUE as PROPERTY_MONTHLY_TURNOVER_VALUE, FPV14.ID as PROPERTY_MONTHLY_TURNOVER_VALUE_ID, FPV15.VALUE as PROPERTY_BRAND_INFO_VALUE, FPV15.ID as PROPERTY_BRAND_INFO_VALUE_ID, FPV16.VALUE as PROPERTY_REQUIREMENTS_VALUE, FPV16.ID as PROPERTY_REQUIREMENTS_VALUE_ID, FPV17.VALUE as PROPERTY_DOMAIN_TARGET_SITE_VALUE, FPV17.ID as PROPERTY_DOMAIN_TARGET_SITE_VALUE_ID, FPV18.VALUE as PROPERTY_WORK_COMPANY_VALUE, FPV18.ID as PROPERTY_WORK_COMPANY_VALUE_ID, FPV19.VALUE as PROPERTY_WORK_ADRES_VALUE, FPV19.ID as PROPERTY_WORK_ADRES_VALUE_ID, FPV20.VALUE as PROPERTY_OTZIVI_VALUE, FPV20.ID as PROPERTY_OTZIVI_VALUE_ID, FPV21.VALUE as PROPERTY_TEXT_NEW_VALUE, FPV21.ID as PROPERTY_TEXT_NEW_VALUE_ID, FPEN1.VALUE as PROPERTY_NOT_SHOW_IN_CATA_POPUP_VALUE, FPEN1.ID as PROPERTY_NOT_SHOW_IN_CATA_POPUP_ENUM_ID, FPV22.ID as PROPERTY_NOT_SHOW_IN_CATA_POPUP_VALUE_ID, FPV23.VALUE as PROPERTY_CORP_COLOR_VALUE, FPV23.ID as PROPERTY_CORP_COLOR_VALUE_ID, FPV24.VALUE as PROPERTY_SPECIAL_STATUS_LETTER_VALUE, FPV24.ID as PROPERTY_SPECIAL_STATUS_LETTER_VALUE_ID, FPV25.VALUE as PROPERTY_SHOW_SIMILAR_VALUE, FPV25.ID as PROPERTY_SHOW_SIMILAR_VALUE_ID, FPV26.VALUE as PROPERTY_CUSTOM_DATE_UPDATE_VALUE, FPV26.ID as PROPERTY_CUSTOM_DATE_UPDATE_VALUE_ID, FPV27.VALUE as PROPERTY_FRANCHISE_INCLUDE_VALUE, FPV27.ID as PROPERTY_FRANCHISE_INCLUDE_VALUE_ID, FPEN2.VALUE as PROPERTY_NOINDEX_VALUE, FPEN2.ID as PROPERTY_NOINDEX_ENUM_ID, FPV28.ID as PROPERTY_NOINDEX_VALUE_ID,BE.DETAIL_TEXT_TYPE as DETAIL_TEXT_TYPE,BE.PREVIEW_TEXT_TYPE as PREVIEW_TEXT_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='USER_FRANCHISE'
LEFT JOIN b_iblock_property FP1 ON FP1.IBLOCK_ID = B.ID AND FP1.CODE='ARTICLE'
LEFT JOIN b_iblock_property FP2 ON FP2.IBLOCK_ID = B.ID AND FP2.CODE='ADVANTAGES'
LEFT JOIN b_iblock_property FP3 ON FP3.IBLOCK_ID = B.ID AND FP3.CODE='PROFITS_CALCULATION'
LEFT JOIN b_iblock_property FP4 ON FP4.IBLOCK_ID = B.ID AND FP4.CODE='PRESENTATION'
LEFT JOIN b_iblock_property FP5 ON FP5.IBLOCK_ID = B.ID AND FP5.CODE='VIDEO'
LEFT JOIN b_iblock_property FP6 ON FP6.IBLOCK_ID = B.ID AND FP6.CODE='BRAND_BANNER'
LEFT JOIN b_iblock_property FP7 ON FP7.IBLOCK_ID = B.ID AND FP7.CODE='BRAND'
LEFT JOIN b_iblock_property FP8 ON FP8.IBLOCK_ID = B.ID AND FP8.CODE='BRAND_SIGNATURE'
LEFT JOIN b_iblock_property FP9 ON FP9.IBLOCK_ID = B.ID AND FP9.CODE='BRAND_PREVIEW'
LEFT JOIN b_iblock_property FP10 ON FP10.IBLOCK_ID = B.ID AND FP10.CODE='LOGO'
LEFT JOIN b_iblock_property FP11 ON FP11.IBLOCK_ID = B.ID AND FP11.CODE='BUSINESS_TYPE'
LEFT JOIN b_iblock_property FP12 ON FP12.IBLOCK_ID = B.ID AND FP12.CODE='TOTAL_INVESTMENT'
LEFT JOIN b_iblock_property FP13 ON FP13.IBLOCK_ID = B.ID AND FP13.CODE='PAYBACK_PERIOD'
LEFT JOIN b_iblock_property FP14 ON FP14.IBLOCK_ID = B.ID AND FP14.CODE='MONTHLY_TURNOVER'
LEFT JOIN b_iblock_property FP15 ON FP15.IBLOCK_ID = B.ID AND FP15.CODE='BRAND_INFO'
LEFT JOIN b_iblock_property FP16 ON FP16.IBLOCK_ID = B.ID AND FP16.CODE='REQUIREMENTS'
LEFT JOIN b_iblock_property FP17 ON FP17.IBLOCK_ID = B.ID AND FP17.CODE='DOMAIN_TARGET_SITE'
LEFT JOIN b_iblock_property FP18 ON FP18.IBLOCK_ID = B.ID AND FP18.CODE='WORK_COMPANY'
LEFT JOIN b_iblock_property FP19 ON FP19.IBLOCK_ID = B.ID AND FP19.CODE='WORK_ADRES'
LEFT JOIN b_iblock_property FP20 ON FP20.IBLOCK_ID = B.ID AND FP20.CODE='OTZIVI'
LEFT JOIN b_iblock_property FP21 ON FP21.IBLOCK_ID = B.ID AND FP21.CODE='TEXT_NEW'
LEFT JOIN b_iblock_property FP22 ON FP22.IBLOCK_ID = B.ID AND FP22.CODE='NOT_SHOW_IN_CATA_POPUP'
LEFT JOIN b_iblock_property FP23 ON FP23.IBLOCK_ID = B.ID AND FP23.CODE='CORP_COLOR'
LEFT JOIN b_iblock_property FP24 ON FP24.IBLOCK_ID = B.ID AND FP24.CODE='SPECIAL_STATUS_LETTER'
LEFT JOIN b_iblock_property FP25 ON FP25.IBLOCK_ID = B.ID AND FP25.CODE='SHOW_SIMILAR'
LEFT JOIN b_iblock_property FP26 ON FP26.IBLOCK_ID = B.ID AND FP26.CODE='CUSTOM_DATE_UPDATE'
LEFT JOIN b_iblock_property FP27 ON FP27.IBLOCK_ID = B.ID AND FP27.CODE='FRANCHISE_INCLUDE'
LEFT JOIN b_iblock_property FP28 ON FP28.IBLOCK_ID = B.ID AND FP28.CODE='NOINDEX'
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
LEFT JOIN b_iblock_element_property FPV27 ON FPV27.IBLOCK_PROPERTY_ID = FP27.ID AND FPV27.IBLOCK_ELEMENT_ID = BE.ID
LEFT JOIN b_iblock_element_property FPV28 ON FPV28.IBLOCK_PROPERTY_ID = FP28.ID AND FPV28.IBLOCK_ELEMENT_ID = BE.ID
LEFT JOIN b_iblock_property_enum FPEN0 ON FPEN0.PROPERTY_ID = FPV11.IBLOCK_PROPERTY_ID AND FPV11.VALUE_ENUM = FPEN0.ID
LEFT JOIN b_iblock_property_enum FPEN1 ON FPEN1.PROPERTY_ID = FPV22.IBLOCK_PROPERTY_ID AND FPV22.VALUE_ENUM = FPEN1.ID
LEFT JOIN b_iblock_property_enum FPEN2 ON FPEN2.PROPERTY_ID = FPV28.IBLOCK_PROPERTY_ID AND FPV28.VALUE_ENUM = FPEN2.ID
WHERE 1=1
AND (
((((BE.IBLOCK_ID = '1'))))
AND ((((BE.CODE = 'the-bright-eyes-franchise'))))
)
AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL)))
LIMIT 1
[[1116] Too many tables; MySQL can only use 61 tables in a join]