MEN'S DESERT PUCKER DRY SHORT SLEEVE SHIRT
- Description
- Specs
- Reviews
- Live Chat
A shirt for all your outdoor activities
Royal Robbins' best loved, most comfortable shirt in a relaxed fit, the Desert Pucker is made for easy summer days. The breathable fabric blend, made from beech trees, is incredibly soft, dries fast, and protects you from the sun. Its easy style takes you effortlessly from Friday casual to back-porch barbecue, and the pleated back, airy fabric, and relaxed fit deliver comfort all day long. You’ll want one in every color.
- Material: 80% modal, 20% polyester
- Responsibly harvested TENCEL™ Modal Desert Pucker blend is soft, cool, and quick-drying
- HeiQ Smart Temp body temp-activated thermoregulation technology keeps you cool
- Roomy relaxed fit improves comfort, freedom, and airflow
- Back pleats for extended range of motion
- Drop-in chest pocket with sunglass sleeve
- UPF 50+
- Relaxed fit
- Chest pocket
- Imported
No Reviews Yet!
-
Description
Royal Robbins' best loved, most comfortable shirt in a relaxed fit, the Desert Pucker is made for easy summer days. The breathable fabric blend, made from beech trees, is incredibly soft, dries fast, and protects you from the sun. Its easy style takes you effortlessly from Friday casual to back-porch barbecue, and the pleated back, airy fabric, and relaxed fit deliver comfort all day long. You’ll want one in every color.
-
Specs
- Material: 80% modal, 20% polyester
- Responsibly harvested TENCEL™ Modal Desert Pucker blend is soft, cool, and quick-drying
- HeiQ Smart Temp body temp-activated thermoregulation technology keeps you cool
- Roomy relaxed fit improves comfort, freedom, and airflow
- Back pleats for extended range of motion
- Drop-in chest pocket with sunglass sleeve
- UPF 50+
- Relaxed fit
- Chest pocket
- Imported
-
Reviews
No Reviews Yet!
-
Live Chat
$55.00
Choose Color
-
light olive for $55.00
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 LIGHT_OLIVE 137857 [empty string] [empty string] 0 7 0 0 LIGHT_OLIVE 46 Y [empty string] 989182 [empty string] 210708 2 PARISIAN_BLUE 137858 [empty string] [empty string] 0 7 0 0 PARISIAN_BLUE 35 Y [empty string] 989183 [empty string] 210708 3 RASPBERRY 137859 [empty string] [empty string] 0 2 0 -1 RASPBERRY 4 Y [empty string] 989136 [empty string] 210708 4 SAND_DOLLAR 137860 [empty string] [empty string] 0 7 0 0 SAND_DOLLAR 46 Y [empty string] 989137 [empty string] 210708 5 NITE_BLUE 137861 [empty string] [empty string] 0 4 0 0 NITE_BLUE 13 Y [empty string] 989130 [empty string] 210708 6 SEA_PINE 137862 [empty string] [empty string] 0 3 0 0 SEA_PINE 10 Y [empty string] 989131 [empty string] 210708 7 SKY 137863 [empty string] [empty string] 0 5 0 -1 SKY 31 Y [empty string] 989140 [empty string] 210708 CACHED false EXECUTIONTIME 0 SQL 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 210708 struct INTERNALLISTPRICE 55 INTERNALMARKDOWN false INTERNALPRICE 55 REG 55 SALE 55 TERMSALE false TERMSALELISTPRICE 0 TERMSALEPRICE 0 -
parisian blue for $55.00
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 LIGHT_OLIVE 137857 [empty string] [empty string] 0 7 0 0 LIGHT_OLIVE 46 Y [empty string] 989182 [empty string] 210708 2 PARISIAN_BLUE 137858 [empty string] [empty string] 0 7 0 0 PARISIAN_BLUE 35 Y [empty string] 989183 [empty string] 210708 3 RASPBERRY 137859 [empty string] [empty string] 0 2 0 -1 RASPBERRY 4 Y [empty string] 989136 [empty string] 210708 4 SAND_DOLLAR 137860 [empty string] [empty string] 0 7 0 0 SAND_DOLLAR 46 Y [empty string] 989137 [empty string] 210708 5 NITE_BLUE 137861 [empty string] [empty string] 0 4 0 0 NITE_BLUE 13 Y [empty string] 989130 [empty string] 210708 6 SEA_PINE 137862 [empty string] [empty string] 0 3 0 0 SEA_PINE 10 Y [empty string] 989131 [empty string] 210708 7 SKY 137863 [empty string] [empty string] 0 5 0 -1 SKY 31 Y [empty string] 989140 [empty string] 210708 CACHED false EXECUTIONTIME 0 SQL 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 210708 struct INTERNALLISTPRICE 55 INTERNALMARKDOWN false INTERNALPRICE 55 REG 55 SALE 55 TERMSALE false TERMSALELISTPRICE 0 TERMSALEPRICE 0 -
raspberry for $55.00
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 LIGHT_OLIVE 137857 [empty string] [empty string] 0 7 0 0 LIGHT_OLIVE 46 Y [empty string] 989182 [empty string] 210708 2 PARISIAN_BLUE 137858 [empty string] [empty string] 0 7 0 0 PARISIAN_BLUE 35 Y [empty string] 989183 [empty string] 210708 3 RASPBERRY 137859 [empty string] [empty string] 0 2 0 -1 RASPBERRY 4 Y [empty string] 989136 [empty string] 210708 4 SAND_DOLLAR 137860 [empty string] [empty string] 0 7 0 0 SAND_DOLLAR 46 Y [empty string] 989137 [empty string] 210708 5 NITE_BLUE 137861 [empty string] [empty string] 0 4 0 0 NITE_BLUE 13 Y [empty string] 989130 [empty string] 210708 6 SEA_PINE 137862 [empty string] [empty string] 0 3 0 0 SEA_PINE 10 Y [empty string] 989131 [empty string] 210708 7 SKY 137863 [empty string] [empty string] 0 5 0 -1 SKY 31 Y [empty string] 989140 [empty string] 210708 CACHED false EXECUTIONTIME 0 SQL 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 210708 struct INTERNALLISTPRICE 55 INTERNALMARKDOWN false INTERNALPRICE 55 REG 55 SALE 55 TERMSALE false TERMSALELISTPRICE 0 TERMSALEPRICE 0 -
sand dollar for $55.00
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 LIGHT_OLIVE 137857 [empty string] [empty string] 0 7 0 0 LIGHT_OLIVE 46 Y [empty string] 989182 [empty string] 210708 2 PARISIAN_BLUE 137858 [empty string] [empty string] 0 7 0 0 PARISIAN_BLUE 35 Y [empty string] 989183 [empty string] 210708 3 RASPBERRY 137859 [empty string] [empty string] 0 2 0 -1 RASPBERRY 4 Y [empty string] 989136 [empty string] 210708 4 SAND_DOLLAR 137860 [empty string] [empty string] 0 7 0 0 SAND_DOLLAR 46 Y [empty string] 989137 [empty string] 210708 5 NITE_BLUE 137861 [empty string] [empty string] 0 4 0 0 NITE_BLUE 13 Y [empty string] 989130 [empty string] 210708 6 SEA_PINE 137862 [empty string] [empty string] 0 3 0 0 SEA_PINE 10 Y [empty string] 989131 [empty string] 210708 7 SKY 137863 [empty string] [empty string] 0 5 0 -1 SKY 31 Y [empty string] 989140 [empty string] 210708 CACHED false EXECUTIONTIME 0 SQL 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 210708 struct INTERNALLISTPRICE 55 INTERNALMARKDOWN false INTERNALPRICE 55 REG 55 SALE 55 TERMSALE false TERMSALELISTPRICE 0 TERMSALEPRICE 0 -
nite blue for $55.00
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 LIGHT_OLIVE 137857 [empty string] [empty string] 0 7 0 0 LIGHT_OLIVE 46 Y [empty string] 989182 [empty string] 210708 2 PARISIAN_BLUE 137858 [empty string] [empty string] 0 7 0 0 PARISIAN_BLUE 35 Y [empty string] 989183 [empty string] 210708 3 RASPBERRY 137859 [empty string] [empty string] 0 2 0 -1 RASPBERRY 4 Y [empty string] 989136 [empty string] 210708 4 SAND_DOLLAR 137860 [empty string] [empty string] 0 7 0 0 SAND_DOLLAR 46 Y [empty string] 989137 [empty string] 210708 5 NITE_BLUE 137861 [empty string] [empty string] 0 4 0 0 NITE_BLUE 13 Y [empty string] 989130 [empty string] 210708 6 SEA_PINE 137862 [empty string] [empty string] 0 3 0 0 SEA_PINE 10 Y [empty string] 989131 [empty string] 210708 7 SKY 137863 [empty string] [empty string] 0 5 0 -1 SKY 31 Y [empty string] 989140 [empty string] 210708 CACHED false EXECUTIONTIME 0 SQL 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 210708 struct INTERNALLISTPRICE 55 INTERNALMARKDOWN false INTERNALPRICE 55 REG 55 SALE 55 TERMSALE false TERMSALELISTPRICE 0 TERMSALEPRICE 0 -
sea pine for $55.00
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 LIGHT_OLIVE 137857 [empty string] [empty string] 0 7 0 0 LIGHT_OLIVE 46 Y [empty string] 989182 [empty string] 210708 2 PARISIAN_BLUE 137858 [empty string] [empty string] 0 7 0 0 PARISIAN_BLUE 35 Y [empty string] 989183 [empty string] 210708 3 RASPBERRY 137859 [empty string] [empty string] 0 2 0 -1 RASPBERRY 4 Y [empty string] 989136 [empty string] 210708 4 SAND_DOLLAR 137860 [empty string] [empty string] 0 7 0 0 SAND_DOLLAR 46 Y [empty string] 989137 [empty string] 210708 5 NITE_BLUE 137861 [empty string] [empty string] 0 4 0 0 NITE_BLUE 13 Y [empty string] 989130 [empty string] 210708 6 SEA_PINE 137862 [empty string] [empty string] 0 3 0 0 SEA_PINE 10 Y [empty string] 989131 [empty string] 210708 7 SKY 137863 [empty string] [empty string] 0 5 0 -1 SKY 31 Y [empty string] 989140 [empty string] 210708 CACHED false EXECUTIONTIME 0 SQL 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 210708 struct INTERNALLISTPRICE 55 INTERNALMARKDOWN false INTERNALPRICE 55 REG 55 SALE 55 TERMSALE false TERMSALELISTPRICE 0 TERMSALEPRICE 0 -
sky for $55.00
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 LIGHT_OLIVE 137857 [empty string] [empty string] 0 7 0 0 LIGHT_OLIVE 46 Y [empty string] 989182 [empty string] 210708 2 PARISIAN_BLUE 137858 [empty string] [empty string] 0 7 0 0 PARISIAN_BLUE 35 Y [empty string] 989183 [empty string] 210708 3 RASPBERRY 137859 [empty string] [empty string] 0 2 0 -1 RASPBERRY 4 Y [empty string] 989136 [empty string] 210708 4 SAND_DOLLAR 137860 [empty string] [empty string] 0 7 0 0 SAND_DOLLAR 46 Y [empty string] 989137 [empty string] 210708 5 NITE_BLUE 137861 [empty string] [empty string] 0 4 0 0 NITE_BLUE 13 Y [empty string] 989130 [empty string] 210708 6 SEA_PINE 137862 [empty string] [empty string] 0 3 0 0 SEA_PINE 10 Y [empty string] 989131 [empty string] 210708 7 SKY 137863 [empty string] [empty string] 0 5 0 -1 SKY 31 Y [empty string] 989140 [empty string] 210708 CACHED false EXECUTIONTIME 0 SQL 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 210708 struct INTERNALLISTPRICE 55 INTERNALMARKDOWN false INTERNALPRICE 55 REG 55 SALE 55 TERMSALE false TERMSALELISTPRICE 0 TERMSALEPRICE 0
866-367-6278
Sign In
