There has been an error processing your request

SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'price', query was: SELECT CASE  WHEN `capacity_new_count` BETWEEN 1 AND 10 AND `capacity_units_count` = '6222' THEN '1 lb - 10 lb' WHEN `capacity_new_count` BETWEEN 11 AND 50 AND `capacity_units_count` = '6222' THEN '11 lb - 50 lb' WHEN `capacity_new_count` BETWEEN 51 AND 100 AND `capacity_units_count` = '6222' THEN '51 lb - 100 lb' WHEN `capacity_new_count` BETWEEN 101 AND 500 AND `capacity_units_count` = '6222' THEN '101 lb - 500lb' WHEN `capacity_new_count` BETWEEN 501 AND 1000 AND `capacity_units_count` = '6222' THEN '501 lb - 1000 lb' END as `interval`, count(*) as count from (SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `cat_index`.`position` AS `cat_index_position`, `e`.`name`, `e`.`description`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`manufacturer`, `e`.`manufacturer_value`, `e`.`small_image`, `e`.`thumbnail`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`status`, `e`.`url_key`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`tax_class_id`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`size`, `e`.`size_value`, `e`.`gtin_google`, `e`.`mpn_google`, `e`.`material_google`, `e`.`gender_google`, `e`.`gender_google_value`, `e`.`age_group_google`, `e`.`age_group_google_value`, `e`.`color_google`, `e`.`size_type_google`, `e`.`size_type_google_value`, `e`.`size_system_google`, `e`.`size_system_google_value`, `e`.`call_for_pricing`, `e`.`cart_price`, `e`.`old_price`, `e`.`pan_size`, `e`.`pan_size_value`, `e`.`brand_google`, `e`.`brand_google_value`, `e`.`capacity_units`, `e`.`capacity_units_value`, `e`.`googleshopping_exclude`, `e`.`googleshopping_category`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `capacity_new_t`.`value` AS `capacity_new_count`, `capacity_units_t`.`value` AS `capacity_units_count` FROM `catalog_product_flat_1` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(1, 2, 3, 4) AND cat_index.category_id = '746'
 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
 INNER JOIN `catalog_product_entity_decimal` AS `capacity_new_t` ON capacity_new_t.entity_id = e.entity_id AND capacity_new_t.attribute_id = 227 AND capacity_new_t.store_id = 0
 INNER JOIN `catalog_product_entity_int` AS `capacity_units_t` ON capacity_units_t.entity_id = e.entity_id AND capacity_units_t.attribute_id = 221 AND capacity_units_t.store_id = 0) AS q GROUP BY `interval`
Trace: #0 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) #1 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array) #2 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #3 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT CASE WH...', Array) #4 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('SELECT CASE WH...', Array) #5 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/lib/Zend/Db/Adapter/Abstract.php(811): Varien_Db_Adapter_Pdo_Mysql->query('SELECT CASE WH...', Array) #6 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/app/code/local/Eleanorsoft/CategoryAttribute/Model/Catalog/Layer/Filter/Capacity.php(255): Zend_Db_Adapter_Abstract->fetchPairs('SELECT CASE WH...') #7 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/app/code/local/Eleanorsoft/CategoryAttribute/Model/Catalog/Layer/Filter/Capacity.php(135): Eleanorsoft_CategoryAttribute_Model_Catalog_Layer_Filter_Capacity->_getCount() #8 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/app/code/core/Mage/Catalog/Model/Layer/Filter/Abstract.php(151): Eleanorsoft_CategoryAttribute_Model_Catalog_Layer_Filter_Capacity->_getItemsData() #9 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/app/code/core/Mage/Catalog/Model/Layer/Filter/Abstract.php(120): Mage_Catalog_Model_Layer_Filter_Abstract->_initItems() #10 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/app/code/core/Mage/Catalog/Model/Layer/Filter/Abstract.php(109): Mage_Catalog_Model_Layer_Filter_Abstract->getItems() #11 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/app/code/core/Mage/Catalog/Block/Layer/Filter/Abstract.php(132): Mage_Catalog_Model_Layer_Filter_Abstract->getItemsCount() #12 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/app/code/core/Mage/Catalog/Block/Layer/View.php(218): Mage_Catalog_Block_Layer_Filter_Abstract->getItemsCount() #13 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/app/code/core/Mage/Catalog/Block/Layer/View.php(233): Mage_Catalog_Block_Layer_View->canShowOptions() #14 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/app/design/frontend/vt_nice/default/template/catalog/layer/view.phtml(34): Mage_Catalog_Block_Layer_View->canShowBlock() #15 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/app/code/core/Mage/Core/Block/Template.php(241): include('/mnt/BLOCKSTORA...') #16 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/vt_nic...') #17 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView() #18 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Template->_toHtml() #19 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml() #20 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Text_List->_toHtml() #21 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/app/code/core/Mage/Core/Block/Abstract.php(641): Mage_Core_Block_Abstract->toHtml() #22 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/app/code/core/Mage/Core/Block/Abstract.php(585): Mage_Core_Block_Abstract->_getChildHtml('left', true) #23 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/app/design/frontend/vt_nice/aaaweight/template/page/2columns-left.phtml(32): Mage_Core_Block_Abstract->getChildHtml('left') #24 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/app/code/core/Mage/Core/Block/Template.php(241): include('/mnt/BLOCKSTORA...') #25 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/vt_nic...') #26 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView() #27 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Template->_toHtml() #28 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml() #29 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput() #30 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/app/code/local/Vt/Ajaxfilter/controllers/Catalog/CategoryController.php(113): Mage_Core_Controller_Varien_Action->renderLayout() #31 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Vt_Ajaxfilter_Catalog_CategoryController->viewAction() #32 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('view') #33 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http)) #34 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/app/code/core/Mage/Core/Model/App.php(381): Mage_Core_Controller_Varien_Front->dispatch() #35 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/app/Mage.php(687): Mage_Core_Model_App->run(Array) #36 /mnt/BLOCKSTORAGE/home/683248.cloudwaysapps.com/amadzuzxdz/public_html/index.php(69): Mage::run('', 'store') #37 {main}

Error log record number: 177925709570