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 'AND products.product_status='sisteme-22' GROUP BY products.product_id ORDER BY p' at line 11

SELECT products.*, products_stocs.stoc_value, products.product_price_with_tva*(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_with_tva_discount*(categories.procent/100)*(currencies_archive.archive_value/1.0000) as pret, products.product_price_with_discount*(categories.procent/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=31 AND products.active='1' AND products.producer_id= AND products.product_status='sisteme-22' GROUP BY products.product_id ORDER BY products.product_order