PATAGONIA

Patagonia Men's Lightweight All-Wear Hemp Shorts - 6in

$59.00 $46.9920% off

Item # 57756

query
RESULTSET
query
  ORIGSIZ QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SKU_ID STYLE_ID
1 28 2 5686 28 228 514886 109217
2 38 5 5694 38 285 514416 109217
CACHED false
EXECUTIONTIME 375
SQL SELECT distinct (b.siz) as origSiz, max(CASE WHEN b.siz_alias IS NULL OR RTRIM(LTRIM(b.siz_alias)) = '' THEN b.siz ELSE b.siz_alias END) as siz, max(b.size_order) as size_order, max(a.sku_id) as sku_id, max(a.scale_entry_id) as scale_entry_id, sum(e.qoh) as qoh, max(a.style_id) as style_id FROM tb_skus a WITH (NOLOCK) LEFT JOIN tb_size_entries b WITH (NOLOCK) on (b.scale_entry_id = a.scale_entry_id) INNER JOIN ( SELECT DISTINCT sku_id , sum(qoh+qc) as qoh FROM dbo.tb_sku_buckets WITH (NOLOCK) WHERE store_id in(98,8,9,2,5,7,6,3) GROUP BY sku_id ) e on (a.sku_id = e.sku_id) LEFT JOIN tb_attr1_entries d WITH (NOLOCK) on (d.attr1_entry_id = a.attr1_entry_id) LEFT JOIN ( SELECT style_id FROM tb_styles WITH (NOLOCK) WHERE web_style = ? and web_style is not null ) sq ON(a.style_id = sq.style_id) WHERE (sq.style_id is not null OR a.style_id = ?) AND (b.siz_alias is null OR b.siz_alias NOT IN ('NO SHOW','NOSHOW') ) AND isNull(a.sell_web,'Y') = 'Y' AND e.qoh > 1 GROUP BY b.siz ORDER BY max(b.size_order), max(a.scale_entry_id)
SQLPARAMETERS
array
1 57756
2 109217
query
RESULTSET
query
  ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID FAM HEX ORIGATTR1 QOH SIZE SKU_ID SORT_ORDER STYLE_ID
1 Dolomite Blue Dolomite Blue 129397 [empty string] [empty string] DLMB_BLUE 5 5694 514886 [empty string] 109217
2 CEP_PINK [empty string] 129398 [empty string] [empty string] CEP_PINK 2 5694 514416 [empty string] 109217
CACHED false
EXECUTIONTIME 0
SQL SELECT distinct (b.attr1) as origAttr1, max(b.attr1_alias) as attr1_alias, 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) as qoh, max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam, max(a.style_id) as style_id, max(a.SCALE_ENTRY_ID) as size FROM tb_skus a LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id) INNER JOIN ( SELECT DISTINCT sku_id , sum(qoh+qc) as qoh FROM dbo.tb_sku_buckets WITH (NOLOCK) WHERE store_id in(98,8,9,2,5,7,6,3) GROUP BY sku_id ) e on (a.sku_id = e.sku_id) LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1) LEFT JOIN tb_size_entries k WITH (NOLOCK) on (k.scale_entry_id = a.scale_entry_id) LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id) WHERE a.style_id =? AND (b.attr1_alias is null OR b.attr1_alias NOT IN ('NO SHOW','NOSHOW') ) AND e.qoh > 1 AND isNull(a.sell_web,'Y') = 'Y' GROUP BY b.attr1 ORDER BY sum(e.qoh) DESC --max(b.attr1_order), max(b.attr1_entry_id)
SQLPARAMETERS
array
1 109217
Patagonia Men's Lightweight All-Wear Hemp Shorts - 6in DLMB_BLUE Patagonia Men's Lightweight All-Wear Hemp Shorts - 6in CEP_PINK
28 38
query
RESULTSET
query
  ATTR1_ENTRY_ID ATTR2_ENTRY_ID DEPT PURCHASE_AMOUNT QOH SCALE_ENTRY_ID SKU_ID STORE_ID STYLE
