Hummer Suspension

Suspension lift kits for your Hummer H2 or H3 are available in many different sizes to suit your needs. The suspension lift kit manufacturers found here can give your vehicle the look you want allowing for a larger tire and wheel combination.
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 = 1 WHERE (t_d.entity_type_id = 3) AND (t_d.entity_id IN (142, 143)) AND (t_d.attribute_id IN ('41', '43', '133', '45', '46', '49', '58', '57', '151', '152', '153', '154', '155', '156', '158', '61', '66')) 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 = 1 WHERE (t_d.entity_type_id = 3) AND (t_d.entity_id IN (142, 143)) AND (t_d.attribute_id IN ('42', '68', '69', '67', '50', '51')) 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 = 1 WHERE (t_d.entity_type_id = 3) AND (t_d.entity_id IN (142, 143)) AND (t_d.attribute_id IN ('44', '47', '48', '54', '55', '56', '65', '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_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 = 1 WHERE (t_d.entity_type_id = 3) AND (t_d.entity_id IN (142, 143)) 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_decimal` AS `t_d`
 LEFT JOIN `catalog_category_entity_decimal` 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 = 1 WHERE (t_d.entity_type_id = 3) AND (t_d.entity_id IN (142, 143)) AND (t_d.attribute_id IN ('70')) AND (t_d.store_id = 0)

SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query

#0 /chroot/home/rocky/rockymountainsusp.com/html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /chroot/home/rocky/rockymountainsusp.com/html/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /chroot/home/rocky/rockymountainsusp.com/html/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#3 /chroot/home/rocky/rockymountainsusp.com/html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `t_d`.`e...', Array)
#4 /chroot/home/rocky/rockymountainsusp.com/html/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `t_d`.`e...', Array)
#5 /chroot/home/rocky/rockymountainsusp.com/html/lib/Zend/Db/Adapter/Abstract.php(734): Varien_Db_Adapter_Pdo_Mysql->query('SELECT `t_d`.`e...', Array)
#6 /chroot/home/rocky/rockymountainsusp.com/html/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(1111): Zend_Db_Adapter_Abstract->fetchAll('SELECT `t_d`.`e...')
#7 /chroot/home/rocky/rockymountainsusp.com/html/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(874): Mage_Eav_Model_Entity_Collection_Abstract->_loadAttributes(false, false)
#8 /chroot/home/rocky/rockymountainsusp.com/html/app/code/core/Mage/Catalog/Model/Resource/Category/Collection.php(199): Mage_Eav_Model_Entity_Collection_Abstract->load(false, false)
#9 /chroot/home/rocky/rockymountainsusp.com/html/lib/Varien/Data/Collection.php(752): Mage_Catalog_Model_Resource_Category_Collection->load()
#10 [internal function]: Varien_Data_Collection->count()
#11 /chroot/home/rocky/rockymountainsusp.com/html/app/code/local/Rms/Custom/Block/Category/Children.php(55): count(Object(Mage_Catalog_Model_Resource_Category_Collection))
#12 /chroot/home/rocky/rockymountainsusp.com/html/app/design/frontend/default/rockymtn/template/rms/catalog/category/view.phtml(129): Rms_Custom_Block_Category_Children->hasChildren()
#13 /chroot/home/rocky/rockymountainsusp.com/html/app/code/core/Mage/Core/Block/Template.php(241): include('/chroot/home/ro...')
#14 /chroot/home/rocky/rockymountainsusp.com/html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/defaul...')
#15 /chroot/home/rocky/rockymountainsusp.com/html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#16 /chroot/home/rocky/rockymountainsusp.com/html/app/code/core/Mage/Core/Block/Abstract.php(863): Mage_Core_Block_Template->_toHtml()
#17 /chroot/home/rocky/rockymountainsusp.com/html/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
#18 /chroot/home/rocky/rockymountainsusp.com/html/app/code/core/Mage/Core/Block/Abstract.php(863): Mage_Core_Block_Text_List->_toHtml()
#19 /chroot/home/rocky/rockymountainsusp.com/html/app/code/core/Mage/Core/Block/Abstract.php(582): Mage_Core_Block_Abstract->toHtml()
#20 /chroot/home/rocky/rockymountainsusp.com/html/app/code/core/Mage/Core/Block/Abstract.php(526): Mage_Core_Block_Abstract->_getChildHtml('content', true)
#21 /chroot/home/rocky/rockymountainsusp.com/html/app/design/frontend/default/rockymtn/template/page/3columns.phtml(51): Mage_Core_Block_Abstract->getChildHtml('content')
#22 /chroot/home/rocky/rockymountainsusp.com/html/app/code/core/Mage/Core/Block/Template.php(241): include('/chroot/home/ro...')
#23 /chroot/home/rocky/rockymountainsusp.com/html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/defaul...')
#24 /chroot/home/rocky/rockymountainsusp.com/html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#25 /chroot/home/rocky/rockymountainsusp.com/html/app/code/core/Mage/Core/Block/Abstract.php(863): Mage_Core_Block_Template->_toHtml()
#26 /chroot/home/rocky/rockymountainsusp.com/html/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml()
#27 /chroot/home/rocky/rockymountainsusp.com/html/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput()
#28 /chroot/home/rocky/rockymountainsusp.com/html/app/code/core/Mage/Catalog/controllers/CategoryController.php(159): Mage_Core_Controller_Varien_Action->renderLayout()
#29 /chroot/home/rocky/rockymountainsusp.com/html/app/code/core/Mage/Core/Controller/Varien/Action.php(419): Mage_Catalog_CategoryController->viewAction()
#30 /chroot/home/rocky/rockymountainsusp.com/html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('view')
#31 /chroot/home/rocky/rockymountainsusp.com/html/app/code/core/Mage/Core/Controller/Varien/Front.php(176): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#32 /chroot/home/rocky/rockymountainsusp.com/html/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#33 /chroot/home/rocky/rockymountainsusp.com/html/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#34 /chroot/home/rocky/rockymountainsusp.com/html/index.php(92): Mage::run('', 'store')
#35 {main}