YETI Roadie 24 Hard Cooler
|SQL||SELECT DISTINCT a.style_id, max(CASE WHEN m.description IS NULL OR RTRIM(LTRIM(m.description)) = '' THEN a.web_desc ELSE m.description END) as realname, sum(c.qoh+c.qc) as overallqoh, max(a.picture_id) as picture_id, max(a.of8) as of8, max(b.sku_id) as sku_id, max(b.sku_of7) as sku_of7, max(b.scale_entry_id) as scaleid, max(b.attr2_entry_id) as attr2id, max(b.attr1_entry_id) as attr1id, max(a.style) as style, max(r.package_id) as usepackage, max(a.web_style) as webStyle, max(m.capacity) as capacity, max(m.webstyle_sort) as webstyle_sort, max(a.NON_INVT) as NON_INVT FROM tb_styles a LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id) LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id AND NOT (c.qoh < 1 AND a.of8 in (?,?,?,?,?,?,?,?)) AND NOT (c.qoh < 1 AND a.of8='INACTIVE') AND c.store_id in(49,4) ) LEFT JOIN web_product_information m WITH (NOLOCK) ON (a.style_id = m.style_id) LEFT JOIN dbo.tb_inet_names f WITH (NOLOCK) on (f.orig_text = a.brand and f.field_name='BRAND') LEFT JOIN tb_package r WITH (NOLOCK) on (r.sku_id=b.sku_id) INNER JOIN web_all_products wb WITH (NOLOCK) ON (wb.style_id = a.style_id) WHERE a.web_style = '10022160000' AND (upper(f.web_text) = 'YETI COOLERS' or upper(f.orig_text) = 'YETI COOLERS' or upper(a.brand) = 'YETI COOLERS') GROUP BY a.style_id,a.of8 HAVING (sum(c.qoh+c.qc) > 0 OR a.of8='STK') ORDER BY max(m.webstyle_sort), a.style_id|
Made for the road and ready to go - The Roadie 24 Hard Cooler packs more while taking up less space. It's built tall to accommodate critical bottles of wine and slim enough to squeeze behind the driver's or passenger's seat of a car. Now that's what we call a road trip buddy.
- HeftyHauler Handle - Designed for easy hauling and comfortable carrying.
- LipGrip Handles - They're out of the way and make carrying your catch easy.
- Bearfoot Non-Slip Feet - Prevent sliding on the boat or in the backseat.
- Anchorpoint Tie-Down Slots - Make it easy to attach to your boat, trailer, or truck bed.
FOR DAY IN, DAY OUT USE
- Quicklatch - For quick, one-handed cooler access.
- Wine-Friendly Packing - Fits (most) standard wine bottles and two-liter soda bottle upright.
HOLD THE COLD
- Permafrost Insulation - Pressure-injected polyurethane locks in that just-packed temp.
- Interlock Lid System - Creates a form-fitting barrier against extreme temps.
- ColdLock Gasket - A freezer-quality gasket that blocks out the heat and locks in the cold.
- RockSolid Strength - For virtually indestructible protection.
- NeverFail Hinge System - An interlocking two-pin design that prevents breaking.
Please note: The Roadie 24 Dry Goods Basket is sold seperately.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review