Error: Error: syntax error, unexpected $end<br/>Error No: 1064<br/>SELECT p.product_id, (SELECT AVG(rating) AS total FROM qy9a_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT (CASE WHEN `pd2`.`type` = 'P' THEN (`p`.`price` - (`p`.`price` * (`pd2`.`price` / 100))) WHEN `pd2`.`type` = 'S' THEN (`p`.`price` - `pd2`.`price`) ELSE `pd2`.`price` END) FROM `qy9a_product_discount` `pd2` WHERE `pd2`.`product_id` = `p`.`product_id` AND `pd2`.`customer_group_id` = '5' AND `pd2`.`quantity` = '1' AND `pd2`.`special` = '0' AND ((`pd2`.`date_start` = '0000-00-00' OR `pd2`.`date_start` < NOW()) AND (`pd2`.`date_end` = '0000-00-00' OR `pd2`.`date_end` > NOW())) ORDER BY `pd2`.`priority` ASC, `pd2`.`price` ASC LIMIT 1) AS `discount`, (SELECT (CASE WHEN `ps`.`type` = 'P' THEN (`p`.`price` - (`p`.`price` * (`ps`.`price` / 100))) WHEN `ps`.`type` = 'S' THEN (`p`.`price` - `ps`.`price`) ELSE `ps`.`price` END) FROM `qy9a_product_discount` `ps` WHERE `ps`.`product_id` = `p`.`product_id` AND `ps`.`customer_group_id` = '5' AND `ps`.`quantity` = '1' AND `ps`.`special` = '1' AND ((`ps`.`date_start` = '0000-00-00' OR `ps`.`date_start` < NOW()) AND (`ps`.`date_end` = '0000-00-00' OR `ps`.`date_end` > NOW())) ORDER BY `ps`.`priority` ASC, `ps`.`price` ASC LIMIT 1) AS `special` FROM qy9a_product p LEFT JOIN qy9a_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN qy9a_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.product_id != '739951' AND MATCH(pd.tag) AGAINST('+TXC-PC-02-' IN BOOLEAN MODE) AND pd.tag != '' GROUP BY p.product_id ORDER BY p.quantity DESC LIMIT 0,20
File: /home/default/htdocs/shoptest.local/system/library/db/mysqli.php
Line: 122

Backtrace: 0
File: /home/default/htdocs/shoptest.local/system/library/db.php
Line: 54
Class: Opencart\System\Library\DB\MySQLi
Function: query

Backtrace: 1
File: /home/default/htdocs/shoptest.local/extension/meproductvariants/catalog/model/me_product_variant.php
Line: 297
Class: Opencart\System\Library\DB
Function: query

Backtrace: 2
File: /home/default/htdocs/shoptest.local/vqmod/vqcache/vq2-system_engine_loader.php
Line: 586
Class: Opencart\Catalog\Model\Extension\Meproductvariants\Meproductvariant
Function: getProducts

Backtrace: 3
File: /home/default/htdocs/shoptest.local/system/engine/proxy.php
Line: 87
Class: Opencart\System\Engine\Loader
Function: Opencart\System\Engine\{closure}

Backtrace: 4
File: /home/default/htdocs/shoptest.local/extension/meproductvariants/catalog/controller/module/me_product_variant.php
Line: 176
Class: Opencart\System\Engine\Proxy
Function: __call

Backtrace: 5
File: /home/default/htdocs/shoptest.local/vqmod/vqcache/vq2-system_engine_action.php
Line: 263
Class: Opencart\Catalog\Controller\Extension\Meproductvariants\Module\Meproductvariant
Function: index

Backtrace: 6
File: /home/default/htdocs/shoptest.local/vqmod/vqcache/vq2-system_engine_loader.php
Line: 209
Class: Opencart\System\Engine\Action
Function: execute

Backtrace: 7
File: /home/default/htdocs/shoptest.local/extension/meproductvariants/catalog/controller/module/me_product_variant.php
Line: 1005
Class: Opencart\System\Engine\Loader
Function: controller

Backtrace: 8
File: /home/default/htdocs/shoptest.local/vqmod/vqcache/vq2-system_engine_action.php
Line: 263
Class: Opencart\Catalog\Controller\Extension\Meproductvariants\Module\Meproductvariant
Function: eventviewProductVariant2

Backtrace: 9
File: /home/default/htdocs/shoptest.local/system/engine/event.php
Line: 72
Class: Opencart\System\Engine\Action
Function: execute

Backtrace: 10
File: /home/default/htdocs/shoptest.local/vqmod/vqcache/vq2-system_engine_loader.php
Line: 426
Class: Opencart\System\Engine\Event
Function: trigger

Backtrace: 11
File: /home/default/htdocs/shoptest.local/vqmod/vqcache/vq2-extension_ocmod_catalog_controller_product_product.php
Line: 587
Class: Opencart\System\Engine\Loader
Function: view

Backtrace: 12
File: /home/default/htdocs/shoptest.local/vqmod/vqcache/vq2-system_engine_action.php
Line: 263
Class: Opencart\Catalog\Controller\Product\Product
Function: index

Backtrace: 13
File: /home/default/htdocs/shoptest.local/system/framework.php
Line: 259
Class: Opencart\System\Engine\Action
Function: execute

Backtrace: 14
File: /home/default/htdocs/shoptest.local/index.php
Line: 24
Function: require_once