User Review: Scarpa SL M3

Scarpa SL M3
Above: The current SL M3, which may differ slightly from the version reviewed.

Reviewed July 15, 2004 by Marc Adin

Rating:
Weight: sl m3's a little over 3
Price Paid: $225

there are only two great boots out in the crammed niche of true hikers. the scarpa sl m3's and the new scarpa zg 20's are superior to any commericial boot made. the zg 20' will give the sl m3's a run for the money. they are lighter, cost a little less, but are rock tough. when you wear either of these boots in the most rugged terrain for 12 hours with a 30 pound pack, you will have forgotten how much they cost because you will happier with these hikers than any boot you have ever worn; 42 years of trekking and i have never had better boots. and i have spent a lot of time and money trying to find the best. i just hope scarpa never stops making them. marc adin.

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 = '7920'
								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 = '72'
								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 Scarpa SL M3. 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 Scarpa SL M3? List your site here.

Similar Footwear

Compare
See how the Scarpa SL M3 stacks up against the competition: read more footwear reviews or more about Scarpa.

Contribute
Have you used a Scarpa SL M3 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)