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 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) LEFT JOIN specials s ON (p.products_id = s.products_id AND s.status=1 AND (s.expires_date >='2013-06-19T19:24:47+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 ('88', '2', '89', '92') AND pa.options_values_id in (9) AND (pa.attributes_stock + pa.attributes_ds_stock) > 0 AND ( ) GROUP BY m.manufacturers_id ORDER BY m.manufacturers_name ASC

[XT SQL Error]