The North Face Prism Optimus Jacket

The North Face Prism Optimus Jacket

Average Rating: rated 4.50 of 5 stars
Reviewed by 3 Trailspace users

Description

The Prism Optimus Jacket is a down insulated jacket made by The North Face. It has an average rating of 4.5 stars (out of 5), based on 3 user reviews.

Can't open file: 'retailer_brand.MYI' (errno: 145)
	SELECT
				product.product_id,
				brand.brand_id,
				brand.short_name AS brand,
				brand.url_stub AS brand_url_stub,
				product.product_name,
				product.producttype_id AS producttype_id,
				product.gender,
				product.url_stub,
				product.description,
				product.manufacturer_description,
				UNIX_TIMESTAMP(product.date_available) AS date_available,
				product.date_available_note,
				product.price_msrp,
				product.specs,
#				GROUP_CONCAT(DISTINCT(IF(product.gender IN('u'),'m,w',IF(product.gender IN('b','g'),'k',product.gender)))) AS genders,
				product_totals.overall_average_rating AS average_rating,
				product_totals.overall_num_reviews AS num_reviews,
				product_totals.num_retailers
			FROM
				(
				product,
				brand
				)
			LEFT JOIN
				product_totals
			ON
				product_totals.product_id = product.product_id
			WHERE
				product.url_stub = 'prism-optimus-jacket'
				AND brand.brand_id = product.brand_id
				AND brand.brand_id = '39'
			GROUP BY
				product.producttype_id
			ORDER BY
				product.producttype_id

User Reviews

rated 4 of 5 stars Men's Prism Optimus Jacket
Reviewed by Diarmuid, Nov 21, 2007

"I have to say this is a very good down jacket with only one drawback. The hood. It is not very well insulated and in short is too thin. Also when you face the wind it tends to get blown back not completely off your head but 15% off your head. You can wear a climbing helmet under the hood very comfortably."

Read the complete review »

rated 5 of 5 stars Men's Prism Optimus Jacket
Reviewed by Mainer, Nov 27, 2006

"This is an awesome jacket. I got a good deal at $162, but it is well worth the $250-300 it normally goes for.

I have packed this jacket many times into its stuff sack as a backup in cold weather and it still lofts as much as when it was new. This is a very lightweight jacket."

Read the complete review »

rated 4 of 5 stars Men's Prism Optimus Jacket
Reviewed by Chad, Jan 16, 2006

"This may be one of the most comfortable jacket out there. After trying on other down jackets, I found this jacket to be much more comfortable. It is very light and warm. The hood is very functional but too bulky when folded in. I don't think you can fit a helmet in there."

Read the complete review »

Have you owned or used a The North Face Prism Optimus Jacket? Share your thoughts with other hikers and backpackers.

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 = '9141'
								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 = '39'
								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 The North Face Prism Optimus Jacket. 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 The North Face Prism Optimus Jacket? List your site here.

Similar Insulated Jackets

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