SELECT `e`.*, `_table_catalog_compare_item_id`.`catalog_compare_item_id`, `catalog_compare_item`.`product_id`, `catalog_compare_item`.`customer_id`, `catalog_compare_item`.`visitor_id`, `_table_website_id`.`website_id`, IFNULL(_table_visibility.value, _table_visibility_default.value) AS `visibility` FROM `catalog_product_entity` AS `e`
 INNER JOIN `catalog_compare_item` AS `_table_catalog_compare_item_id` ON (_table_catalog_compare_item_id.product_id=e.entity_id) AND (_table_catalog_compare_item_id.visitor_id = '913530')
 INNER JOIN `catalog_compare_item` ON (catalog_compare_item.catalog_compare_item_id=_table_catalog_compare_item_id.catalog_compare_item_id)
 INNER JOIN `catalog_product_website` AS `_table_website_id` ON (_table_website_id.product_id=e.entity_id) AND (_table_website_id.website_id=1)
 INNER JOIN `catalog_product_entity_int` AS `_table_visibility_default` ON (_table_visibility_default.entity_id = e.entity_id) AND (_table_visibility_default.attribute_id='74') AND _table_visibility_default.store_id=0
 LEFT JOIN `catalog_product_entity_int` AS `_table_visibility` ON (_table_visibility.entity_id = e.entity_id) AND (_table_visibility.attribute_id='74') AND (_table_visibility.store_id='1') WHERE (e.entity_type_id = '4') AND (IFNULL(_table_visibility.value, _table_visibility_default.value) in (3, 2, 4))


Trace:
#0 /home/shopdes/public_html/en/lib/Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/shopdes/public_html/en/lib/Zend/Db/Adapter/Abstract.php(406): Zend_Db_Statement->execute(Array)
#2 /home/shopdes/public_html/en/lib/Zend/Db/Adapter/Pdo/Abstract.php(206): Zend_Db_Adapter_Abstract->query(Object(Varien_Db_Select), Array)
#3 /home/shopdes/public_html/en/lib/Zend/Db/Adapter/Abstract.php(617): Zend_Db_Adapter_Pdo_Abstract->query(Object(Varien_Db_Select), Array)
#4 /home/shopdes/public_html/en/lib/Varien/Data/Collection/Db.php(657): Zend_Db_Adapter_Abstract->fetchAll(Object(Varien_Db_Select), Array)
#5 /home/shopdes/public_html/en/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(838): Varien_Data_Collection_Db->_fetchAll(Object(Varien_Db_Select))
#6 /home/shopdes/public_html/en/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(696): Mage_Eav_Model_Entity_Collection_Abstract->_loadEntities(false, false)
#7 /home/shopdes/public_html/en/app/code/core/Mage/Catalog/Helper/Product/Compare.php(154): Mage_Eav_Model_Entity_Collection_Abstract->load()
#8 /home/shopdes/public_html/en/app/code/core/Mage/Reports/Block/Product/Compared.php(37): Mage_Catalog_Helper_Product_Compare->getItemCollection()
#9 /home/shopdes/public_html/en/app/code/core/Mage/Core/Model/Layout.php(442): Mage_Reports_Block_Product_Compared->__construct(Array)
#10 /home/shopdes/public_html/en/app/code/core/Mage/Core/Model/Layout.php(419): Mage_Core_Model_Layout->_getBlockInstance('Mage_Reports_Bl...')
#11 /home/shopdes/public_html/en/app/code/core/Mage/Core/Model/Layout.php(220): Mage_Core_Model_Layout->addBlock('Mage_Reports_Bl...', 'right.reports.p...')
#12 /home/shopdes/public_html/en/app/code/core/Mage/Core/Model/Layout.php(186): Mage_Core_Model_Layout->_generateBlock(Object(Mage_Core_Model_Layout_Element), Object(Mage_Core_Model_Layout_Element))
#13 /home/shopdes/public_html/en/app/code/core/Mage/Core/Model/Layout.php(191): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element))
#14 /home/shopdes/public_html/en/app/code/core/Mage/Core/Controller/Varien/Action.php(278): Mage_Core_Model_Layout->generateBlocks()
#15 /home/shopdes/public_html/en/app/code/core/Mage/Core/Controller/Varien/Action.php(215): Mage_Core_Controller_Varien_Action->generateLayoutBlocks()
#16 /home/shopdes/public_html/en/app/code/core/Mage/Review/controllers/ProductController.php(111): Mage_Core_Controller_Varien_Action->loadLayout()
#17 /home/shopdes/public_html/en/app/code/core/Mage/Core/Controller/Varien/Action.php(342): Mage_Review_ProductController->listAction()
#18 /home/shopdes/public_html/en/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(159): Mage_Core_Controller_Varien_Action->dispatch('list')
#19 /home/shopdes/public_html/en/app/code/core/Mage/Core/Controller/Varien/Front.php(146): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#20 /home/shopdes/public_html/en/app/Mage.php(427): Mage_Core_Controller_Varien_Front->dispatch()
#21 /home/shopdes/public_html/en/index.php(40): Mage::run()
#22 {main}