SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.brands' in 'on clause'

#0 /home/greenpicks/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/greenpicks/public_html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home/greenpicks/public_html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /home/greenpicks/public_html/app/code/local/Zend/Db/Adapter/Pdo/Abstract.php(240): Zend_Db_Adapter_Abstract->query('SELECT DISTINCT...', Array)
#4 /home/greenpicks/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query('SELECT DISTINCT...', Array)
#5 /home/greenpicks/public_html/lib/Zend/Db/Adapter/Abstract.php(791): Varien_Db_Adapter_Pdo_Mysql->query('SELECT DISTINCT...', Array)
#6 /home/greenpicks/public_html/app/code/core/Mage/Catalog/Model/Resource/Product/Collection.php(1094): Zend_Db_Adapter_Abstract->fetchCol(Object(Varien_Db_Select))
#7 /home/greenpicks/public_html/app/code/core/Mage/Catalog/Model/Layer.php(290): Mage_Catalog_Model_Resource_Product_Collection->getSetIds()
#8 /home/greenpicks/public_html/app/code/core/Mage/Catalog/Model/Layer.php(220): Mage_Catalog_Model_Layer->_getSetIds()
#9 /home/greenpicks/public_html/app/code/local/Amasty/Shopby/Block/Catalog/Layer/View.php(411): Mage_Catalog_Model_Layer->getFilterableAttributes()
#10 /home/greenpicks/public_html/app/code/core/Mage/Catalog/Block/Layer/View.php(122): Amasty_Shopby_Block_Catalog_Layer_View->_getFilterableAttributes()
#11 /home/greenpicks/public_html/app/code/local/Amasty/Shopby/Block/Catalog/Layer/View.php(574): Mage_Catalog_Block_Layer_View->_prepareLayout()
#12 /home/greenpicks/public_html/app/code/core/Mage/Core/Block/Abstract.php(297): Amasty_Shopby_Block_Catalog_Layer_View->_prepareLayout()
#13 /home/greenpicks/public_html/app/code/core/Mage/Core/Model/Layout.php(456): Mage_Core_Block_Abstract->setLayout(Object(Inchoo_PHP7_Model_Layout))
#14 /home/greenpicks/public_html/app/code/core/Mage/Core/Model/Layout.php(472): Mage_Core_Model_Layout->createBlock('amshopby/catalo...', 'amshopby.navtop')
#15 /home/greenpicks/public_html/app/code/core/Mage/Core/Model/Layout.php(239): Mage_Core_Model_Layout->addBlock('amshopby/catalo...', 'amshopby.navtop')
#16 /home/greenpicks/public_html/app/code/core/Mage/Core/Model/Layout.php(205): Mage_Core_Model_Layout->_generateBlock(Object(Mage_Core_Model_Layout_Element), Object(Mage_Core_Model_Layout_Element))
#17 /home/greenpicks/public_html/app/code/core/Mage/Core/Model/Layout.php(206): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element))
#18 /home/greenpicks/public_html/app/code/core/Mage/Core/Model/Layout.php(210): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element))
#19 /home/greenpicks/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(344): Mage_Core_Model_Layout->generateBlocks()
#20 /home/greenpicks/public_html/app/code/local/Ecommage/Xlandingpage/controllers/Catalog/CategoryController.php(65): Mage_Core_Controller_Varien_Action->generateLayoutBlocks()
#21 /home/greenpicks/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Ecommage_Xlandingpage_Catalog_CategoryController->viewAction()
#22 /home/greenpicks/public_html/app/code/local/Mage/Core/Controller/Varien/Router/Standard.php(255): Mage_Core_Controller_Varien_Action->dispatch('view')
#23 /home/greenpicks/public_html/app/code/local/SM/Vendors/Controller/Router/Vendor.php(177): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#24 /home/greenpicks/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(172): SM_Vendors_Controller_Router_Vendor->match(Object(Mage_Core_Controller_Request_Http))
#25 /home/greenpicks/public_html/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#26 /home/greenpicks/public_html/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#27 /home/greenpicks/public_html/index.php(88): Mage::run('', 'store')
#28 {main}