MySQL Query Error: SELECT COUNT(DISTINCT BE.ID) as C 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.ID=77 INNER JOIN b_iblock_property FP1 ON FP1.IBLOCK_ID = B.ID AND FP1.ID=76 INNER JOIN b_iblock_property FP2 ON FP2.IBLOCK_ID = B.ID AND FP2.ID=137 INNER JOIN b_iblock_property FP3 ON FP3.IBLOCK_ID = B.ID AND FP3.ID=74 INNER JOIN b_iblock_property FP4 ON FP4.IBLOCK_ID = B.ID AND FP4.ID=75 LEFT JOIN b_iblock_property FP5 ON FP5.IBLOCK_ID = B.ID AND FP5.ID=169 INNER JOIN b_iblock_element_property FPV0 ON FPV0.IBLOCK_PROPERTY_ID = FP0.ID AND FPV0.IBLOCK_ELEMENT_ID = BE.ID INNER 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 INNER JOIN b_iblock_element_property FPV3 ON FPV3.IBLOCK_PROPERTY_ID = FP3.ID AND FPV3.IBLOCK_ELEMENT_ID = BE.ID INNER 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 INNER JOIN b_iblock_property_enum FPEN0 ON FPEN0.PROPERTY_ID = FPV0.IBLOCK_PROPERTY_ID AND FPV0.VALUE_ENUM = FPEN0.ID INNER JOIN b_iblock_property_enum FPEN1 ON FPEN1.PROPERTY_ID = FPV1.IBLOCK_PROPERTY_ID AND FPV1.VALUE_ENUM = FPEN1.ID INNER JOIN b_iblock_property_enum FPEN2 ON FPEN2.PROPERTY_ID = FPV2.IBLOCK_PROPERTY_ID AND FPV2.VALUE_ENUM = FPEN2.ID INNER JOIN b_iblock_property_enum FPEN3 ON FPEN3.PROPERTY_ID = FPV3.IBLOCK_PROPERTY_ID AND FPV3.VALUE_ENUM = FPEN3.ID INNER JOIN b_iblock_property_enum FPEN4 ON FPEN4.PROPERTY_ID = FPV4.IBLOCK_PROPERTY_ID AND FPV4.VALUE_ENUM = FPEN4.ID LEFT JOIN b_iblock_property_enum FPEN5 ON FPEN5.PROPERTY_ID = FPV5.IBLOCK_PROPERTY_ID AND FPV5.VALUE_ENUM = FPEN5.ID INNER JOIN b_iblock_4_index FC on FC.ELEMENT_ID = BE.ID WHERE 1=1 AND ( (FC.SECTION_ID = 3 AND FC.FACET_ID = 1 AND FC.VALUE_NUM = 0 AND FC.VALUE in (0) and FC.INCLUDE_SUBSECTIONS=1) AND ((( BE.CODE IS NULL OR NOT (BE.CODE LIKE '189-4-160-300')))) 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 = '4')))) AND ((((FPEN0.VALUE LIKE 'коричневый')))) AND ((((FPEN1.VALUE LIKE 'плотная портьерная')))) AND ((((FPEN2.VALUE LIKE 'складская')))) AND ((((FPEN3.VALUE LIKE 'однотонный')))) AND ((((FPEN4.VALUE LIKE 'портьерная')))) AND ((( FPEN5.VALUE IS NULL OR NOT (FPEN5.VALUE LIKE 'снято с производства')))) ) 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' )) )) [[1146] Table 'tq2xvbsdb.b_iblock_4_index' doesn't exist]

DB query error.
Please try later.

Salino

Компаньоны

Похожие товары