CLASSIC TWINLOCK 20 OUNCES TRAVEL MUG

No 10_06442

Be the first to review!

$24.99

Choose Color

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	BLACK	12021	[empty string]	[empty string]	0	1	0	0	BLACK	1	Y	[empty string]	870360	[empty string]	183402

SELECT distinct (b.attr1) as origAttr1, max(CASE WHEN b.attr1_alias IS NULL OR RTRIM(LTRIM(b.attr1_alias)) = '' THEN b.attr1 ELSE b.attr1_alias END) as attr1, max(a.sku_id) as sku_id, max(b.attr1_entry_id) as attr1_entry_id, sum(e.qoh+e.qc) as qoh , max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam,max(a.SKU_OF16) as skuOF16,max(e.qoh) as maxqoh,max(e.qc) as maxqc,min(e.qoh) as minqoh,min(e.qc) as minqc,max(a.style_id) as style_id,max(a.sell_web) as sell_web FROM tb_skus a with (nolock) inner join (select distinct sku_id as sku_id from TB_SKU_BUCKETS with (nolock) where 1=1 and store_id in (11,5,8,6,9,14,15,7,2,1,3,97) group by sku_id having sum(qoh+qc) >0) skuqoh on (skuqoh.sku_id=a.sku_id) LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id) LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id) LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1) LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id) WHERE (a.sell_web in ('Y','YES') ) and a.style_id=? AND e.store_id in(11,5,8,6,9,14,15,7,2,1,3,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 0 ORDER BY max(b.attr1_order), max(b.attr1_entry_id)

SQLPARAMETERS

array
1	183402

struct
INTERNALLISTPRICE	24.99
INTERNALMARKDOWN	false
INTERNALPRICE	24.99
REG	24.99
SALE	24.99
TERMSALE	false
TERMSALELISTPRICE	0
TERMSALEPRICE	0

Qty

Check Store Availability

Add to Basket

Please login or create an account to save this product to your wish list.

Description
Specs
Reviews
Live Chat

Keep it hot or cold long enough to enjoy

We live in a fast-paced world of running here and there, and when our beverages aren't insulated well, they turn lukewarm just as fast. But lucky for you, this Classic TwinLock Travel Mug from Stanley wants to lend you a hand—and a reliable travel mug that won't disappoint! This double-wall vacuum-insulated bottle keeps drinks hot for up to 4 hours, cold for 6 hours, and iced to perfection for 25 hours. Pour in that morning coffee or tea, afternoon water or sweet tea, engage the leakproof Twin-Lock, cam-action lid, and sip until it's all gone.

18/8 stainless steel, BPA-free
Double-wall vacuum insulation
Leakproof + packable
Twin-Lock™, cam-action lid
Easy-clean lid, dishwasher safe
Car cup compatible
Steel carry loop
Dimensions: 4.8 x 3.3 x 8.9 inches (length x width x height)
Weight: 0.95 pounds

No Reviews Yet!

Spill the Beans

Headline Name Email Overall Rating

Review

We want to make sure you know: All reviews become the property of Mast General Store. Your review requires staff approval before posting. See our Terms of Use for details.

Description

We live in a fast-paced world of running here and there, and when our beverages aren't insulated well, they turn lukewarm just as fast. But lucky for you, this Classic TwinLock Travel Mug from Stanley wants to lend you a hand—and a reliable travel mug that won't disappoint! This double-wall vacuum-insulated bottle keeps drinks hot for up to 4 hours, cold for 6 hours, and iced to perfection for 25 hours. Pour in that morning coffee or tea, afternoon water or sweet tea, engage the leakproof Twin-Lock, cam-action lid, and sip until it's all gone.
Specs
- 18/8 stainless steel, BPA-free
- Double-wall vacuum insulation
- Leakproof + packable
- Twin-Lock™, cam-action lid
- Easy-clean lid, dishwasher safe
- Car cup compatible
- Steel carry loop
- Dimensions: 4.8 x 3.3 x 8.9 inches (length x width x height)
- Weight: 0.95 pounds
Reviews

No Reviews Yet!
Live Chat

CLASSIC TWINLOCK 20 OUNCES TRAVEL MUG

$24.99

Choose Color

Qty

Spill the Beans

You may also like