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 (331)) 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
app/Tygh/Database/Connection.php, line: 1136
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 |