SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_varchar` AS `t_d` LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 3) AND (t_d.entity_id IN (6660, 6645, 6643, 6149, 1332)) AND (t_d.attribute_id IN ('58', '61')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_datetime` AS `t_d` LEFT JOIN `catalog_category_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 3) AND (t_d.entity_id IN (6660, 6645, 6643, 6149, 1332)) AND (t_d.attribute_id IN ('59', '60')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_text` AS `t_d` LEFT JOIN `catalog_category_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 3) AND (t_d.entity_id IN (6660, 6645, 6643, 6149, 1332)) AND (t_d.attribute_id IN ('62')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_int` AS `t_d` LEFT JOIN `catalog_category_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 3) AND (t_d.entity_id IN (6660, 6645, 6643, 6149, 1332)) AND (t_d.attribute_id IN ('69')) AND (t_d.store_id = 0) SQLSTATE[HY000]: General error: 23 Out of resources when opening file '/tmp/#sql_4ea_0.MYI' (Errcode: 24 - Too many open files), query was: SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_varchar` AS `t_d` LEFT JOIN `catalog_category_entity_varchar` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 3) AND (t_d.entity_id IN (6660, 6645, 6643, 6149, 1332)) AND (t_d.attribute_id IN ('58', '61')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_datetime` AS `t_d` LEFT JOIN `catalog_category_entity_datetime` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 3) AND (t_d.entity_id IN (6660, 6645, 6643, 6149, 1332)) AND (t_d.attribute_id IN ('59', '60')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_text` AS `t_d` LEFT JOIN `catalog_category_entity_text` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 3) AND (t_d.entity_id IN (6660, 6645, 6643, 6149, 1332)) AND (t_d.attribute_id IN ('62')) AND (t_d.store_id = 0) UNION ALL SELECT `t_d`.`entity_id`, `t_d`.`attribute_id`, `t_d`.`value` AS `default_value`, `t_s`.`value` AS `store_value`, IF(t_s.value_id IS NULL, t_d.value, t_s.value) AS `value` FROM `catalog_category_entity_int` AS `t_d` LEFT JOIN `catalog_category_entity_int` AS `t_s` ON t_s.attribute_id = t_d.attribute_id AND t_s.entity_id = t_d.entity_id AND t_s.store_id = 4 WHERE (t_d.entity_type_id = 3) AND (t_d.entity_id IN (6660, 6645, 6643, 6149, 1332)) AND (t_d.attribute_id IN ('69')) AND (t_d.store_id = 0) #0 /var/www/vhosts/websitestatus.de/mah.de/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) #1 /var/www/vhosts/websitestatus.de/mah.de/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array) #2 /var/www/vhosts/websitestatus.de/mah.de/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #3 /var/www/vhosts/websitestatus.de/mah.de/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `t_d`.`e...', Array) #4 /var/www/vhosts/websitestatus.de/mah.de/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `t_d`.`e...', Array) #5 /var/www/vhosts/websitestatus.de/mah.de/lib/Zend/Db/Adapter/Abstract.php(737): Varien_Db_Adapter_Pdo_Mysql->query('SELECT `t_d`.`e...', Array) #6 /var/www/vhosts/websitestatus.de/mah.de/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(1109): Zend_Db_Adapter_Abstract->fetchAll('SELECT `t_d`.`e...') #7 /var/www/vhosts/websitestatus.de/mah.de/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(874): Mage_Eav_Model_Entity_Collection_Abstract->_loadAttributes(false, false) #8 /var/www/vhosts/websitestatus.de/mah.de/app/code/core/Mage/Catalog/Model/Resource/Category/Collection.php(225): Mage_Eav_Model_Entity_Collection_Abstract->load(false, false) #9 /var/www/vhosts/websitestatus.de/mah.de/app/code/core/Mage/Catalog/Model/Resource/Category.php(625): Mage_Catalog_Model_Resource_Category_Collection->load() #10 /var/www/vhosts/websitestatus.de/mah.de/app/code/core/Mage/Catalog/Model/Category.php(859): Mage_Catalog_Model_Resource_Category->getParentDesignCategory(Object(Mage_Catalog_Model_Category)) #11 /var/www/vhosts/websitestatus.de/mah.de/app/code/core/Mage/Catalog/Model/Design.php(349): Mage_Catalog_Model_Category->getParentDesignCategory(Object(Mage_Catalog_Model_Category)) #12 /var/www/vhosts/websitestatus.de/mah.de/app/code/core/Mage/Catalog/controllers/CategoryController.php(118): Mage_Catalog_Model_Design->getDesignSettings(Object(Mage_Catalog_Model_Category)) #13 /var/www/vhosts/websitestatus.de/mah.de/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_Catalog_CategoryController->viewAction() #14 /var/www/vhosts/websitestatus.de/mah.de/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('view') #15 /var/www/vhosts/websitestatus.de/mah.de/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http)) #16 /var/www/vhosts/websitestatus.de/mah.de/app/code/core/Mage/Core/Model/App.php(365): Mage_Core_Controller_Varien_Front->dispatch() #17 /var/www/vhosts/websitestatus.de/mah.de/app/Mage.php(684): Mage_Core_Model_App->run(Array) #18 /var/www/vhosts/websitestatus.de/mah.de/index.php(83): Mage::run('mah', 'website') #19 {main}