Array ( [category_id] => Array ( [product_id] => 450 [category_id] => 73 ) ) Array ( [category_id] => Array ( [product_id] => 450 [category_id] => 348 ) ) Array ( [category_id] => Array ( [product_id] => 450 [category_id] => 350 ) ) Array ( [category_id] => Array ( [product_id] => 450 [category_id] => 73 ) ) Array ( [category_id] => Array ( [product_id] => 450 [category_id] => 348 ) ) Array ( [category_id] => Array ( [product_id] => 450 [category_id] => 350 ) ) Array ( [category_id] => 350 ) Array ( [category_id] => 351 ) Array ( [category_id] => 352 ) Array ( [category_id] => 350 ) Array ( [category_id] => 351 ) Array ( [category_id] => 352 ) Array ( [category_id] => 350 ) Array ( [category_id] => 351 ) Array ( [category_id] => 352 ) Array ( [category_id] => Array ( [product_id] => 450 [category_id] => 73 ) ) Array ( [category_id] => Array ( [product_id] => 450 [category_id] => 348 ) ) Array ( [category_id] => Array ( [product_id] => 450 [category_id] => 350 ) ) Array ( [category_id] => 350 ) Array ( [category_id] => 351 ) Array ( [category_id] => 352 ) Array ( [category_id] => 350 ) Array ( [category_id] => 351 ) Array ( [category_id] => 352 ) Array ( [category_id] => 350 ) Array ( [category_id] => 351 ) Array ( [category_id] => 352 ) Array ( [category_id] => 350 ) Array ( [category_id] => 351 ) Array ( [category_id] => 352 ) Array ( [category_id] => 350 ) Array ( [category_id] => 351 ) Array ( [category_id] => 352 ) Array ( [category_id] => 350 ) Array ( [category_id] => 351 ) Array ( [category_id] => 352 ) Array ( [category_id] => 344 ) Array ( [category_id] => 348 ) Array ( [category_id] => 349 ) Array ( [category_id] => 76 ) Array ( [category_id] => 291 ) Array ( [category_id] => 24 ) Array ( [category_id] => 149 ) Array ( [category_id] => 150 ) Array ( [category_id] => 344 ) Array ( [category_id] => 348 ) Array ( [category_id] => 349 ) Array ( [category_id] => 76 ) Array ( [category_id] => 291 ) Array ( [category_id] => 24 ) Array ( [category_id] => 149 ) Array ( [category_id] => 150 ) Array ( [category_id] => 344 ) Array ( [category_id] => 348 ) Array ( [category_id] => 349 ) Array ( [category_id] => 76 ) Array ( [category_id] => 291 ) Array ( [category_id] => 24 ) Array ( [category_id] => 149 ) Array ( [category_id] => 150 ) Error: Error: Unknown column 'Array' in 'WHERE'
Error No: 1054
SELECT DISTINCT *, `pd`.`name`, `p`.`image`, (SELECT (CASE WHEN `pd2`.`type` = 'P' THEN (`pd2`.`price` * (`p`.`price` / 100)) WHEN `pd2`.`type` = 'S' THEN (`p`.`price` - `pd2`.`price`) ELSE `pd2`.`price` END) FROM `oc_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` = '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 (`ps`.`price` * (`p`.`price` / 100)) WHEN `ps`.`type` = 'S' THEN (`p`.`price` - `ps`.`price`) ELSE `ps`.`price` END) FROM `oc_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` = '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`, (SELECT `pr`.`points` FROM `oc_product_reward` `pr` WHERE `pr`.`product_id` = `p`.`product_id` AND `pr`.`customer_group_id` = '1') AS `reward`, (SELECT COUNT(*) FROM `oc_review` `r` WHERE `r`.`product_id` = `p`.`product_id` AND `r`.`status` = '1' GROUP BY `r`.`product_id`) AS `reviews` FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_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 p2c.category_id IN (Array,350,351,352,344,348,349,76,291,24,149,150,73,74,75,85,333,152,153,154,156,157,159,166,167,168,169) GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,20 File: /home/plushstore/web/theplushstore.com/public_html/system/library/db/mysqli.php Line: 122 Backtrace: 0 File: /home/plushstore/web/theplushstore.com/public_html/system/library/db.php Line: 54 Class: Opencart\System\Library\DB\MySQLi Function: query Backtrace: 1 File: /home/plushstore/web/theplushstore.com/public_html/extension/so_xtore/catalog/model/module/so_extra_slider.php Line: 153 Class: Opencart\System\Library\DB Function: query Backtrace: 2 File: /home/plushstore/web/theplushstore.com/public_html/system/engine/loader.php Line: 343 Class: Opencart\Catalog\Model\Extension\SoXtore\Module\SoExtraSlider Function: getProducts_extra_slider Backtrace: 3 File: /home/plushstore/web/theplushstore.com/public_html/system/engine/proxy.php Line: 87 Class: Opencart\System\Engine\Loader Function: Opencart\System\Engine\{closure} Backtrace: 4 File: /home/plushstore/web/theplushstore.com/public_html/extension/so_xtore/catalog/controller/module/so_extra_slider.php Line: 245 Class: Opencart\System\Engine\Proxy Function: __call Backtrace: 5 File: /home/plushstore/web/theplushstore.com/public_html/extension/so_xtore/catalog/controller/module/so_extra_slider.php Line: 68 Class: Opencart\Catalog\Controller\Extension\SoXtore\Module\SoExtraSlider Function: readData Backtrace: 6 File: /home/plushstore/web/theplushstore.com/public_html/system/engine/loader.php Line: 112 Class: Opencart\Catalog\Controller\Extension\SoXtore\Module\SoExtraSlider Function: index Backtrace: 7 File: /home/plushstore/web/theplushstore.com/public_html/catalog/controller/common/content_bottom.php Line: 101 Class: Opencart\System\Engine\Loader Function: controller Backtrace: 8 File: /home/plushstore/web/theplushstore.com/public_html/system/engine/loader.php Line: 112 Class: Opencart\Catalog\Controller\Common\ContentBottom Function: index Backtrace: 9 File: /home/plushstore/web/theplushstore.com/public_html/catalog/controller/product/product.php Line: 586 Class: Opencart\System\Engine\Loader Function: controller Backtrace: 10 File: /home/plushstore/web/theplushstore.com/public_html/system/engine/action.php Line: 96 Class: Opencart\Catalog\Controller\Product\Product Function: index Backtrace: 11 File: /home/plushstore/web/theplushstore.com/public_html/system/framework.php Line: 259 Class: Opencart\System\Engine\Action Function: execute Backtrace: 12 File: /home/plushstore/web/theplushstore.com/public_html/index.php Line: 20 Function: require_once