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)
GROUP BY b.attr1
ORDER BY max(b.attr1_order), max(b.attr1_entry_id)
Harness the power of the sun with our newest multisport GPS watches. Durable solar charging lenses and customizable power manager modes bring you weeks of battery life. Track new activities, including indoor climbing and surfing plus new metrics for mountain biking. And keep a close eye on your training progress with performance monitoring, including training load balance, VO2 max and altitude acclimation. Get wellness tracking and convenient smart features that include music streaming, enhanced wrist heart rate, Pulse Ox3 sensing, smart notifications, Garmin Pay™ contactless payments and more.
SOLAR CHARGING POWER GLASS™ LENS Featuring a Power Glass solar charging lens and customizable power manager modes, this smartwatch can stay on and performance-ready for weeks
ALWAYS-ON DISPLAY Rugged, sophisticated designs feature an always-on 1.2" or 1.3" sunlight-readable display
SURF-READY FEATURES Record surf sessions with a dedicated activity profile; compatible with Surfline Sessions™, which creates a video of every wave you ride in front of a Surfline® camera
MTB GRIT AND FLOW Track the details of every ride with mountain biking metrics plus specialized grit and flow measurements that rate trail difficulty and how smoothly you descend, giving you a score to beat next time
INDOOR CLIMB ACTIVITY This new activity profile allows climbers to track their sessions at indoor facilities; see metrics such as number of routes, vertical distance climbed, climbing time, difficulty of each route and more
ACCLIMATION WIDGET This widget shows your current elevation, acclimated elevation and correlated Pulse Ox3 , heart rate2 and respiration rate, so you can see how you’re holding up to the current elevation
PACEPRO™ FEATURE A first-of-its-kind PacePro feature helps keep you on pace with grade-adjusted guidance as you run a course
BUILT-IN
Shipping
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.
Returns
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:
Runners Plus
8970 Kingsridge Dr.
Dayton, OH 45458
