Therm-A-Rest Trail
Average Rating: ![]()
Reviewed by 4 Trailspace users
Description
The Trail is a self-inflating sleeping pad made by Therm-A-Rest. It has an average rating of 5 stars (out of 5), based on 4 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 = 'trail'
AND brand.brand_id = product.brand_id
AND brand.brand_id = '362'
GROUP BY
product.producttype_id
ORDER BY
product.producttype_id
User Reviews
Trail (Short)
Reviewed by Jonathan Bushey, Feb 19, 2008
Trail
Reviewed by Zach, Mar 31, 2006
Trail
Reviewed by tango, Sep 18, 2005
Trail
Reviewed by Mac, Nov 15, 2004
Have you owned or used a Therm-A-Rest Trail? 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 = '9496' 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 ASCCan'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 = '362' 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 Therm-A-Rest Trail. 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 Therm-A-Rest Trail? List your site here.
Similar Sleeping Pads
- Therm-A-Rest Trail Comfort
- Therm-A-Rest Trail Fusion
- Therm-A-Rest Trail Lite
- Therm-A-Rest Trail Seat
- Therm-A-Rest TrailPro
- Therm-A-Rest ProLite 4
- ALPS Mountaineering Comfort Series Self Inflating Air Pads
- Pacific Outdoor Equipment InsulMat All Out Lite
- REI Lite-Core 1.5
- Big Agnes Hinman Pad
- More Self-Inflating Sleeping Pads »
Can't open file: 'retailer_brand.MYI' (errno: 145)



