YETI Rambler 36 oz Bottle With Chug Cap
$39.97 to $50.00
|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,90,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 = '21071070016' 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|
The Rambler 36 oz Bottle is designed for a life in the wild. Scorching days on the ranch and keeping you hydrated through rugged terrain are this bottle's calling, second only to keeping your drinks icy cold. For easy cleaning and use day after day, this reusable bottle is dishwasher safe. Under the cap, this reusable bottle is dishwasher safe. Under the cap, the bottle's got a wide mouth for easy cleaning and filling with ice.
- 18/8 Stainless Steel - Made with kitchen-grade stainless steel, so they're puncture-and-rust-resistant.
- Double-Wall Vacuum Insulation - Keeps cold drinks cold and hot drinks hot until the last sip, and the No Sweat exterior keeps your hands dry and unaffected, no matter how hot or cold the beverage inside.
- Dishwasher Safe - Because no one needs more work to do.
- 100% Leakproof - Carry it with confidence.
Note: Do not use the Rambler Bottle Chug Cap with carbonated beverages or for storage of food or perishables.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$69.97 to $100.00
$1.99 to $6.99
$32.99 to $40.99