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 pf.parent_id = groups.feature_id LEFT JOIN aa_product_features_values ' at line 1 (1064)
Invalid query: SELECT pf.feature_id, pf.company_id, pf.feature_type, pf.parent_id, pf.display_on_product, pf.display_on_catalog, aa_product_features_descriptions.description, aa_product_features_descriptions.prefix, aa_product_features_descriptions.suffix, pf.categories_path, aa_product_features_descriptions.full_description, pf.status, pf.comparison, pf.position, groups.position AS group_position, aa_product_features_values.value, aa_product_features_values.variant_id, aa_product_features_values.value_int FROM aa_product_features AS pf LEFT JOIN aa_product_features_descriptions ON aa_product_features_descriptions.feature_id = pf.feature_id AND aa_product_features_descriptions.lang_code = 'RU' LEFT JOIN aa_product_features AS groups ON pf.parent_id = groups.feature_id LEFT JOIN aa_product_features_values ON aa_product_features_values.feature_id = pf.feature_id AND aa_product_features_values.product_id = 634 AND aa_product_features_values.lang_code = 'RU' INNER JOIN aa_ult_objects_sharing ON (aa_ult_objects_sharing.share_object_id = pf.feature_id AND aa_ult_objects_sharing.share_company_id = "1" AND aa_ult_objects_sharing.share_object_type = "product_features") WHERE 1 AND IF(pf.feature_type = 'G' OR pf.feature_type = 'C', 1, aa_product_features_values.feature_id) AND pf.status IN ('A') AND pf.display_on_product = 1 AND ( pf.categories_path = '' OR FIND_IN_SET(261, pf.categories_path) OR FIND_IN_SET(293, pf.categories_path) ) ORDER BY group_position, pf.position, aa_product_features_descriptions.description
Backtrace:
| File: | /home/megapolism/domains/givin.com.ua/public_html/core/fn.database.php |
| Line: | 2 |
| Function: | db_error |
| File: | /home/megapolism/domains/givin.com.ua/public_html/core/fn.database.php |
| Line: | 2 |
| Function: | db_query |
| File: | /home/megapolism/domains/givin.com.ua/public_html/core/fn.catalog.php |
| Line: | 2 |
| Function: | db_get_hash_array |
| File: | /home/megapolism/domains/givin.com.ua/public_html/core/fn.catalog.php |
| Line: | 2 |
| Function: | fn_get_product_features |
| File: | /home/megapolism/domains/givin.com.ua/public_html/controllers/customer/products.php |
| Line: | 2 |
| Function: | fn_get_product_data |
| File: | /home/megapolism/domains/givin.com.ua/public_html/core/fn.control.php |
| Line: | 2 |
| Function: | include |
| File: | /home/megapolism/domains/givin.com.ua/public_html/core/fn.control.php |
| Line: | 2 |
| Function: | fn_run_controller |
| File: | /home/megapolism/domains/givin.com.ua/public_html/index.php |
| Line: | 2 |
| Function: | fn_dispatch |