Warning: Invalid argument supplied for foreach() in /var/www/shop/templates/hb7/source/boxes/search6.php on line 67
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 m.manufacturers_id ORDER BY m.manufacturers_name ASC' at line 1

SELECT m.manufacturers_id AS id, m.manufacturers_name AS text FROM manufacturers m INNER JOIN products p ON (m.manufacturers_id = p.manufacturers_id) INNER JOIN products_to_categories p2c ON (p.products_id = p2c.products_id) INNER JOIN products_attributes pa ON (p.products_id = pa.products_id) INNER JOIN personal_offers_by_customers_status_2 pobcs ON (p.products_id = pobcs.products_id) WHERE p.products_status = 1 AND (p.products_quantity + p.products_ds_quantity) > 0 AND p2c.categories_id IN ('16') AND pa.options_values_id in (7) AND (pa.attributes_stock + pa.attributes_ds_stock) > 0 AND p.products_farbe in (10) AND ( ) GROUP BY m.manufacturers_id ORDER BY m.manufacturers_name ASC

[XT SQL Error]