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 ('200', '6', '3', '4', '19', '54', '55', '56', '60', '108', '154', '9', '10', '11', '12', '13', '14', '15', '16', '25', '26', '27', '28', '46', '52', '91', '100', '17', '47', '48', '49', '51', '64', '102', '103', '106', '149', '3327', '22', '21', '29', '30', '31', '32', '33', '34', '67', '68', '105', '3333', '3334', '3335', '3337', '3338', '3342', '3347', '3432', '23', '5', '20', '53', '57', '58', '3047', '3050', '3109', '3239', '3303', '3155', '3249', '59', '61', '66', '69', '70', '71', '72', '73', '74', '75', '76', '77', '78', '80', '98', '104', '109', '148', '155', '3326', '3344', '35', '7', '8', '36', '37', '38', '39', '40', '41', '18', '42', '43', '44', '45', '62', '63', '90', '94', '97', '99', '101', '3348', '3385', '88', '2', '89', '92', '3343', '3386', '3387', '3388', '3389', '3390', '3391', '3392', '3393', '3394', '3395', '3396', '3397', '3427', '3428', '3431') AND pa.options_values_id in (8) AND (pa.attributes_stock + pa.attributes_ds_stock) > 0 AND ( ) GROUP BY m.manufacturers_id ORDER BY m.manufacturers_name ASC

[XT SQL Error]