Notice: 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 '\" . DB_PREFIX . \"product_image pi2 WHERE pi2.product_id = p.product_id) > 0) O' at line 1
Error No: 1064
SELECT DISTINCT m.manufacturer_id, m.name, m.image FROM oc_manufacturer m WHERE (SELECT COUNT(p.product_id) FROM oc_product p WHERE p.manufacturer_id = m.manufacturer_id AND p.status = 1 AND p.deleted = 0 AND p.date_available <= NOW() AND (p.date_available_to = p.date_available OR p.date_available_to > NOW() - INTERVAL 1 DAY) AND (SELECT COUNT(pi2.product_image_id) FROM \" . DB_PREFIX . \"product_image pi2 WHERE pi2.product_id = p.product_id) > 0) ORDER BY m.name ASC; in /home/morrismica/public_html/shop/system/database/mysql.php on line 44