[Bitrix\Main\DB\SqlQueryException]
Mysql query error: (1146) Table 'sitemanager.b_iblock_4_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 POSITION('.' IN 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_4_index F
INNER JOIN (
SELECT BE.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_catalog_product as PRD on (PRD.ID = BE.ID)
INNER JOIN b_iblock_4_index FC on FC.ELEMENT_ID = BE.ID
WHERE 1=1 AND FC.SECTION_ID = 1424 AND FC.FACET_ID = 2124 AND FC.VALUE_NUM = 0 AND FC.VALUE in (90925)
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 = 4))))
AND ((((PRD.AVAILABLE='Y'))))
)
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')
))
) E ON E.ID = F.ELEMENT_ID
WHERE
F.SECTION_ID = 1424
and F.FACET_ID in (2128,2154,904,2152,2156,2164,2728,2168,2170,2218,2132,1586,1834,2130,2136,2138,2142,2144,2146,2148,2150,2158,2160,2162,2172,2174,2176,2178,2180,2182,2186,2188,2190,2192,2194,2196,2198,2200,2202,2204,2206,2208,2210,2212,2214,2216,2220,2222,2224,2226,2236,2238,2240,2242,2244,2246,2248,2250,2252,2254,2256,2258,2260,2262,2264,2266,2268,2272,2274,2276,2278,2280,2282,2284,2286,2288,2290,2292,2294,2296,2298,2300,2304,2306,2308,2310,2312,2314,2316,2318,2320,2322,2324,2326,2330,2332,2334,2336,2338,2340,2342,2346,2348,2350,2352,2358,2360,2362,2364,2366,2368,2370,2372,2374,2376,2378,2380,2382,2384,2386,2388,2390,2394,2396,2398,2414,2418,2420,2422,2424,2426,2428,2430,2432,2434,2436,2442,2444,2446,2448,2450,2452,2454,2456,2458,2460,2462,2464,2466,2468,2470,2472,2476,2478,2482,2484,2486,2490,2492,2494,2496,2498,2500,2502,2506,2508,2510,2514,2516,2518,2520,2522,2524,2528,2530,2532,2534,2536,2538,2540,2542,2544,2546,2548,2552,2554,2556,2558,2560,2562,2564,2566,2568,2570,2574,2576,2578,2580,2582,2586,2592,2594,2598,2600,2608,2624,2626,2628,2630,2632,2634,2638,2640,2642,2646,2648,2654,2656,2660,2668,2670,2672,2674,2676,2678,2680,2698,2700,2702,2704,2706,2708,2712,2714,2716,2718,2720,2722,2724,2730,3)
GROUP BY
F.FACET_ID, F.VALUE
UNION ALL
SELECT
F.FACET_ID
,F.VALUE
,MIN(F.VALUE_NUM) MIN_VALUE_NUM
,MAX(F.VALUE_NUM) MAX_VALUE_NUM
,MAX(case when POSITION('.' IN 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
left join b_catalog_product as PRD on (PRD.ID = BE.ID)
INNER JOIN b_iblock_4_index F ON BE.ID = F.ELEMENT_ID
WHERE
F.SECTION_ID = 1424
and F.FACET_ID in (2124)
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 = 4))))
AND ((((PRD.AVAILABLE='Y'))))
)
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')
))
GROUP BY
F.FACET_ID, F.VALUE
/home/bitrix/www/bitrix/modules/main/lib/db/mysqlcommonconnection.php:417
#0: Bitrix\Main\DB\MysqlCommonConnection->createQueryException
/home/bitrix/www/bitrix/modules/main/lib/db/mysqliconnection.php:149
#1: Bitrix\Main\DB\MysqliConnection->queryInternal
/home/bitrix/www/bitrix/modules/main/lib/db/connection.php:324
#2: Bitrix\Main\DB\Connection->query
/home/bitrix/www/bitrix/modules/iblock/lib/propertyindex/facet.php:340
#3: Bitrix\Iblock\PropertyIndex\Facet->query
/home/bitrix/www/bitrix/components/bitrix/catalog.smart.filter/component.php:469
#4: include(string)
/home/bitrix/www/bitrix/modules/main/classes/general/component.php:622
#5: CBitrixComponent->__includeComponent
/home/bitrix/www/bitrix/modules/main/classes/general/component.php:105
#6: CBitrixComponent->executeComponent
/home/bitrix/www/bitrix/components/bitrix/catalog.smart.filter/class.php:151
#7: CBitrixCatalogSmartFilter->executeComponent
/home/bitrix/www/bitrix/modules/main/classes/general/component.php:675
#8: CBitrixComponent->includeComponent
/home/bitrix/www/bitrix/modules/main/classes/general/main.php:1192
#9: CMain->IncludeComponent
/home/bitrix/www/local/templates/main/components/bitrix/catalog/catalog/section.php:183
#10: include(string)
/home/bitrix/www/bitrix/modules/main/classes/general/component_template.php:842
#11: CBitrixComponentTemplate->__IncludePHPTemplate
/home/bitrix/www/bitrix/modules/main/classes/general/component_template.php:951
#12: CBitrixComponentTemplate->IncludeTemplate
/home/bitrix/www/bitrix/modules/main/classes/general/component.php:791
#13: CBitrixComponent->showComponentTemplate
/home/bitrix/www/bitrix/modules/main/classes/general/component.php:731
#14: CBitrixComponent->includeComponentTemplate
/home/bitrix/www/bitrix/components/bitrix/catalog/component.php:330
#15: include(string)
/home/bitrix/www/bitrix/modules/main/classes/general/component.php:622
#16: CBitrixComponent->__includeComponent
/home/bitrix/www/bitrix/modules/main/classes/general/component.php:699
#17: CBitrixComponent->includeComponent
/home/bitrix/www/bitrix/modules/main/classes/general/main.php:1192
#18: CMain->IncludeComponent
/home/bitrix/www/catalog/index.php:23
#19: require(string)
/home/bitrix/www/bitrix/modules/webdebug.seo/lib/page.php:662
#20: WD\Seo\Page::includeComponentScript
/home/bitrix/www/bitrix/modules/webdebug.seo/lib/page.php:648
#21: WD\Seo\Page::checkIncludeComponentScript
/home/bitrix/www/bitrix/modules/webdebug.seo/lib/page.php:214
#22: WD\Seo\Page::onProlog
/home/bitrix/www/bitrix/modules/webdebug.seo/lib/eventhandler.php:54
#23: WD\Seo\EventHandler::onProlog
/home/bitrix/www/bitrix/modules/main/tools.php:5273
#24: ExecuteModuleEventEx
/home/bitrix/www/bitrix/modules/main/classes/general/main.php:3685
#25: CMain::PrologActions
/home/bitrix/www/bitrix/modules/main/include/prolog_before.php:21
#26: require_once(string)
/home/bitrix/www/bitrix/modules/main/include/prolog.php:10
#27: require_once(string)
/home/bitrix/www/bitrix/header.php:1
#28: require(string)
/home/bitrix/www/catalog/index.php:2
#29: include_once(string)
/home/bitrix/www/bitrix/modules/main/include/urlrewrite.php:128
#30: include_once(string)
/home/bitrix/www/bitrix/urlrewrite.php:2
----------
