Notice: Undefined variable: acat in /home/sbb23088/public_html/xgroup.rs/catalog/controller/module/autoadvattrsearch.php on line 40Notice: Undefined variable: acat in /home/sbb23088/public_html/xgroup.rs/catalog/controller/module/autoadvattrsearch.php on line 40Notice: Undefined variable: acat in /home/sbb23088/public_html/xgroup.rs/catalog/controller/module/autoadvattrsearch.php on line 40Notice: Undefined variable: acat in /home/sbb23088/public_html/xgroup.rs/catalog/controller/module/autoadvattrsearch.php on line 40Notice: Undefined variable: acat in /home/sbb23088/public_html/xgroup.rs/catalog/controller/module/autoadvattrsearch.php on line 40Notice: Undefined variable: acat in /home/sbb23088/public_html/xgroup.rs/catalog/controller/module/autoadvattrsearch.php on line 40Notice: Undefined variable: acat in /home/sbb23088/public_html/xgroup.rs/catalog/controller/module/autoadvattrsearch.php on line 40Notice: Undefined variable: acat in /home/sbb23088/public_html/xgroup.rs/catalog/controller/module/autoadvattrsearch.php on line 40Notice: Undefined variable: acat in /home/sbb23088/public_html/xgroup.rs/catalog/controller/module/autoadvattrsearch.php on line 40Notice: Undefined variable: acat in /home/sbb23088/public_html/xgroup.rs/catalog/controller/module/autoadvattrsearch.php on line 40Notice: Undefined variable: acat in /home/sbb23088/public_html/xgroup.rs/catalog/controller/module/autoadvattrsearch.php on line 40Notice: Undefined variable: acat in /home/sbb23088/public_html/xgroup.rs/catalog/controller/module/autoadvattrsearch.php on line 40Notice: Undefined variable: acat in /home/sbb23088/public_html/xgroup.rs/catalog/controller/module/autoadvattrsearch.php on line 40Notice: Undefined variable: acat in /home/sbb23088/public_html/xgroup.rs/catalog/controller/module/autoadvattrsearch.php on line 40Notice: Undefined variable: acat in /home/sbb23088/public_html/xgroup.rs/catalog/controller/module/autoadvattrsearch.php on line 40Notice: Undefined variable: acat in /home/sbb23088/public_html/xgroup.rs/catalog/controller/module/autoadvattrsearch.php on line 40Notice: Undefined variable: acat in /home/sbb23088/public_html/xgroup.rs/catalog/controller/module/autoadvattrsearch.php on line 40Notice: Undefined variable: acat in /home/sbb23088/public_html/xgroup.rs/catalog/controller/module/autoadvattrsearch.php on line 96Notice: Undefined variable: acat in /home/sbb23088/public_html/xgroup.rs/catalog/controller/module/autoadvattrsearch.php on line 97Notice: Undefined variable: acat in /home/sbb23088/public_html/xgroup.rs/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 *, count(p.product_id) as count FROM ocb_manufacturer m LEFT JOIN ocb_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) LEFT JOIN ocb_product p ON (m.manufacturer_id = p.manufacturer_id) LEFT JOIN ocb_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/sbb23088/public_html/xgroup.rs/system/database/mysqliz.php on line 53