MEN'S KHAMSU SHORT SLEEVE SHIRT

No SM11016

Description
Specs
Reviews
Live Chat

Ready for the grill, trail, or any other adventure

Button up your new favorite adventure shirt! From hitting the trail to grilling those burgers, you're going to be cool and comfortable in the Men's Khamsu Short Sleeve Shirt from Sherpa. It provides a lightweight and breathable fit for all-day wear. While the other guys are sweating, you'll be feeling fresh and breezy thanks to the moisture-wicking and quick-drying function.

Fabric: 60% recycled cotton/ 40% recycled polyester
Stand-up collar
Short sleeves
Button-down front
Moisture-wicking and quick-drying
Forward set shoulder seams
Single chest pocket
Faux wood buttons
Classic fit
Length: 31 inches
Imported

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

Button up your new favorite adventure shirt! From hitting the trail to grilling those burgers, you're going to be cool and comfortable in the Men's Khamsu Short Sleeve Shirt from Sherpa. It provides a lightweight and breathable fit for all-day wear. While the other guys are sweating, you'll be feeling fresh and breezy thanks to the moisture-wicking and quick-drying function.
Specs
- Fabric: 60% recycled cotton/ 40% recycled polyester
- Stand-up collar
- Short sleeves
- Button-down front
- Moisture-wicking and quick-drying
- Forward set shoulder seams
- Single chest pocket
- Faux wood buttons
- Classic fit
- Length: 31 inches
- Imported
Reviews

No Reviews Yet!
Live Chat

$65.00

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	DESERT_SAND_SPACE	123042	[empty string]	[empty string]	0	6	0	0	DESERT_SAND_SPACE	96	Y	[empty string]	983846	[empty string]	209852
2	NEELO_BLUE_NOMAD	123043	[empty string]	[empty string]	0	5	0	0	NEELO_BLUE_NOMAD	66	Y	[empty string]	983847	[empty string]	209852

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,14,6,5,9,8,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,14,6,5,9,8,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	209852

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

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	DESERT_SAND_SPACE	123042	[empty string]	[empty string]	0	6	0	0	DESERT_SAND_SPACE	96	Y	[empty string]	983846	[empty string]	209852
2	NEELO_BLUE_NOMAD	123043	[empty string]	[empty string]	0	5	0	0	NEELO_BLUE_NOMAD	66	Y	[empty string]	983847	[empty string]	209852