A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GROUP BY products.product_id ORDER BY products.product_order' at line 12

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_price1*(categories.procent/100)*(currencies_archive.archive_value/1.0000) as pret_no_discount1, 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_price1*(categories.procent/100)*(1-products.product_discount/100)*(currencies_archive.archive_value/1.0000) as pret1, 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.category_title, categories_details.url_key as category_url_key, categories.reseler_discount, categories.category_type, 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 `currencies_archive` ON (currencies_archive.currency_id=currencies.currency_id AND currencies_archive.archive_date="2009-11-05") WHERE products_details.language_id = '1' AND categories_details.language_id = '1' AND (products.category_id='120') AND products.active='1' AND products.producer_id= GROUP BY products.product_id ORDER BY products.product_order