YETI Rambler 30 oz Travel Mug With Stronghold Lid
$29.97 to $42.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 = '21071500733' 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|
Bring on the potholes, quick turns, and backcountry roads because this behemoth travel mug holds enough caffeine for even the biggest coffee drinkers. With an elevated handle and cupholder compatible design, it makes mornings on the road that much easier. Plus, its leak-resistant Stronghold™ Lid easily rotates to fasten for both right-and left-handed users —meaning your daily fuel will stay put when you’re on the go. And since both this travel mug and its lid are dishwasher safe, all you have to do is kick up your feet after a well-traveled day.
- 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® 30 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. Do not use the Rambler Travel Mug Stronghold Lid 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
$299.99 to $300.00