Fatal error: Uncaught Exception: Error: Unknown column 'p.stockid' in 'on clause'<br />Error No: 1054<br />SELECT COUNT(DISTINCT ps.stockid) AS total FROM product_special ps LEFT JOIN product p ON (ps.stockid = p.stockid) LEFT JOIN product_to_store p2s ON (p.stockid = p2s.stockid) WHERE p.status = '1' AND p.date_available <= DATE(NOW()) AND p2s.store_id = '0' AND ps.customer_group_id = '1' AND ((ps.startdate = '0000-00-00' OR ps.startdate < DATE(NOW())) AND (ps.enddate = '0000-00-00' OR ps.enddate > DATE(NOW()))) in /var/www/b2b/aa-stage/system/library/db/mysqli.php on line 74

Exception: Error: Unknown column 'p.stockid' in 'on clause'<br />Error No: 1054<br />SELECT COUNT(DISTINCT ps.stockid) AS total FROM product_special ps LEFT JOIN product p ON (ps.stockid = p.stockid) LEFT JOIN product_to_store p2s ON (p.stockid = p2s.stockid) WHERE p.status = '1' AND p.date_available <= DATE(NOW()) AND p2s.store_id = '0' AND ps.customer_group_id = '1' AND ((ps.startdate = '0000-00-00' OR ps.startdate < DATE(NOW())) AND (ps.enddate = '0000-00-00' OR ps.enddate > DATE(NOW()))) in /var/www/b2b/aa-stage/system/library/db/mysqli.php on line 74

Call Stack:
    0.0001     364728   1. {main}() /var/www/b2b/aa-stage/index.php:0
    0.0016     388128   2. start() /var/www/b2b/aa-stage/index.php:75
    0.0016     389952   3. require_once('/var/www/b2b/aa-stage/system/framework.php') /var/www/b2b/aa-stage/system/startup.php:120
    0.0052     470136   4. Router->dispatch() /var/www/b2b/aa-stage/system/framework.php:195
    0.0178     571224   5. Router->execute() /var/www/b2b/aa-stage/system/engine/router.php:56
    0.0178     571224   6. Action->execute() /var/www/b2b/aa-stage/system/engine/router.php:67
    0.0178     572200   7. ControllerStartupRouter->index() /var/www/b2b/aa-stage/system/engine/action.php:79
    0.0180     572408   8. Action->execute() /var/www/b2b/aa-stage/catalog/controller/startup/router.php:27
    0.0180     573392   9. ControllerProductSpecial->index() /var/www/b2b/aa-stage/system/engine/action.php:79
    0.0230     652880  10. Proxy->getTotalProductSpecials() /var/www/b2b/aa-stage/catalog/controller/product/special.php:92
    0.0230     652880  11. Proxy->__call() /var/www/b2b/aa-stage/catalog/controller/product/special.php:92
    0.0231     653664  12. Loader->{closure:/var/www/b2b/aa-stage/system/engine/loader.php:220-262}() /var/www/b2b/aa-stage/system/engine/proxy.php:47
    0.0232     654728  13. ModelCatalogProduct->getTotalProductSpecials() /var/www/b2b/aa-stage/system/engine/loader.php:248
    0.0232     655176  14. DB->query() /var/www/b2b/aa-stage/catalog/model/catalog/product.php:1295
    0.0232     655176  15. DB\MySQLi->query() /var/www/b2b/aa-stage/system/library/db.php:37