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 'groups ON magicdust_product_features.parent_id = groups.feature_id LEFT JOIN mag' at line 1 (1064)
Invalid query: SELECT magicdust_product_features.feature_id, magicdust_product_features.feature_type, magicdust_product_features.parent_id, magicdust_product_features.display_on_product, magicdust_product_features.display_on_catalog, magicdust_product_features_descriptions.description, magicdust_product_features_descriptions.prefix, magicdust_product_features_descriptions.suffix, magicdust_product_features.categories_path, magicdust_product_features_descriptions.full_description, magicdust_product_features.status, magicdust_product_features.comparison, magicdust_product_features.position, groups.position AS group_position, magicdust_product_features_values.value, magicdust_product_features_values.variant_id, magicdust_product_features_values.value_int FROM magicdust_product_features LEFT JOIN magicdust_product_features_descriptions ON magicdust_product_features_descriptions.feature_id = magicdust_product_features.feature_id AND magicdust_product_features_descriptions.lang_code = 'EN' LEFT JOIN magicdust_product_features AS groups ON magicdust_product_features.parent_id = groups.feature_id LEFT JOIN magicdust_product_features_values ON magicdust_product_features_values.feature_id = magicdust_product_features.feature_id AND magicdust_product_features_values.product_id = 707 AND magicdust_product_features_values.lang_code = 'EN' WHERE 1 AND IF(magicdust_product_features.feature_type = 'G' OR magicdust_product_features.feature_type = 'C', 1, magicdust_product_features_values.feature_id) AND magicdust_product_features.status IN ('A') AND magicdust_product_features.display_on_product = 1 AND ( magicdust_product_features.categories_path = '' OR FIND_IN_SET(93, magicdust_product_features.categories_path) ) ORDER BY group_position, magicdust_product_features.position, magicdust_product_features_descriptions.description

Backtrace:

File:	/home/in2itspo/public_html/core/fn.database.php
Line:	259
Function:	db_error
File:	/home/in2itspo/public_html/core/fn.database.php
Line:	54
Function:	db_query
File:	/home/in2itspo/public_html/core/fn.catalog.php
Line:	1897
Function:	db_get_hash_array
File:	/home/in2itspo/public_html/core/fn.catalog.php
Line:	183
Function:	fn_get_product_features
File:	/home/in2itspo/public_html/controllers/customer/products.php
Line:	62
Function:	fn_get_product_data
File:	/home/in2itspo/public_html/core/fn.control.php
Line:	580
Function:	include
File:	/home/in2itspo/public_html/core/fn.control.php
Line:	434
Function:	fn_run_controller
File:	/home/in2itspo/public_html/index.php
Line:	28
Function:	fn_dispatch