1 129393 49162 71-M/S SPORTSWEAR [empty string] 0 5687 430267 98 57756
2 129394 49162 71-M/S SPORTSWEAR [empty string] 0 5687 430268 98 57756
3 129395 49162 71-M/S SPORTSWEAR [empty string] 0 5687 430269 98 57756
4 129393 49162 71-M/S SPORTSWEAR [empty string] 0 5688 430270 98 57756
5 129394 49162 71-M/S SPORTSWEAR [empty string] 0 5688 430271 98 57756
6 129395 49162 71-M/S SPORTSWEAR [empty string] 0 5688 430272 98 57756
7 129393 49162 71-M/S SPORTSWEAR [empty string] 1 5689 430273 98 57756
8 129394 49162 71-M/S SPORTSWEAR [empty string] 0 5689 430274 98 57756
9 129395 49162 71-M/S SPORTSWEAR [empty string] 0 5689 430275 98 57756
10 129393 49162 71-M/S SPORTSWEAR [empty string] 0 5690 430276 98 57756
11 129394 49162 71-M/S SPORTSWEAR [empty string] 0 5690 430277 98 57756
12 129395 49162 71-M/S SPORTSWEAR [empty string] 0 5690 430278 98 57756
13 129393 49162 71-M/S SPORTSWEAR [empty string] 0 5691 430279 98 57756
14 129394 49162 71-M/S SPORTSWEAR [empty string] 0 5691 430280 98 57756
15 129395 49162 71-M/S SPORTSWEAR [empty string] 1 5691 430281 98 57756
16 129393 49162 71-M/S SPORTSWEAR [empty string] 1 5692 430282 98 57756
17 129394 49162 71-M/S SPORTSWEAR [empty string] 0 5692 430283 98 57756
18 129395 49162 71-M/S SPORTSWEAR [empty string] 1 5692 430284 98 57756
19 129393 49162 71-M/S SPORTSWEAR [empty string] 0 5693 430285 98 57756
20 129394 49162 71-M/S SPORTSWEAR [empty string] 0 5693 430286 98 57756
21 129395 49162 71-M/S SPORTSWEAR [empty string] 0 5693 430287 98 57756
22 129393 49162 71-M/S SPORTSWEAR [empty string] 1 5694 430288 98 57756
23 129394 49162 71-M/S SPORTSWEAR [empty string] 0 5694 430289 98 57756
24 129395 49162 71-M/S SPORTSWEAR [empty string] 1 5694 430290 98 57756
25 129393 49162 71-M/S SPORTSWEAR [empty string] 0 5695 430291 98 57756
26 129394 49162 71-M/S SPORTSWEAR [empty string] 0 5695 430292 98 57756
27 129395 49162 71-M/S SPORTSWEAR [empty string] 0 5695 430293 98 57756
28 129396 49162 71-M/S SPORTSWEAR [empty string] 0 5687 470098 98 57756
29 129396 49162 71-M/S SPORTSWEAR [empty string] 0 5688 470099 98 57756
30 129396 49162 71-M/S SPORTSWEAR [empty string] 0 5689 470100 98 57756
31 129396 49162 71-M/S SPORTSWEAR [empty string] 0 5690 470101 98 57756
32 129396 49162 71-M/S SPORTSWEAR [empty string] 0 5691 470102 98 57756
33 129396 49162 71-M/S SPORTSWEAR [empty string] 0 5692 470103 98 57756
34 129396 49162 71-M/S SPORTSWEAR [empty string] 0 5693 470104 98 57756
35 129396 49162 71-M/S SPORTSWEAR [empty string] 0 5694 470105 98 57756
36 129396 49162 71-M/S SPORTSWEAR [empty string] 1 5695 470106 98 57756
37 129397 49162 71-M/S SPORTSWEAR [empty string] 0 5687 470107 98 57756
38 129397 49162 71-M/S SPORTSWEAR [empty string] 0 5688 470108 98 57756
39 129397 49162 71-M/S SPORTSWEAR [empty string] 0 5689 470109 98 57756
40 129397 49162 71-M/S SPORTSWEAR [empty string] 0 5690 470110 98 57756
41 129397 49162 71-M/S SPORTSWEAR [empty string] 0 5691 470111 98 57756
42 129397 49162 71-M/S SPORTSWEAR [empty string] 0 5692 470112 98 57756
43 129397 49162 71-M/S SPORTSWEAR [empty string] 0 5693 470113 98 57756
44 129397 49162 71-M/S SPORTSWEAR [empty string] 3 5694 470114 98 57756
45 129397 49162 71-M/S SPORTSWEAR [empty string] 0 5695 470115 98 57756
46 129398 49162 71-M/S SPORTSWEAR [empty string] 0 5687 514409 98 57756
47 129398 49162 71-M/S SPORTSWEAR [empty string] 0 5688 514410 98 57756
48 129398 49162 71-M/S SPORTSWEAR [empty string] 0 5689 514411 98 57756
49 129398 49162 71-M/S SPORTSWEAR [empty string] 0 5690 514412 98 57756
50 129398 49162 71-M/S SPORTSWEAR [empty string] 0 5691 514413 98 57756
51 129398 49162 71-M/S SPORTSWEAR [empty string] 0 5692 514414 98 57756
52 129398 49162 71-M/S SPORTSWEAR [empty string] 1 5693 514415 98 57756
53 129398 49162 71-M/S SPORTSWEAR [empty string] 2 5694 514416 98 57756
54 129398 49162 71-M/S SPORTSWEAR [empty string] 1 5695 514417 98 57756
55 129393 49162 71-M/S SPORTSWEAR [empty string] 0 5686 514882 98 57756
56 129394 49162 71-M/S SPORTSWEAR [empty string] 0 5686 514883 98 57756
57 129395 49162 71-M/S SPORTSWEAR [empty string] 0 5686 514884 98 57756
58 129396 49162 71-M/S SPORTSWEAR [empty string] 0 5686 514885 98 57756
59 129397 49162 71-M/S SPORTSWEAR [empty string] 2 5686 514886 98 57756
60 129398 49162 71-M/S SPORTSWEAR [empty string] 0 5686 514887 98 57756
CACHED false
EXECUTIONTIME 32
SQL SELECT sum(c.qoh+c.qc) as qoh ,max(b.sku_id) as sku_id , max(b.scale_entry_id) as scale_entry_id , max(b.attr2_entry_id) as attr2_entry_id , max(e.attr1_entry_id) as attr1_entry_id , max(g.dept) as dept , max(a.style) as style , max(c.store_id) as store_id , max(h.purchase_amount) as purchase_amount FROM tb_styles a LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id) LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id) LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id) LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id) LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id) LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id) LEFT JOIN web_product_information h WITH (NOLOCK) ON (a.style_id = h.style_id) WHERE (b.style_id IN ( SELECT style_id FROM tb_styles WHERE web_style = '57756' ) or b.style_id =?) and c.store_id in(98,8,9,2,5,7,6,3) --AND c.qoh > 1 and b.attr2_entry_id = 49162 AND isNull(b.sell_web,'Y') = 'Y' GROUP BY b.sku_id ORDER BY b.sku_id
SQLPARAMETERS
array
1 109217
16
Add to Cart Find in Store Add to Wish List

