WOMEN'S SILVER RIDGE LITE PLAID

columbia

No 1710561_671

Be the first to review!

Regular Price: $55.00

Sale Price: $38.50

Choose Color

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	MALBEC_PLAID	109100	[empty string]	[empty string]	0	2	0	0	MALBEC_PLAID	60	[empty string]	911892	[empty string]	193339

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 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) group by sku_id having sum(qoh+qc) >=4) 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 not in ('N','NO') or (a.sell_web is null)) and a.style_id in (176252,176253,183884,183885,193338,193339,193340,198105,198106) AND e.store_id in(11,5,8,6,9,14,15,7,2,1,3) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 4 ORDER BY max(b.attr1_order), max(b.attr1_entry_id)

struct
INTERNALLISTPRICE	55
INTERNALMARKDOWN	false
INTERNALPRICE	55
REG	55
SALE	38.5
TERMSALE	true
TERMSALELISTPRICE	55
TERMSALEPRICE	38.5

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

stay cool and protected all day long

The Women's Silver Ridge Lite Plaid by Columbia pulls double duty with casual style for the office and performance on the trail. The fabric is treated with Omni-Wick and Omni-Shade technologies that wicks away moisture while providing UPF 40 sun protection as you pack on the miles. The Silver Ridge features strategic venting and chest pockets for small items, and there's a button-tab feature on the sleeve so you can roll 'em up, and make some tracks.

100% polyester
Omni-Shade® UPF 40 sun protection
Omni-Wick® high performance wicking fabric
Button-up front
Long-sleeved with roll tab feature
Chest pockets
Zip-closed security pocket
Vented
Active fit
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

The Women's Silver Ridge Lite Plaid by Columbia pulls double duty with casual style for the office and performance on the trail. The fabric is treated with Omni-Wick and Omni-Shade technologies that wicks away moisture while providing UPF 40 sun protection as you pack on the miles. The Silver Ridge features strategic venting and chest pockets for small items, and there's a button-tab feature on the sleeve so you can roll 'em up, and make some tracks.
Specs
- 100% polyester
- Omni-Shade® UPF 40 sun protection
- Omni-Wick® high performance wicking fabric
- Button-up front
- Long-sleeved with roll tab feature
- Chest pockets
- Zip-closed security pocket
- Vented
- Active fit
- Imported
Reviews

No Reviews Yet!
Live Chat