Error: Error: Unknown column 'p.viewed' in 'order clause'
Error No: 1054
SELECT DISTINCT p.product_id FROM `oc_product` p INNER JOIN `oc_product_to_category` p2c ON (p.product_id=p2c.product_id) INNER JOIN `oc_product_to_store` p2s ON (p.product_id=p2s.product_id AND p2s.store_id=0) WHERE p.status=1 AND p.date_available <= NOW() AND p.quantity>0 AND p.product_id<>3423 AND p2c.category_id IN (78,102,103,104) ORDER BY p.quantity DESC, p.viewed DESC, p.product_id DESC LIMIT 8 File: /var/www/h165377/data/www/new.bobrik.by/system/library/db/mysqli.php Line: 122 Backtrace: 0 File: /var/www/h165377/data/www/new.bobrik.by/system/library/db.php Line: 54 Class: Opencart\System\Library\DB\MySQLi Function: query Backtrace: 1 File: /var/www/h165377/data/www/new.bobrik.by/extension/bobrikby/catalog/controller/module/recommend.php Line: 77 Class: Opencart\System\Library\DB Function: query Backtrace: 2 File: /var/www/h165377/data/www/new.bobrik.by/extension/bobrikby/catalog/controller/module/recommend.php Line: 16 Class: Opencart\Catalog\Controller\Extension\Bobrikby\Module\Recommend Function: pickIds Backtrace: 3 File: /var/www/h165377/data/www/new.bobrik.by/system/engine/loader.php Line: 112 Class: Opencart\Catalog\Controller\Extension\Bobrikby\Module\Recommend Function: index Backtrace: 4 File: /var/www/h165377/data/www/new.bobrik.by/extension/bobrikby/catalog/controller/event/product_page.php Line: 82 Class: Opencart\System\Engine\Loader Function: controller Backtrace: 5 File: /var/www/h165377/data/www/new.bobrik.by/system/engine/action.php Line: 96 Class: Opencart\Catalog\Controller\Extension\Bobrikby\Event\ProductPage Function: index Backtrace: 6 File: /var/www/h165377/data/www/new.bobrik.by/system/engine/event.php Line: 72 Class: Opencart\System\Engine\Action Function: execute Backtrace: 7 File: /var/www/h165377/data/www/new.bobrik.by/system/engine/loader.php Line: 183 Class: Opencart\System\Engine\Event Function: trigger Backtrace: 8 File: /var/www/h165377/data/www/new.bobrik.by/catalog/controller/product/product.php Line: 455 Class: Opencart\System\Engine\Loader Function: view Backtrace: 9 File: /var/www/h165377/data/www/new.bobrik.by/system/engine/action.php Line: 96 Class: Opencart\Catalog\Controller\Product\Product Function: index Backtrace: 10 File: /var/www/h165377/data/www/new.bobrik.by/system/framework.php Line: 272 Class: Opencart\System\Engine\Action Function: execute Backtrace: 11 File: /var/www/h165377/data/www/new.bobrik.by/index.php Line: 20 Function: require_once