[Bitrix\Main\DB\SqlQueryException]
Mysql query error: (1146) Table 'tehnikaoptom.b_iblock_21_index' doesn't exist (400)
SELECT
F.FACET_ID
,F.VALUE
,MIN(F.VALUE_NUM) MIN_VALUE_NUM
,MAX(F.VALUE_NUM) MAX_VALUE_NUM
,MAX(case when LOCATE('.', F.VALUE_NUM) > 0 then LENGTH(SUBSTRING_INDEX(F.VALUE_NUM, '.', -1)) else 0 end) VALUE_FRAC_LEN
,COUNT(DISTINCT F.ELEMENT_ID) ELEMENT_COUNT
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.CODE='BRAND'
LEFT JOIN b_iblock_property FP1 ON FP1.IBLOCK_ID = B.ID AND FP1.CODE='DISCOUNT_PERCENT'
INNER JOIN b_iblock_property FP2 ON FP2.IBLOCK_ID = B.ID AND FP2.CODE='CATALOG_PRICE_2'
LEFT JOIN b_iblock_property FP3 ON FP3.IBLOCK_ID = B.ID AND FP3.CODE='OUT_OF_PRODUCTION'
INNER 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
INNER 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_property_enum FPEN0 ON FPEN0.PROPERTY_ID = FPV3.IBLOCK_PROPERTY_ID AND FPV3.VALUE_ENUM = FPEN0.ID
left join b_catalog_price as CAT_P1 on (CAT_P1.PRODUCT_ID = BE.ID and CAT_P1.CATALOG_GROUP_ID = 1)
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))
INNER JOIN b_iblock_21_index F ON BE.ID = F.ELEMENT_ID
WHERE
F.SECTION_ID = 445
and F.FACET_ID in (17492,17134,17494,8726,4942,9270,18124,15700,15702,15704,15706,15730,15802,15856,15878,15918,16190,3)
AND (
(((BE.ACTIVE_TO >= now() OR BE.ACTIVE_TO IS NULL) AND (BE.ACTIVE_FROM <= now() OR BE.ACTIVE_FROM IS NULL)))
AND ((((BE.IBLOCK_ID = '21'))))
AND (((BE.DETAIL_PICTURE IS NOT NULL)))
AND (((BE.ID IS NULL OR NOT (BE.ID IN ('66786', '67075', '67074')))))
AND (((BE.IBLOCK_SECTION_ID IS NULL OR NOT (BE.IBLOCK_SECTION_ID IN ('433', '430')))))
AND (
(
((((FPV0.VALUE LIKE 'maunfeld'))))
AND ((((FPV1.VALUE_NUM >= '9'))))
)
OR (
((((FPV1.VALUE_NUM >= '0'))))
AND ((( FPV0.VALUE IS NULL OR NOT (FPV0.VALUE LIKE 'maunfeld'))))
)
)
AND ((((FPV2.VALUE > '0'))))
AND ((( FPEN0.VALUE IS NULL OR NOT (FPEN0.VALUE LIKE 'Y'))))
AND ((((FPV0.VALUE LIKE 'oulin'))))
AND ((((CAT_P1.PRICE > '10'))))
)
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'
))
))
GROUP BY
F.FACET_ID, F.VALUE
/var/www/tekhnikaoptom/data/www/good-tech2/bitrix/modules/main/lib/db/mysqliconnection.php:137
#0: Bitrix\Main\DB\MysqliConnection->queryInternal(string, array, NULL)
/var/www/tekhnikaoptom/data/www/good-tech2/bitrix/modules/main/lib/db/connection.php:330
#1: Bitrix\Main\DB\Connection->query(string)
/var/www/tekhnikaoptom/data/www/good-tech2/bitrix/modules/iblock/lib/propertyindex/facet.php:343
#2: Bitrix\Iblock\PropertyIndex\Facet->query(array)
/var/www/tekhnikaoptom/data/www/good-tech2/bitrix/components/bitrix/catalog.smart.filter/component.php:62
#3: include(string)
/var/www/tekhnikaoptom/data/www/good-tech2/bitrix/modules/main/classes/general/component.php:594
#4: CBitrixComponent->__includeComponent()
/var/www/tekhnikaoptom/data/www/good-tech2/bitrix/modules/main/classes/general/component.php:102
#5: CBitrixComponent->executeComponent()
/var/www/tekhnikaoptom/data/www/good-tech2/bitrix/components/bitrix/catalog.smart.filter/class.php:138
#6: CBitrixCatalogSmartFilter->executeComponent()
/var/www/tekhnikaoptom/data/www/good-tech2/bitrix/modules/main/classes/general/component.php:638
#7: CBitrixComponent->includeComponent(string, array, object)
/var/www/tekhnikaoptom/data/www/good-tech2/bitrix/modules/main/classes/general/main.php:1038
#8: CAllMain->IncludeComponent(string, string, array, object, array)
/var/www/tekhnikaoptom/data/www/good-tech2/local/templates/techopt/components/bitrix/catalog/.default/section_vertical.php:124
#9: include(string)
/var/www/tekhnikaoptom/data/www/good-tech2/local/templates/techopt/components/bitrix/catalog/.default/section.php:73
#10: include(string)
/var/www/tekhnikaoptom/data/www/good-tech2/bitrix/modules/main/classes/general/component_template.php:725
#11: CBitrixComponentTemplate->__IncludePHPTemplate(array, array, string)
/var/www/tekhnikaoptom/data/www/good-tech2/bitrix/modules/main/classes/general/component_template.php:820
#12: CBitrixComponentTemplate->IncludeTemplate(array)
/var/www/tekhnikaoptom/data/www/good-tech2/bitrix/modules/main/classes/general/component.php:735
#13: CBitrixComponent->showComponentTemplate()
/var/www/tekhnikaoptom/data/www/good-tech2/bitrix/modules/main/classes/general/component.php:683
#14: CBitrixComponent->includeComponentTemplate(string)
/var/www/tekhnikaoptom/data/www/good-tech2/bitrix/components/bitrix/catalog/component.php:171
#15: include(string)
/var/www/tekhnikaoptom/data/www/good-tech2/bitrix/modules/main/classes/general/component.php:594
#16: CBitrixComponent->__includeComponent()
/var/www/tekhnikaoptom/data/www/good-tech2/bitrix/modules/main/classes/general/component.php:653
#17: CBitrixComponent->includeComponent(string, array, boolean)
/var/www/tekhnikaoptom/data/www/good-tech2/bitrix/modules/main/classes/general/main.php:1038
#18: CAllMain->IncludeComponent(string, string, array, boolean)
/var/www/tekhnikaoptom/data/www/good-tech2/sites/s1/catalog/index.php:854
#19: include_once(string)
/var/www/tekhnikaoptom/data/www/good-tech2/bitrix/modules/main/include/urlrewrite.php:159
#20: include_once(string)
/var/www/tekhnikaoptom/data/www/good-tech2/bitrix/urlrewrite.php:2