You cannot define a correlation name 'gender_ring_idx' more than once The code is appearing while i have added the attributes in backend and while clicking on the attribute on front end it's shows an error Trace: #0 /home1/sevabhav/public_html/adamore/lib/Varien/Db/Select.php(281): Zend_Db_Select->_join('inner join', Array, 'gender_ring_idx...', Array, NULL) #1 /home1/sevabhav/public_html/adamore/lib/Zend/Db/Select.php(336): Varien_Db_Select->_join('inner join', Array, 'gender_ring_idx...', Array, NULL) #2 /home1/sevabhav/public_html/adamore/lib/Zend/Db/Select.php(315): Zend_Db_Select->joinInner(Array, 'gender_ring_idx...', Array, NULL) #3 /home1/sevabhav/public_html/adamore/app/code/core/Mage/Catalog/Model/Resource/Layer/Filter/Attribute.php(70): Zend_Db_Select->join(Array, 'gender_ring_idx...', Array) #4 /home1/sevabhav/public_html/adamore/app/code/core/Mage/Catalog/Model/Layer/Filter/Attribute.php(94): Mage_Catalog_Model_Resource_Layer_Filter_Attribute->applyFilterToCollection(Object(Mage_Catalog_Model_Layer_Filter_Attribute), '14') #5 /home1/sevabhav/public_html/adamore/app/code/core/Mage/Catalog/Block/Layer/Filter/Abstract.php(91): Mage_Catalog_Model_Layer_Filter_Attribute->apply(Object(Mage_Core_Controller_Request_Http), Object(Mage_Catalog_Block_Layer_Filter_Attribute)) #6 /home1/sevabhav/public_html/adamore/app/code/core/Mage/Catalog/Block/Layer/Filter/Abstract.php(73): Mage_Catalog_Block_Layer_Filter_Abstract->_initFilter() #7 /home1/sevabhav/public_html/adamore/app/code/core/Mage/Catalog/Block/Layer/View.php(136): Mage_Catalog_Block_Layer_Filter_Abstract->init() #8 /home1/sevabhav/public_html/adamore/app/code/core/Mage/Core/Block/Abstract.php(238): Mage_Catalog_Block_Layer_View->_prepareLayout() #9 /home1/sevabhav/public_html/adamore/app/code/core/Mage/Core/Model/Layout.php(456): Mage_Core_Block_Abstract->setLayout(Object(Mage_Core_Model_Layout)) #10 /home1/sevabhav/public_html/adamore/app/code/core/Mage/Core/Model/Layout.php(472): Mage_Core_Model_Layout->createBlock('catalog/layer_v...', 'catalog.rightna...') #11 /home1/sevabhav/public_html/adamore/app/code/core/Mage/Core/Model/Layout.php(239): Mage_Core_Model_Layout->addBlock('catalog/layer_v...', 'catalog.rightna...') #12 /home1/sevabhav/public_html/adamore/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)) #13 /home1/sevabhav/public_html/adamore/app/code/core/Mage/Core/Model/Layout.php(210): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element)) #14 /home1/sevabhav/public_html/adamore/app/code/core/Mage/Core/Controller/Varien/Action.php(344): Mage_Core_Model_Layout->generateBlocks() #15 /home1/sevabhav/public_html/adamore/app/code/core/Mage/Catalog/controllers/CategoryController.php(146): Mage_Core_Controller_Varien_Action->generateLayoutBlocks() #16 /home1/sevabhav/public_html/adamore/app/code/core/Mage/Core/Controller/Varien/Action.php(419): Mage_Catalog_CategoryController->viewAction() #17 /home1/sevabhav/public_html/adamore/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('view') #18 /home1/sevabhav/public_html/adamore/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http)) #19 /home1/sevabhav/public_html/adamore/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch() #20 /home1/sevabhav/public_html/adamore/app/Mage.php(683): Mage_Core_Model_App->run(Array) #21 /home1/sevabhav/public_html/adamore/index.php(87): Mage::run('', 'store') #22 {main} Code (markup):