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 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 ('1075', '1089', '1110', '1111', '1112', '1122', '1123', '1125', '1127', '1140', '1304', '1306', '1310', '1311', '1327', '1350', '1351') AND ( ) GROUP BY m.manufacturers_id ORDER BY m.manufacturers_name ASC

[XT SQL Error]