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 2

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 categories c ON (p2c.categories_id = c.categories_id) INNER JOIN personal_offers_by_customers_status_2 pobcs ON (p.products_id = pobcs.products_id) LEFT JOIN specials s ON (p.products_id = s.products_id AND s.status=1 AND (s.expires_date >='2014-04-24T03:15:52+02:00' OR expires_date IS NULL)) WHERE p.products_status = 1 AND (p.products_quantity + p.products_ds_quantity) > 0 AND p2c.categories_id IN ('1280') AND c.categories_status = 1 AND ( ) GROUP BY m.manufacturers_id ORDER BY m.manufacturers_name ASC

[XT SQL Error]