Loading...

Database error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/tmp/#sql_1701_11' at line 1 (1064)
Invalid query: SELECT cscart_product_features_values.feature_id, COUNT(DISTINCT cscart_products.product_id) as products, cscart_product_filter_ranges.range_id, cscart_product_filter_ranges_descriptions.range_name, cscart_product_filter_ranges.filter_id, cscart_product_features.feature_type FROM cscart_product_filter_ranges LEFT JOIN cscart_product_features_values ON cscart_product_features_values.feature_id = cscart_product_filter_ranges.feature_id AND cscart_product_features_values.value_int >= cscart_product_filter_ranges.from AND cscart_product_features_values.value_int <= cscart_product_filter_ranges.to LEFT JOIN cscart_products ON cscart_products.product_id = cscart_product_features_values.product_id LEFT JOIN cscart_product_filter_ranges_descriptions ON cscart_product_filter_ranges_descriptions.range_id = cscart_product_filter_ranges.range_id AND cscart_product_filter_ranges_descriptions.lang_code = 'EN' LEFT JOIN cscart_product_features ON cscart_product_features.feature_id = cscart_product_filter_ranges.feature_id LEFT JOIN (SELECT product_id, GROUP_CONCAT(cscart_product_features_values.variant_id) AS simple_variants FROM cscart_product_features_values WHERE lang_code = 'EN' GROUP BY product_id) AS pfv_simple ON pfv_simple.product_id = cscart_products.product_id INNER JOIN cscart_products_categories ON cscart_products_categories.product_id = cscart_products.product_id LEFT JOIN cscart_categories ON cscart_categories.category_id = cscart_products_categories.category_id LEFT JOIN cscart_product_options_inventory as inventory ON inventory.product_id = cscart_products.product_id WHERE cscart_product_features_values.feature_id IN (14) AND cscart_product_features_values.lang_code = 'EN' AND cscart_products_categories.category_id IN (739, 740, 741, 314) AND FIND_IN_SET('771', simple_variants) AND FIND_IN_SET('465', simple_variants) 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_products.usergroup_ids = '' OR FIND_IN_SET(0, cscart_products.usergroup_ids) OR FIND_IN_SET(1, cscart_products.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_products.status IN ('A') AND IF(cscart_products.tracking = 'O', inventory.amount > 0, cscart_products.amount > 0) AND cscart_product_filter_ranges.filter_id = 12 GROUP BY cscart_product_filter_ranges.range_id ORDER BY cscart_product_filter_ranges.position, cscart_product_filter_ranges_descriptions.range_name

Backtrace:

File:/home/eapcom/public_html/core/fn.database.php
Line:310
Function:db_error
File:/home/eapcom/public_html/core/fn.database.php
Line:206
Function:db_query
File:/home/eapcom/public_html/core/fn.catalog.php
Line:2009
Function:db_get_hash_multi_array
File:/home/eapcom/public_html/core/fn.catalog.php
Line:2106
Function:fn_get_filters_products_count
File:/home/eapcom/public_html/core/fn.cms.php
Line:657
Function:fn_get_filters_products_count
File:/home/eapcom/public_html/core/templater_plugins/function.block.php
Line:46
Function:fn_get_block_items
File:/home/eapcom/public_html/var/compiled/customer/%%C2^C22^C22744D9%%left.tpl.php
Line:17
Function:smarty_function_block
File:/home/eapcom/public_html/core/class.templater.php
Line:133
Function:include
File:/home/eapcom/public_html/var/compiled/customer/%%72^72D^72DAF6E8%%main.tpl.php
Line:19
Function:_smarty_include
File:/home/eapcom/public_html/core/class.templater.php
Line:133
Function:include
File:/home/eapcom/public_html/var/compiled/customer/%%45^45E^45E480CD%%index.tpl.php
Line:419
Function:_smarty_include
File:/home/eapcom/public_html/lib/templater/Smarty.class.php
Line:1265
Function:include
File:/home/eapcom/public_html/lib/templater/Smarty.class.php
Line:1108
Function:fetch
File:/home/eapcom/public_html/core/class.templater.php
Line:170
Function:display
File:/home/eapcom/public_html/core/fn.control.php
Line:471
Function:display
File:/home/eapcom/public_html/index.php
Line:27
Function:fn_dispatch