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_55e5_16' 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 (34, 5, 25, 35, 36, 30, 31, 32, 117, 27, 102, 145) AND cscart_product_features_values.lang_code = 'EN' AND cscart_products_categories.category_id IN (172, 513, 515, 521, 522, 523, 578, 767, 768, 526, 527, 528, 529, 530, 531, 532, 533, 534, 537, 539, 540, 237) AND FIND_IN_SET('52', simple_variants) AND FIND_IN_SET('854', 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) 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.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:19
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:426
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