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 cscart_product_features.parent_id = groups.feature_id LEFT JOIN cscart' at line 1 (1064)
Invalid query: SELECT cscart_product_features.feature_id, cscart_product_features.feature_type, cscart_product_features.parent_id, cscart_product_features.display_on_product, cscart_product_features.display_on_catalog, cscart_product_features_descriptions.description, cscart_product_features_descriptions.prefix, cscart_product_features_descriptions.suffix, cscart_product_features.categories_path, cscart_product_features_descriptions.full_description, cscart_product_features.status, cscart_product_features.comparison, cscart_product_features.position, groups.position AS group_position, cscart_product_features_values.value, cscart_product_features_values.variant_id, cscart_product_features_values.value_int FROM cscart_product_features  LEFT JOIN cscart_product_features_descriptions ON cscart_product_features_descriptions.feature_id = cscart_product_features.feature_id AND cscart_product_features_descriptions.lang_code = 'EL' LEFT JOIN cscart_product_features AS groups ON cscart_product_features.parent_id = groups.feature_id LEFT JOIN cscart_product_features_values ON cscart_product_features_values.feature_id = cscart_product_features.feature_id  AND cscart_product_features_values.product_id = 29806 AND cscart_product_features_values.lang_code = 'EL' WHERE 1  AND IF(cscart_product_features.feature_type = 'G' OR cscart_product_features.feature_type = 'C', 1, cscart_product_features_values.feature_id) AND cscart_product_features.status IN ('A') AND cscart_product_features.display_on_product = 1 AND ( cscart_product_features.categories_path = '' OR FIND_IN_SET(85, cscart_product_features.categories_path) OR FIND_IN_SET(166, cscart_product_features.categories_path) )  ORDER BY group_position, cscart_product_features.position, cscart_product_features_descriptions.description 
Backtrace:
| File: | /home/meden/public_html/core/fn.database.php | 
| Line: | 259 | 
| Function: | db_error | 
| File: | /home/meden/public_html/core/fn.database.php | 
| Line: | 54 | 
| Function: | db_query | 
| File: | /home/meden/public_html/core/fn.catalog.php | 
| Line: | 1897 | 
| Function: | db_get_hash_array | 
| File: | /home/meden/public_html/core/fn.catalog.php | 
| Line: | 183 | 
| Function: | fn_get_product_features | 
| File: | /home/meden/public_html/controllers/customer/products.php | 
| Line: | 62 | 
| Function: | fn_get_product_data | 
| File: | /home/meden/public_html/core/fn.control.php | 
| Line: | 580 | 
| Function: | include | 
| File: | /home/meden/public_html/core/fn.control.php | 
| Line: | 434 | 
| Function: | fn_run_controller | 
| File: | /home/meden/public_html/index.php | 
| Line: | 28 | 
| Function: | fn_dispatch |