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<>934 AND p2c.category_id IN (63)
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