YETI Rambler 26 oz Stackable Cup With Straw Lid
Out Of Stock
|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 = '21071500975' 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 supremely insulated Rambler 26 oz. Cup is built for big swigs from dawn til' dusk. It's sized perfectly for Texas-sized teas, large gulps of H20, XL smoothies, fewer refills, and keeping your drink the right temp. Plus, it comes with our fan-favorite Straw Lid so you can say goodbye to single-use plastic straws. When you're ready to store it away, save space by removing the lid and stacking it on top of another one just like it.
The Rambler Straw Lids are built to last and have a molded-in stopper that holds your straw safely in place. And just like the other Rambler Lids, it's shatter-resistant, dishwasher-safe, and completely free of BPA.
- 18/8 Stainless Steel - Made with kitchen-grade stainless steel, so they're puncture-and-rust-resistant.
- Double-Wall Vacuum Insulation - Keeps drinks cold on even the hottest days.
- Dishwasher Safe - Because no one needs more work to do.
- Cup Holder Compatible - Safely makes it from point A to B on your commute.
Please note that this Lid is not for use with hot beverages.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$19.99 to $20.00