Error: 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 '2' AND `p`.`manufacturer_id` = '20048' AND p.status>0 ORDER BY p.sort_order A...' at line 1
Error No: 1064
SELECT DISTINCT p.*, `pd`.`name`,`pd`.`description` FROM `cm_product_to_store` `p2s` LEFT JOIN `cm_product` `p` ON (`p`.`product_id` = `p2s`.`product_id` AND `p`.`status` = '1' AND `p2s`.`store_id` = '0 LEFT JOIN `cm_product_description` `pd` ON (`p`.`product_id` = `pd`.`product_id`) WHERE `pd`.`language_id` = '2' AND `p`.`manufacturer_id` = '20048' AND p.status>0 ORDER BY p.sort_order ASC, LCASE(`pd`.`name`) ASC LIMIT 2208,48 File: /home/partz/public_html/cm/system/library/db/mysqli.php Line: 122 Backtrace: 0 File: /home/partz/public_html/cm/system/library/db.php Line: 54 Class: Opencart\System\Library\DB\MySQLi Function: query Backtrace: 1 File: /home/partz/public_html/catalog/model/catalog/product.php Line: 483 Class: Opencart\System\Library\DB Function: query Backtrace: 2 File: /home/partz/public_html/cm/system/engine/loader.php Line: 346 Class: Opencart\Catalog\Model\Catalog\Product Function: getProducts Backtrace: 3 File: /home/partz/public_html/cm/system/engine/proxy.php Line: 87 Class: Opencart\System\Engine\Loader Function: Opencart\System\Engine\{closure} Backtrace: 4 File: /home/partz/public_html/catalog/controller/product/manufacturer.php Line: 188 Class: Opencart\System\Engine\Proxy Function: __call Backtrace: 5 File: /home/partz/public_html/cm/system/engine/action.php Line: 96 Class: Opencart\Catalog\Controller\Product\Manufacturer Function: info Backtrace: 6 File: /home/partz/public_html/cm/system/framework.php Line: 259 Class: Opencart\System\Engine\Action Function: execute Backtrace: 7 File: /home/partz/public_html/cm/index.php Line: 21 Function: require_once