product description

Designed for heat and humidity, the cool-wearing, breathable Patagonia Men's Lightweight All-Wear Hemp Shorts - 6in are made of a soft and airy fabric blend of 76% organic cotton/24% hemp plain weave. Classic flat-front chino styling with double-needle belt loops makes them appropriate for almost any social setting. They feature a zip fly with button closure, two slanted side-entry front pockets and two welted back drop-in pockets. And they’re Fair Trade Certified sewn, which means the people who made them earned a premium for their labor. The inseam is 6 inches.

product specs
  • Made of a lightweight 76% organic cotton/24% hemp blend
  • Classic flat-front chino styling with button closure, zip fly and double-needle belt loops
  • Two slanted side-entry front pockets; two welted back drop-in pockets (right-back pocket has zipper closure)
  • 6in Inseam
  • Regular fit
  • 4.5oz 76% organic cotton/24% hemp plain weave with an anti-pilling finish
  • Fair Trade Certified sewn
Overall Rating

0.0/5.0

Review Stats 0 total reviews

5 0

4 0

3 0

2 0

1 0

Write a Review
Very Poor Poor Average Very Good Excellent
Name: *
Location:
Review Title:
Review: * (maximum 1000 characters)
1 - 0 of 0

No reviews have been written for this product.
Be the first one!  –


FREE SHIPPING* ON ORDERS OVER $100.00
My Bag (0)
Menu

