MEN'S TERMINAL TACKLE HEATHER LONG SLEEVE SHIRT

No 1709421_S22

Description
Specs
Reviews
Live Chat

Perfect Performance

Made for the angler, this long-sleeve technical shirt offers UPF 50 for sun protection and high-performance wicking fabric for comfort. You'll be on the river in style with this functional crewneck shirt all summer long!

Fabric: 100% Polyester
Omni-Shade™ UPF 50 sun protection
Omni-Wick™
Columbia logo on the left chest
Logo printed down left sleeve
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

Made for the angler, this long-sleeve technical shirt offers UPF 50 for sun protection and high-performance wicking fabric for comfort. You'll be on the river in style with this functional crewneck shirt all summer long!
Specs
- Fabric: 100% Polyester
- Omni-Shade™ UPF 50 sun protection
- Omni-Wick™
- Columbia logo on the left chest
- Logo printed down left sleeve
- Imported
Reviews

No Reviews Yet!
Live Chat

$40.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	ATOLL_HEATHER	122298	[empty string]	[empty string]	0	5	0	0	ATOLL_HEATHER	90	Y	[empty string]	981070	[empty string]	209611
2	CHARCOAL_HEATHER	122299	[empty string]	[empty string]	0	5	0	0	CHARCOAL_HEATHER	79	Y	[empty string]	981071	[empty string]	209611
3	COOL_GREY_HEATHER	122300	[empty string]	[empty string]	0	5	0	0	COOL_GREY_HEATHER	92	Y	[empty string]	981072	[empty string]	209611
4	BR_NECTAR_HEATHER	122301	[empty string]	[empty string]	0	4	0	0	BR_NECTAR_HEATHER	9	Y	[empty string]	981069	[empty string]	209611

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	209611

struct
INTERNALLISTPRICE	40
INTERNALMARKDOWN	false
INTERNALPRICE	40
REG	40
SALE	40
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	ATOLL_HEATHER	122298	[empty string]	[empty string]	0	5	0	0	ATOLL_HEATHER	90	Y	[empty string]	981070	[empty string]	209611
2	CHARCOAL_HEATHER	122299	[empty string]	[empty string]	0	5	0	0	CHARCOAL_HEATHER	79	Y	[empty string]	981071	[empty string]	209611
3	COOL_GREY_HEATHER	122300	[empty string]	[empty string]	0	5	0	0	COOL_GREY_HEATHER	92	Y	[empty string]	981072	[empty string]	209611
4	BR_NECTAR_HEATHER	122301	[empty string]	[empty string]	0	4	0	0	BR_NECTAR_HEATHER	9	Y	[empty string]	981069	[empty string]	209611

array
1	209611

struct
INTERNALLISTPRICE	40
INTERNALMARKDOWN	false
INTERNALPRICE	40
REG	40
SALE	40
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	ATOLL_HEATHER	122298	[empty string]	[empty string]	0	5	0	0	ATOLL_HEATHER	90	Y	[empty string]	981070	[empty string]	209611
2	CHARCOAL_HEATHER	122299	[empty string]	[empty string]	0	5	0	0	CHARCOAL_HEATHER	79	Y	[empty string]	981071	[empty string]	209611
3	COOL_GREY_HEATHER	122300	[empty string]	[empty string]	0	5	0	0	COOL_GREY_HEATHER	92	Y	[empty string]	981072	[empty string]	209611
4	BR_NECTAR_HEATHER	122301	[empty string]	[empty string]	0	4	0	0	BR_NECTAR_HEATHER	9	Y	[empty string]	981069	[empty string]	209611

array
1	209611

struct
INTERNALLISTPRICE	40
INTERNALMARKDOWN	false
INTERNALPRICE	40
REG	40
SALE	40
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	ATOLL_HEATHER	122298	[empty string]	[empty string]	0	5	0	0	ATOLL_HEATHER	90	Y	[empty string]	981070	[empty string]	209611
2	CHARCOAL_HEATHER	122299	[empty string]	[empty string]	0	5	0	0	CHARCOAL_HEATHER	79	Y	[empty string]	981071	[empty string]	209611
3	COOL_GREY_HEATHER	122300	[empty string]	[empty string]	0	5	0	0	COOL_GREY_HEATHER	92	Y	[empty string]	981072	[empty string]	209611
4	BR_NECTAR_HEATHER	122301	[empty string]	[empty string]	0	4	0	0	BR_NECTAR_HEATHER	9	Y	[empty string]	981069	[empty string]	209611