There has been an error processing your request

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'type_id' in where clause is ambiguous, query was: SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_flat_4` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=4 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '313'
 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
 LEFT JOIN `catalog_product_entity` AS `cpe` ON e.entity_id = cpe.entity_id
 INNER JOIN `catalog_product_index_eav` AS `manufacturer_idx` ON manufacturer_idx.entity_id = e.entity_id AND manufacturer_idx.attribute_id = '81' AND manufacturer_idx.store_id = 4 AND manufacturer_idx.value = '77' WHERE (e.status = 1) AND (cpe.type_id = 'virtual') AND (type_id = "downloadable")
Trace: #0 /vhosts/com_jrrshop/httpdocs/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) #1 /vhosts/com_jrrshop/httpdocs/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array) #2 /vhosts/com_jrrshop/httpdocs/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #3 /vhosts/com_jrrshop/httpdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT COUNT(DI...', Array) #4 /vhosts/com_jrrshop/httpdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('SELECT COUNT(DI...', Array) #5 /vhosts/com_jrrshop/httpdocs/lib/Magento/Db/Adapter/Pdo/Mysql.php(176): Varien_Db_Adapter_Pdo_Mysql->query('SELECT COUNT(DI...', Array) #6 /vhosts/com_jrrshop/httpdocs/app/code/core/Zend/Db/Select.php(722): Magento_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select)) #7 /vhosts/com_jrrshop/httpdocs/app/code/local/CM/Layerednavex/Model/Catalog/Layer/Filter/Type.php(178): Zend_Db_Select->query() #8 /vhosts/com_jrrshop/httpdocs/app/code/local/CM/Layerednavex/Model/Catalog/Layer/Filter/Type.php(133): CM_Layerednavex_Model_Catalog_Layer_Filter_Type->_getCount() #9 /vhosts/com_jrrshop/httpdocs/app/code/core/Mage/Catalog/Model/Layer/Filter/Abstract.php(151): CM_Layerednavex_Model_Catalog_Layer_Filter_Type->_getItemsData() #10 /vhosts/com_jrrshop/httpdocs/app/code/core/Mage/Catalog/Model/Layer/Filter/Abstract.php(120): Mage_Catalog_Model_Layer_Filter_Abstract->_initItems() #11 /vhosts/com_jrrshop/httpdocs/app/code/core/Mage/Catalog/Model/Layer/Filter/Abstract.php(109): Mage_Catalog_Model_Layer_Filter_Abstract->getItems() #12 /vhosts/com_jrrshop/httpdocs/app/code/core/Mage/Catalog/Block/Layer/Filter/Abstract.php(132): Mage_Catalog_Model_Layer_Filter_Abstract->getItemsCount() #13 /vhosts/com_jrrshop/httpdocs/app/code/core/Mage/Catalog/Block/Layer/View.php(218): Mage_Catalog_Block_Layer_Filter_Abstract->getItemsCount() #14 /vhosts/com_jrrshop/httpdocs/app/code/core/Mage/Catalog/Block/Layer/View.php(233): Mage_Catalog_Block_Layer_View->canShowOptions() #15 /vhosts/com_jrrshop/httpdocs/app/design/frontend/electronix/jrrshop_electronix/template/catalog/layer/top/view.phtml(34): Mage_Catalog_Block_Layer_View->canShowBlock() #16 /vhosts/com_jrrshop/httpdocs/app/code/core/Mage/Core/Block/Template.php(241): include('/vhosts/com_jrr...') #17 /vhosts/com_jrrshop/httpdocs/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/electr...') #18 /vhosts/com_jrrshop/httpdocs/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView() #19 /vhosts/com_jrrshop/httpdocs/app/code/core/Mage/Core/Block/Abstract.php(924): Mage_Core_Block_Template->_toHtml() #20 /vhosts/com_jrrshop/httpdocs/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml() #21 /vhosts/com_jrrshop/httpdocs/app/code/core/Mage/Core/Block/Abstract.php(924): Mage_Core_Block_Text_List->_toHtml() #22 /vhosts/com_jrrshop/httpdocs/app/code/core/Mage/Core/Block/Abstract.php(641): Mage_Core_Block_Abstract->toHtml() #23 /vhosts/com_jrrshop/httpdocs/app/code/core/Mage/Core/Block/Abstract.php(585): Mage_Core_Block_Abstract->_getChildHtml('content', true) #24 /vhosts/com_jrrshop/httpdocs/app/design/frontend/electronix/default/template/page/2columns-left.phtml(59): Mage_Core_Block_Abstract->getChildHtml('content') #25 /vhosts/com_jrrshop/httpdocs/app/code/core/Mage/Core/Block/Template.php(241): include('/vhosts/com_jrr...') #26 /vhosts/com_jrrshop/httpdocs/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/electr...') #27 /vhosts/com_jrrshop/httpdocs/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView() #28 /vhosts/com_jrrshop/httpdocs/app/code/core/Mage/Core/Block/Abstract.php(924): Mage_Core_Block_Template->_toHtml() #29 /vhosts/com_jrrshop/httpdocs/app/code/community/Inchoo/PHP7/Model/Layout.php(15): Mage_Core_Block_Abstract->toHtml() #30 /vhosts/com_jrrshop/httpdocs/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Inchoo_PHP7_Model_Layout->getOutput() #31 /vhosts/com_jrrshop/httpdocs/app/code/core/Mage/Catalog/controllers/CategoryController.php(161): Mage_Core_Controller_Varien_Action->renderLayout() #32 /vhosts/com_jrrshop/httpdocs/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Catalog_CategoryController->viewAction() #33 /vhosts/com_jrrshop/httpdocs/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('view') #34 /vhosts/com_jrrshop/httpdocs/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http)) #35 /vhosts/com_jrrshop/httpdocs/app/code/core/Mage/Core/Model/App.php(381): Mage_Core_Controller_Varien_Front->dispatch() #36 /vhosts/com_jrrshop/httpdocs/app/Mage.php(687): Mage_Core_Model_App->run(Array) #37 /vhosts/com_jrrshop/httpdocs/index.php(98): Mage::run('jp_jrr', 'store') #38 {main}

Error log record number: 773662315541