SELECT distinct (b.attr1) as origAttr1, max(CASE WHEN b.attr1_alias IS NULL OR RTRIM(LTRIM(b.attr1_alias)) = '' THEN b.attr1 ELSE b.attr1_alias END) as attr1, max(a.sku_id) as sku_id, max(b.attr1_entry_id) as attr1_entry_id, sum(e.qoh+e.qc) as qoh, max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam,max(z.non_invt) as non_invt
FROM tb_skus a
LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id)
LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id)
LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1)
LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id)
LEFT JOIN tb_styles z on (z.style_id = a.style_id)
WHERE (a.sell_web not in ('N','NO') or (a.sell_web is null)) and a.style_id=?
AND e.store_id in(1,2,3,4)
GROUP BY b.attr1
ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
The Terra Fire 300 R Hand Torch is the running essential that you didn't know you were missing. From walking your dog at night to running your favorite dark trails, the Terra Fire 300 produces a bright light to lead the way. The grip free design allows you to comfortably carry in either hand with the adjustable hand strap. The built-in whistle allows you to easily alert other runners or to scare off any coyotes that could cross your path.
With up to 40 hours, you have a long lasting light designed to fit comfortably in your hand while you run without having to grip the light. A 120 DB Alarm is built in to alert or deter any person or critters with an audible tone from over 500 feet. The bright 300+ Lumens light can light your way to keep you safe and the downward projection angle allows you to run while casting light ahead of you.
Grip free design with adjustable hand strap fits your hand
120 DB Alarm which is audible from over 500 Feet
40 hours (low), 24 hours (medium), 9 hours (high)
Bright light in rain or snow IPX4 Weather resistant
ABS 44%, TPE 13.2%, PC 16.4%, Al 4.7%, Cu 2%, Mn 2%, Silicone 2%, Polyester 5.6%, SBR rubber 6.7%
Lighting Modes: Low - 40 Hours, Med - 24 Hours, High - 9 Hours
We offer free standard shipping on all orders $50+ and a flat rate on all orders under that amount. Expedited shippingis available in checkout for a shipping premium.
Any unworn product can be returned for a full refund within 90 days. We do not offer free return shipping except in cases of defective items. These can be returned for a full refund within 90 days at no expense to you. Please contact us with any inquiries.
Returns can be mailed to:
8970 Kingsridge Dr.
Dayton, OH 45458