Salomon XA Pro 3D Ultra

Average Rating:
Reviewed by 1 Trailspace user

View Description
Read Reviews
Write a Review
Compare Prices
View Similar Products

Description

The XA Pro 3D Ultra is a trail running shoe made by Salomon. It has an average rating of 5 stars (out of 5), based on 1 user review.

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 = 'xa-pro-3d-ultra'
				AND brand.brand_id = product.brand_id
				AND brand.brand_id = '71'
			GROUP BY
				product.producttype_id
			ORDER BY
				product.producttype_id

User Reviews

Men's XA Pro 3D Ultra
Reviewed by Bncrshr, May 15, 2008

"I have been wearing the Salomon XA Pro 3D's for several years and my only complaint was the lack of forefoot cushioning. Salomon must have listened to reviewers because the new 3D Ultras have more cushioning in the forefoot and my feet couldn't be happier!

Having owned many pairs of these shoes I've never experienced any trouble with the kevlar lacing system or the shoes falling apart."

Read the complete review »

Have you owned or used a Salomon XA Pro 3D Ultra? 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 = '32540'
								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 = '71'
								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 Salomon XA Pro 3D Ultra. 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 Salomon XA Pro 3D Ultra? List your site here.

Similar Footwear

email this page

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