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 CEIL(MAX...', Array)
#4 /home/greenpicks/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query('SELECT CEIL(MAX...', Array)
#5 /home/greenpicks/public_html/lib/Zend/Db/Adapter/Abstract.php(773): Varien_Db_Adapter_Pdo_Mysql->query('SELECT CEIL(MAX...', Array)
#6 /home/greenpicks/public_html/app/code/local/Amasty/Shopby/Model/Mysql4/Price17.php(93): Zend_Db_Adapter_Abstract->fetchAssoc(Object(Varien_Db_Select))
#7 /home/greenpicks/public_html/app/code/local/Amasty/Shopby/Model/Mysql4/Price17.php(128): Amasty_Shopby_Model_Mysql4_Price17->_getMaxMinPrice(Object(Amasty_Shopby_Model_Catalog_Layer_Filter_Price))
#8 /home/greenpicks/public_html/app/code/local/Amasty/Shopby/Model/Catalog/Layer/Filter/Price/Price17ce.php(111): Amasty_Shopby_Model_Mysql4_Price17->getMinPrice(Object(Amasty_Shopby_Model_Catalog_Layer_Filter_Price))
#9 /home/greenpicks/public_html/app/design/frontend/clean/greenpicks/template/catalog/layer/view.phtml(16): Amasty_Shopby_Model_Catalog_Layer_Filter_Price_Price17ce->getMinValue()
#10 /home/greenpicks/public_html/app/code/core/Mage/Core/Block/Template.php(241): include('/home/greenpick...')
#11 /home/greenpicks/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/clean/...')
#12 /home/greenpicks/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#13 /home/greenpicks/public_html/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Template->_toHtml()
#14 /home/greenpicks/public_html/app/code/core/Mage/Core/Block/Abstract.php(641): Mage_Core_Block_Abstract->toHtml()
#15 /home/greenpicks/public_html/app/code/core/Mage/Core/Block/Abstract.php(585): Mage_Core_Block_Abstract->_getChildHtml('amshopby.navlef...', true)
#16 /home/greenpicks/public_html/app/design/frontend/clean/greenpicks/template/sm/vendors/detail/tabs/all-products.phtml(20): Mage_Core_Block_Abstract->getChildHtml('amshopby.navlef...')
#17 /home/greenpicks/public_html/app/code/core/Mage/Core/Block/Template.php(241): include('/home/greenpick...')
#18 /home/greenpicks/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/clean/...')
#19 /home/greenpicks/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#20 /home/greenpicks/public_html/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Template->_toHtml()
#21 /home/greenpicks/public_html/app/code/core/Mage/Core/Block/Abstract.php(641): Mage_Core_Block_Abstract->toHtml()
#22 /home/greenpicks/public_html/app/code/core/Mage/Core/Block/Abstract.php(585): Mage_Core_Block_Abstract->_getChildHtml('all_products_ta...', true)
#23 /home/greenpicks/public_html/app/design/frontend/clean/greenpicks/template/sm/vendors/detail/vendor.phtml(12): Mage_Core_Block_Abstract->getChildHtml('all_products_ta...')
#24 /home/greenpicks/public_html/app/code/local/Ecommage/Rewritecontactdefault/Block/Template.php(192): include('/home/greenpick...')
#25 /home/greenpicks/public_html/app/code/local/Ecommage/Rewritecontactdefault/Block/Template.php(223): Ecommage_Rewritecontactdefault_Block_Template->fetchView('frontend/clean/...')
#26 /home/greenpicks/public_html/app/code/local/Ecommage/Rewritecontactdefault/Block/Template.php(237): Ecommage_Rewritecontactdefault_Block_Template->renderView()
#27 /home/greenpicks/public_html/app/code/core/Mage/Core/Block/Abstract.php(923): Ecommage_Rewritecontactdefault_Block_Template->_toHtml()
#28 /home/greenpicks/public_html/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
#29 /home/greenpicks/public_html/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Text_List->_toHtml()
#30 /home/greenpicks/public_html/app/code/core/Mage/Core/Block/Abstract.php(641): Mage_Core_Block_Abstract->toHtml()
#31 /home/greenpicks/public_html/app/code/core/Mage/Core/Block/Abstract.php(585): Mage_Core_Block_Abstract->_getChildHtml('content', true)
#32 /home/greenpicks/public_html/app/design/frontend/clean/greenpicks/template/page/1column.phtml(84): Mage_Core_Block_Abstract->getChildHtml('content')
#33 /home/greenpicks/public_html/app/code/core/Mage/Core/Block/Template.php(241): include('/home/greenpick...')
#34 /home/greenpicks/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/clean/...')
#35 /home/greenpicks/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#36 /home/greenpicks/public_html/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Template->_toHtml()
#37 /home/greenpicks/public_html/app/code/local/Inchoo/PHP7/Model/Layout.php(15): Mage_Core_Block_Abstract->toHtml()
#38 /home/greenpicks/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Inchoo_PHP7_Model_Layout->getOutput()
#39 /home/greenpicks/public_html/app/code/local/SM/Vendors/controllers/IndexController.php(55): Mage_Core_Controller_Varien_Action->renderLayout()
#40 /home/greenpicks/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): SM_Vendors_IndexController->indexAction()
#41 /home/greenpicks/public_html/app/code/local/SM/Vendors/Controller/Router/Vendor.php(171): Mage_Core_Controller_Varien_Action->dispatch('index')
#42 /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))
#43 /home/greenpicks/public_html/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#44 /home/greenpicks/public_html/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#45 /home/greenpicks/public_html/index.php(88): Mage::run('', 'store')
#46 {main}