Tygh\Exceptions\AException

Message

The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay (1104)

SELECT cscart_product_filters.filter_id, cscart_product_features_values.variant_id FROM cscart_product_features_values LEFT JOIN cscart_products as products ON products.product_id = cscart_product_features_values.product_id LEFT JOIN cscart_product_filters ON cscart_product_filters.feature_id = cscart_product_features_values.feature_id LEFT JOIN cscart_product_features ON cscart_product_features.feature_id = cscart_product_features_values.feature_id LEFT JOIN cscart_product_features_values as var_val_106 ON var_val_106.product_id = products.product_id AND var_val_106.lang_code = 'ru' AND var_val_106.feature_id = 106 LEFT JOIN cscart_product_options_inventory as inventory ON inventory.product_id = products.product_id INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') LEFT JOIN cscart_product_features_values as var_val_102 ON var_val_102.product_id = products.product_id AND var_val_102.lang_code = 'ru' AND var_val_102.feature_id = 102 LEFT JOIN cscart_product_features_values as var_val_104 ON var_val_104.product_id = products.product_id AND var_val_104.lang_code = 'ru' AND var_val_104.feature_id = 104 LEFT JOIN cscart_product_features_values as var_val_103 ON var_val_103.product_id = products.product_id AND var_val_103.lang_code = 'ru' AND var_val_103.feature_id = 103 WHERE cscart_product_filters.filter_id IN (1, 19, 10, 21, 32, 33, 25, 27, 18, 28, 20, 14, 24, 15, 61) AND cscart_product_features_values.feature_id IN (98, 18, 94, 109, 110, 102, 104, 92, 103, 95, 55, 100, 54, 97) AND cscart_product_features_values.lang_code = 'ru' AND (var_val_106.variant_id IN (328)) AND cscart_categories.category_id IN (283, 337, 308, 309, 310, 336, 317, 329, 330, 335, 333, 334, 288, 289, 290, 291, 292, 293, 294, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307) AND cscart_categories.company_id = 1 AND (CASE products.tracking WHEN 'O' THEN inventory.amount > 0 WHEN 'B' THEN products.amount > 0 ELSE 1 END) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND products.product_type IN ('P', 'C') AND ((var_val_102.variant_id IN (284) AND var_val_104.variant_id IN (290) AND var_val_103.variant_id IN (287) AND cscart_product_features_values.feature_id NOT IN (102, 104, 103)) OR (var_val_104.variant_id IN (290) AND var_val_103.variant_id IN (287) AND cscart_product_features_values.feature_id = 102) OR (var_val_102.variant_id IN (284) AND var_val_103.variant_id IN (287) AND cscart_product_features_values.feature_id = 104) OR (var_val_102.variant_id IN (284) AND var_val_104.variant_id IN (290) AND cscart_product_features_values.feature_id = 103)) AND cscart_product_features.feature_type IN ('S', 'M', 'E') GROUP BY cscart_product_features_values.variant_id

Error at

app/Tygh/Database/Connection.php, line: 1136

Backtrace

File:app/Tygh/Database/Connection.php
Line:500
Function:throwError
File:app/Tygh/Database/Connection.php
Line:384
Function:query
File:app/functions/fn.database.php
Line:107
Function:getSingleHash
File:app/functions/fn.catalog.php
Line:10940
Function:db_get_hash_single_array
File:app/functions/fn.catalog.php
Line:10498
Function:fn_get_current_filters
File:app/Tygh/BlockManager/Block.php
Line:809
Function:fn_get_filters_products_count
File:app/Tygh/BlockManager/RenderManager.php
Line:778
Function:getItems
File:app/Tygh/BlockManager/RenderManager.php
Line:644
Function:getValue
File:app/Tygh/BlockManager/RenderManager.php
Line:475
Function:renderBlockContent
File:app/Tygh/BlockManager/RenderManager.php
Line:397
Function:renderBlock
File:app/Tygh/BlockManager/RenderManager.php
Line:357
Function:renderBlocks
File:app/Tygh/BlockManager/RenderManager.php
Line:222
Function:renderGrid
File:app/Tygh/BlockManager/RenderManager.php
Line:192
Function:renderGrids
File:app/Tygh/BlockManager/RenderManager.php
Line:156
Function:_renderContainer
File:app/functions/smarty_plugins/function.render_location.php
Line:48
Function:render
File:var/cache/templates/bright_theme/4731cf16141fa3bb9f2daa9a519c26987e61d018.tygh.index.tpl.php
Line:183
Function:smarty_function_render_location
File:app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php
Line:188
Function:content_5c670a9e897259_28275862
File:app/Tygh/SmartyEngine/Core.php
Line:76
Function:fetch
File:app/functions/fn.control.php
Line:585
Function:fetch
File:index.php
Line:25
Function:fn_dispatch