query
RESULTSET
query
  ADDITIONAL_DESCRIPTION AGERANGE ALTIMAGERECORDCOUNT ATTR1ID ATTR1LIST ATTR2ID BRAND BRANDDISPLAY DEPT DEPTTREE DESCRIPTION FAMLIST GENDER GOOGLEPRODUCTTAXONOMY HEXLIST ID INSTORE_ONLY INTERNALLISTPRICE INTERNALMARKDOWN INTERNALPRICE KEYWORDS LARGEPICTURE LISTPRICE LOWESTPRICE MEDIUMPICTURE METADESC METATAGS NAME NEW OF1 OF10 OF11 OF12 OF13 OF14 OF15 OF16 OF17 OF18 OF19 OF2 OF20 OF3 OF4 OF5 OF6 OF7 OF8 OF9 ORIGBRAND OVERALLQOH OVERALL_RATING PAGETITLE PICTUREID PICTURE_ID PRICERANGE PRODREVIEWSAVERAGE PRODREVIEWSRECORDCOUNT QUANTITYONHANDSUM QUANTITYSOLDSUM RANKING REALNAME ROMANTICCOPYLONG ROMANTICCOPYSHORT SALE SALEPRICERANGEBOTTOM SALEPRICERANGETOP SCALEID SHIP_SURCHARGE SIZELIST SIZING_IMAGE_FILE SMALLPICTURE SORTPOSITION STYLE STYLE_ID SUBTYP1 SUBTYP2 SUBTYP3 TERMSALE TERMSALELISTPRICE TERMSALEPRICE TINYPICTURE TYP URL USEPACKAGE VIDEO WEBSTYLE WEB_OF1 WEB_OF10 WEB_OF11 WEB_OF12 WEB_OF13 WEB_OF14 WEB_OF15 WEB_OF16 WEB_OF17 WEB_OF18 WEB_OF19 WEB_OF2 WEB_OF20 WEB_OF3 WEB_OF4 WEB_OF5 WEB_OF6 WEB_OF7 WEB_OF8 WEB_OF9
1 <ul> <li>Made of a lightweight 76% organic cotton/24% hemp blend</li> <li>Classic flat-front chino styling with button closure, zip fly and double-needle belt loops</li> <li>Two slanted side-entry front pockets; two welted back drop-in pockets (right-back pocket has zipper closure)</li> <li>6in Inseam</li> <li>Regular fit</li> <li>4.5oz 76% organic cotton/24% hemp plain weave with an anti-pilling finish</li> <li>Fair Trade Certified&nbsp;sewn</li> </ul> [empty string] [empty string] 59339 DLMB_BLUE,CEP_PINK, 49140 PATAGONIA PATAGONIA CLOTHING & FOOTWEAR Clothing & Footwear &gt Men's &gt Bottoms [empty string] [empty string] [empty string] 204 [empty string] 27469431 [empty string] 59 46 46.99 casual, plain-front 22942-DEFAULT-l.jpg 59 [empty string] 22942-DEFAULT-m.jpg For cool-wearing comfort in hot weather, try the Patagonia Men's Lightweight All-Wear Hemp Shorts - 6in. These lightweight, breathable shorts with classic flat-front chino styling and belt loops are also appropriate for social settings. [empty string] M/LW All Wear Hemp Short 6IN N NEWATTR [empty string] [empty string] [empty string] [empty string] BTSTFW [empty string] [empty string] PIN [empty string] [empty string] A 71G [empty string] [empty string] FALL_3 [empty string] [empty string] [empty string] N PATAGONIA 6 0 [empty string] 22942 22942 25-to-50 0.00 0 [empty string] [empty string] [empty string] Patagonia Men's Lightweight All-Wear Hemp Shorts - 6in <p>Designed for heat and humidity, the cool-wearing, breathable Patagonia Men&#39;s Lightweight All-Wear Hemp Shorts - 6in are made of a soft and airy fabric blend of 76% organic cotton/24% hemp plain weave. Classic flat-front chino styling with double-needle belt loops makes them appropriate for almost any social setting. They feature a zip fly with button closure, two slanted side-entry front pockets and two welted back drop-in pockets.&nbsp;And they&rsquo;re Fair Trade Certified&nbsp;sewn, which means the people who made them earned a premium for their labor. The inseam is 6 inches.</p> [empty string] Y 46.99 46.99 2178 0 28,38, [empty string] 22942-DEFAULT-s.jpg 1000 57756 109217 BOTTOMS EMPTY EMPTY 0 [empty string] [empty string] 22942-DEFAULT-xs.jpg MENS shop/patagonia-mens-lightweight-all-109217 0 [empty string] 57756 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string]
CACHED false
EXECUTIONTIME 0
SQL SELECT * from [dbo].[web_all_products] WHERE style_id='109217' order by ID desc