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 'LEFT JOIN `oc_product_description` `pd` ON (`p`.`product_id` = `pd`.`product_...' at line 1
Error No: 1064
SELECT COUNT(DISTINCT `p`.`product_id`) AS total FROM `oc_product` `p` WHERE `p`.`status` = '1' AND `p`.`date_available` <= NOW() LEFT JOIN `oc_product_description` `pd` ON (`p`.`product_id` = `pd`.`product_id`) WHERE p.`tenant_id`= '16893610022683029504' AND `pd`.`language_id` = '2' AND `p`.`manufacturer_id` = '9' AND p.type != 'v' AND p.list = '1' : in /home/admin/domains/shopanel.com.br/public_html/system/library/db/mysqli.php on line 76