User Review: Mountain Hardwear Wicked T Long Sleeve

Mountain Hardwear Wicked T Long Sleeve
Above: The current Wicked T Long Sleeve, which may differ slightly from the version reviewed.

Reviewed June 28, 2006 by runsfearless

Rating:
Fabric: 100% poly
Price Paid: $35

Great top, 3 season single top layer. Great wicking if worn alone. Very durable. I wear them as a shirt almost every day. Extremely comfortable. As a base layer in high exertion activities they can be warm and hold sweat. It takes a while to find the best configuration for a base layer in cold weather.

Where to Buy

Can't open file: 'retailer_brand.MYI' (errno: 145)

SELECT
								retailer.*,
								retailer_product.*,
								retailer_brand.*,
								retailer.retailer_id AS retailer_id,
								LEAST(
									IF(retailer_product.gender IS NULL,0,100),
									IF(retailer_product.gender = '',0,100),
									IF(retailer_product.gender = 'u',0,100),
									IF(retailer_product.gender = 'm',1,100),
									IF(retailer_product.gender = 'w',2,100),
									IF(retailer_product.gender = 'k',3,100),
									IF(retailer_product.gender = 'b',4,100),
									IF(retailer_product.gender = 'g',5,100)
								) AS gender_sort
							FROM 
								product AS p1,
								product AS p2,
								retailer_product,
								retailer,
								retailer_brand
							WHERE
								p1.product_id = '11045'
								AND p2.brand_id = p1.brand_id
								AND p2.product_name = p1.product_name
								AND retailer_product.product_id = p2.product_id
								AND retailer_product.status = 'active'
								AND retailer_product.product_link_url != ''
								AND retailer.retailer_id = retailer_product.retailer_id
								AND retailer.is_online = 1
								AND retailer.status = 'active'
								AND retailer.show_product_link = 1
								AND retailer_brand.retailer_id = retailer.retailer_id
								AND retailer_brand.retailer_brand_id = retailer_product.retailer_brand_id
							GROUP BY
								retailer.retailer_id,
								retailer_product.retailer_product_id
							ORDER BY
								retailer.avg_epc DESC,
								retailer.commission_rate DESC,
								retailer.cookie_days DESC,
								retailer.retailer_id ASC,
								price ASC,
								gender_sort ASC

Can't open file: 'retailer_brand.MYI' (errno: 145)

SELECT
								*,
								brand.short_name AS brand,
								retailer.retailer_id AS retailer_id
							FROM 
								brand,
								retailer,
								retailer_brand
							WHERE
								brand.brand_id = '90'
								AND retailer_brand.brand_id = brand.brand_id
								AND retailer_brand.status = 'active'
								AND retailer.retailer_id = retailer_brand.retailer_id
								AND retailer.is_online = 1
								AND retailer.status = 'active'
								AND retailer.show_brand_link = 1
							GROUP BY
								retailer.retailer_id
							ORDER BY
								# is_house_brand DESC,
								retailer.avg_epc DESC,
								retailer.commission_rate DESC,
								retailer.cookie_days DESC,
								retailer.retailer_id ASC

Sorry, we couldn't find any online retailers selling the Mountain Hardwear Wicked T Long Sleeve. You may be able to find it new or used at one of these sites:

Trailspace Classifieds

US | Canada | UK | Aus

GearTrade

Retailers: Do you sell the Mountain Hardwear Wicked T Long Sleeve? List your site here.

Similar Shirts

Compare
See how the Mountain Hardwear Wicked T Long Sleeve stacks up against the competition: read more shirt reviews or more about Mountain Hardwear.

Contribute
Have you used a Mountain Hardwear Wicked T Long Sleeve or a similar product? Write a gear review.

Discuss
Still have questions? Answers? Opinions? Join the converstation in the Trailspace Forums.

email this page

Can't open file: 'retailer_brand.MYI' (errno: 145)