Error: Error: This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'<br/>Error No: 1235<br/>SELECT p.product_id,p.price,p.minimum,p.stock_status_id,p.rating,p.tax_class_id, `pd`.`name`, `ss`.`name` as stock_status, `p`.`image`, (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 `ign_product_discount` `pd2` WHERE `pd2`.`product_id` = `p`.`product_id` AND `pd2`.`customer_group_id` = '1' AND `pd2`.`quantity` = '1' AND `pd2`.`special` = '0' AND ((`pd2`.`date_start` IS NULL OR `pd2`.`date_start` < NOW()) AND (`pd2`.`date_end` IS NULL 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 `ign_product_discount` `ps` WHERE `ps`.`product_id` = `p`.`product_id` AND `ps`.`customer_group_id` = '1' AND `ps`.`quantity` = '1' AND `ps`.`special` = '1' AND ((`ps`.`date_start` IS NULL OR `ps`.`date_start` < NOW()) AND (`ps`.`date_end` IS NULL OR `ps`.`date_end` > NOW())) ORDER BY `ps`.`priority` ASC, `ps`.`price` ASC LIMIT 1) AS `special` FROM `ign_product` `p` LEFT JOIN `ign_product_description` `pd` ON (`pd`.`product_id` = `p`.`product_id`) LEFT JOIN `ign_stock_status` `ss` ON (`ss`.`stock_status_id` = `p`.`stock_status_id`) WHERE `p`.`manufacturer_id` in (SELECT manufacturer_id from `ign_product` WHERE product_id='24227' LIMIT 1) and p.stock=1 and p.stock_status_id=7 ORDER BY RAND() LIMIT 12
File: /home/kabir4bv/public_html/terrabyt.com/system/library/db/mysqli.php
Line: 122

Backtrace: 0
File: /home/kabir4bv/public_html/terrabyt.com/vqmod/vqcache/vq2-system_library_db.php
Line: 58
Class: Opencart\System\Library\DB\MySQLi
Function: query

Backtrace: 1
File: /home/kabir4bv/public_html/terrabyt.com/vqmod/vqcache/vq2-catalog_model_catalog_product.php
Line: 1110
Class: Opencart\System\Library\DB
Function: query

Backtrace: 2
File: /home/kabir4bv/public_html/terrabyt.com/vqmod/vqcache/vq2-system_engine_loader.php
Line: 343
Class: Opencart\Catalog\Model\Catalog\Product
Function: getRelatedByCategory

Backtrace: 3
File: /home/kabir4bv/public_html/terrabyt.com/system/engine/proxy.php
Line: 87
Class: Opencart\System\Engine\Loader
Function: Opencart\System\Engine\{closure}

Backtrace: 4
File: /home/kabir4bv/public_html/terrabyt.com/catalog/controller/product/related.php
Line: 27
Class: Opencart\System\Engine\Proxy
Function: __call

Backtrace: 5
File: /home/kabir4bv/public_html/terrabyt.com/vqmod/vqcache/vq2-system_engine_loader.php
Line: 112
Class: Opencart\Catalog\Controller\Product\Related
Function: index

Backtrace: 6
File: /home/kabir4bv/public_html/terrabyt.com/vqmod/vqcache/vq2-catalog_controller_product_product.php
Line: 547
Class: Opencart\System\Engine\Loader
Function: controller

Backtrace: 7
File: /home/kabir4bv/public_html/terrabyt.com/system/engine/action.php
Line: 96
Class: Opencart\Catalog\Controller\Product\Product
Function: index

Backtrace: 8
File: /home/kabir4bv/public_html/terrabyt.com/vqmod/vqcache/vq2-system_framework.php
Line: 262
Class: Opencart\System\Engine\Action
Function: execute

Backtrace: 9
File: /home/kabir4bv/public_html/terrabyt.com/index.php
Line: 36
Function: require_once