YETI Rambler 20 oz Travel Mug With Stronghold Lid
$29.97 to $38.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 = '21071500946' 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|
This double-duty, on-the-go drink handler is topped with the Rambler® Stronghold™ Lid—a leak-resistant, twist-on upgrade that’s backed with dual-slider magnet technology. This lid easily rotates to fasten for both right-and left-handed users, adding a strong layer between your free-flowing drink and the outside world. And if we’re talkin’ about where to take it, its elevated handle lets you enjoy cupholder convenience just about anywhere.
- 18/8 Stainless Steel - Made with kitchen-grade stainless steel, so they're puncture-and-rust-resistant.
- Double-Wall Vacuum Insulation - Keeps hot drinks hot and cold drinks cold.
- Dishwasher Safe - Because no one needs more work to do.
- Leak-Resistant Lid - Twist-on, twist-off lid backed with dual-slider magnet technology to keep your coffee full and worries away. (As long as it's closed.)
Please Note: The Stronghold™ Lid is specially made for the Rambler® 20 oz. Travel Mug and won’t fit other Rambler® Drinkware models. The Travel Mug Stronghold™ Lid has 4 placement options and plays nice with both righties and lefties, just like all other Rambler® Drinkware.
CAUTION: Not for use with carbonated beverages and should not be used as storage for food or perishables.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review