A Database Error Occurred
Error Number: 1064
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 'GROUP BY products.product_id ORDER BY products.product_order' at line 15
SELECT products.*, products_stocs.stoc_value, products.product_price*(1+products.product_tva/100)*(categories.procent/100)*(currencies_archive.archive_value/1.0000) as pret_no_discount, products.product_price*(categories.procent/100)*(currencies_archive.archive_value/1.0000) as pret_no_discount_no_tva, products.product_price*(1+products.product_tva/100)*(categories.procent/100)*(1-products.product_discount/100)*(currencies_archive.archive_value/1.0000) as pret, products.product_price*(categories.procent/100)*(1-products.product_discount/100)*(currencies_archive.archive_value/1.0000) as pret_no_tva, products.product_taxa_verde*(currencies_archive.archive_value/1.0000) as taxa_verde, currencies_archive.archive_value/1.0000 as raport, products_details.*, categories_details.url_key as category_url_key, categories_details.category_title, categories.*, categories_details2.url_key as parent_url_key, currencies.currency_code FROM (`products`) JOIN `products_details` ON products.product_id=products_details.product_id JOIN `products_stocs` ON products.product_id=products_stocs.product_id JOIN `categories` ON products.category_id=categories.category_id JOIN `categories_details` ON categories.category_id=categories_details.category_id JOIN `currencies` ON products.currency_id=currencies.currency_id JOIN `categories_details` as categories_details2 ON categories.parent_id=categories_details2.category_id JOIN `currencies_archive` ON (currencies_archive.currency_id=currencies.currency_id AND currencies_archive.archive_date="2009-04-30") LEFT JOIN `products_tags` ON products.product_id=products_tags.product_id LEFT JOIN `tags` ON products_tags.tag_id=tags.tag_id WHERE products_details.language_id = '1' AND categories_details.language_id = '1' AND (products.category_id = '9' OR products.category_id like '9,%' OR FIND_IN_SET(9, products.category_id)) AND products.active='1' AND products.producer_id= GROUP BY products.product_id ORDER BY products.product_order