Notice: Undefined variable: acat in /home/sites/susannahnicholas.co.uk/public_html/catalog/controller/module/autoadvattrsearch.php on line 40Notice: Undefined variable: acat in /home/sites/susannahnicholas.co.uk/public_html/catalog/controller/module/autoadvattrsearch.php on line 96Notice: Undefined variable: acat in /home/sites/susannahnicholas.co.uk/public_html/catalog/controller/module/autoadvattrsearch.php on line 97Notice: Undefined variable: acat in /home/sites/susannahnicholas.co.uk/public_html/catalog/controller/module/autoadvattrsearch.php on line 99Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') GROUP BY m.manufacturer_id ORDER BY name' at line 5
Error No: 1064
SELECT * FROM oc_manufacturer m LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) LEFT JOIN oc_product p ON (m.manufacturer_id = p.manufacturer_id) LEFT JOIN oc_product_to_category p2c ON (p2c.product_id = p.product_id) WHERE m2s.store_id = '0' AND p2c.category_id IN () GROUP BY m.manufacturer_id ORDER BY name in /home/sites/susannahnicholas.co.uk/public_html/system/database/mysql.php on line 50