SLEEPING GIANT T-SHIRT

rocket 9

No 002

1 Review(s)

$19.99

Choose Color

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	STONE_BLUE	93595	[empty string]	[empty string]	0	6	0	0	STONE_BLUE	30	Y	[empty string]	805155	[empty string]	46948

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) >=2) 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) >= 2 ORDER BY max(b.attr1_order), max(b.attr1_entry_id)

SQLPARAMETERS

array
1	46948

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

CHOOSE Size

Size Chart

Size

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

Rooted In The Earth, Reaching For The Sky

The classic tees of the outdoor era are finally back. Rooted in the past and reissued for today, the Sleeping Giant features a graphic that has been re-mastered from the original 1970's pen and ink drawings. Get the original vintage look you can't find anywhere else. The Mast Store logo is featured on the back.

100% cotton
Short-sleeved
Crew neck
Graphic front
Mast Store logo upper back center
Unisex sizing
Machine wash cold, tumble dry low

Average 5 out of 5

1 reviews
Marcia

August 19, 2018

Sleeping giant t-shirt!

I bought this t-shirt almost 15 years ago! Still wear it, love it and get compliments on it. I tried to add photo of shirt but could not.

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

The classic tees of the outdoor era are finally back. Rooted in the past and reissued for today, the Sleeping Giant features a graphic that has been re-mastered from the original 1970's pen and ink drawings. Get the original vintage look you can't find anywhere else. The Mast Store logo is featured on the back.
Specs
- 100% cotton
- Short-sleeved
- Crew neck
- Graphic front
- Mast Store logo upper back center
- Unisex sizing
- Machine wash cold, tumble dry low
Reviews
- Average 5 out of 5
  
  1 reviews
- Marcia
  
  August 19, 2018
  
  Sleeping giant t-shirt!
  
  I bought this t-shirt almost 15 years ago! Still wear it, love it and get compliments on it. I tried to add photo of shirt but could not.
Live Chat