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` = '20005' 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` = '20005' AND p.status>0 ORDER BY p.sort_order ASC, LCASE(`pd`.`name`) ASC LIMIT 1920,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