PATAGONIA

Patagonia Men's Long-Sleeved Organic Pima Cotton Shirt

$39.99 to $79.00

Item # 53837

query
RESULTSET
query
  ORIGSIZ QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SKU_ID STYLE_ID
1 XS 4 38530 XS [empty string] 528961 131586
2 S 10 38531 S [empty string] 528968 131586
3 M 41 38532 M [empty string] 528969 131586
4 L 42 38533 L [empty string] 528970 131586
5 XL 23 38534 XL [empty string] 528971 131586
6 XXL 4 38535 XXL [empty string] 528966 131586
CACHED false
EXECUTIONTIME 676
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 53837
2 131586
query
RESULTSET
query
  ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID FAM HEX ORIGATTR1 QOH SIZE SKU_ID SORT_ORDER STYLE_ID
1 LAVA_PRML [empty string] 134307 [empty string] [empty string] LAVA_PRML 47 38535 528966 [empty string] 131586
2 GREY_PAFY [empty string] 134308 [empty string] [empty string] GREY_PAFY 39 38534 528971 [empty string] 131586
3 BLUE_PRWB [empty string] 134306 [empty string] [empty string] BLUE_PRWB 36 38535 528960 [empty string] 131586
4 Lodge Pine: Black Lodge Pine: Black 134303 [empty string] [empty string] LPBL_BLK 2 38533 488984 [empty string] 131586
CACHED false
EXECUTIONTIME 5
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 131586
Patagonia Men's Long-Sleeved Organic Pima Cotton Shirt LAVA_PRML Patagonia Men's Long-Sleeved Organic Pima Cotton Shirt GREY_PAFY Patagonia Men's Long-Sleeved Organic Pima Cotton Shirt BLUE_PRWB Patagonia Men's Long-Sleeved Organic Pima Cotton Shirt LPBL_BLK
XS S M L XL XXL
query
RESULTSET
query
  ATTR1_ENTRY_ID ATTR2_ENTRY_ID DEPT PURCHASE_AMOUNT QOH SCALE_ENTRY_ID SKU_ID STORE_ID STYLE
1 134300 69340 71-M/S SPORTSWEAR [empty string] 0 38530 488963 98 53837
2 134301 69340 71-M/S SPORTSWEAR [empty string] 0 38530 488964 98 53837
3 134302 69340 71-M/S SPORTSWEAR [empty string] 0 38530 488965 98 53837
4 134303 69340 71-M/S SPORTSWEAR [empty string] 0 38530 488966 98 53837
5 134304 69340 71-M/S SPORTSWEAR [empty string] 0 38530 488967 98 53837
6 134305 69340 71-M/S SPORTSWEAR [empty string] 0 38530 488968 98 53837
7 134300 69340 71-M/S SPORTSWEAR [empty string] 0 38531 488969 98 53837
8 134301 69340 71-M/S SPORTSWEAR [empty string] 0 38531 488970 98 53837
9 134302 69340 71-M/S SPORTSWEAR [empty string] 0 38531 488971 98 53837
10 134303 69340 71-M/S SPORTSWEAR [empty string] 1 38531 488972 98 53837
11 134304 69340 71-M/S SPORTSWEAR [empty string] 0 38531 488973 98 53837
12 134305 69340 71-M/S SPORTSWEAR [empty string] 0 38531 488974 98 53837
13 134300 69340 71-M/S SPORTSWEAR [empty string] 0 38532 488975 98 53837
14 134301 69340 71-M/S SPORTSWEAR [empty string] 0 38532 488976 98 53837
15 134302 69340 71-M/S SPORTSWEAR [empty string] 0 38532 488977 98 53837
16 134303 69340 71-M/S SPORTSWEAR [empty string] 0 38532 488978 98 53837
17 134304 69340 71-M/S SPORTSWEAR [empty string] 0 38532 488979 98 53837
18 134305 69340 71-M/S SPORTSWEAR [empty string] 0 38532 488980 98 53837
19 134300 69340 71-M/S SPORTSWEAR [empty string] 0 38533 488981 98 53837
20 134301 69340 71-M/S SPORTSWEAR [empty string] 0 38533 488982 98 53837
21 134302 69340 71-M/S SPORTSWEAR [empty string] 0 38533 488983 98 53837
22 134303 69340 71-M/S SPORTSWEAR [empty string] 2 38533 488984 98 53837
23 134304 69340 71-M/S SPORTSWEAR [empty string] 0 38533 488985 98 53837
24 134305 69340 71-M/S SPORTSWEAR [empty string] 0 38533 488986 98 53837
25 134300 69340 71-M/S SPORTSWEAR [empty string] 0 38534 488987 98 53837
26 134301 69340 71-M/S SPORTSWEAR [empty string] 0 38534 488988 98 53837
27 134302 69340 71-M/S SPORTSWEAR [empty string] 0 38534 488989 98 53837
28 134303 69340 71-M/S SPORTSWEAR [empty string] 0 38534 488990 98 53837
29 134304 69340 71-M/S SPORTSWEAR [empty string] 0 38534 488991 98 53837
30 134305 69340 71-M/S SPORTSWEAR [empty string] 0 38534 488992 98 53837
31 134300 69340 71-M/S SPORTSWEAR [empty string] 0 38535 488993 98 53837
32 134301 69340 71-M/S SPORTSWEAR [empty string] 0 38535 488994 98 53837
33 134302 69340 71-M/S SPORTSWEAR [empty string] 0 38535 488995 98 53837
34 134303 69340 71-M/S SPORTSWEAR [empty string] 0 38535 488996 98 53837
35 134304 69340 71-M/S SPORTSWEAR [empty string] 0 38535 488997 98 53837
36 134305 69340 71-M/S SPORTSWEAR [empty string] 0 38535 488998 98 53837
37 134306 69340 71-M/S SPORTSWEAR [empty string] 2 38530 528955 98 53837
38 134306 69340 71-M/S SPORTSWEAR [empty string] 3 38531 528956 98 53837
39 134306 69340 71-M/S SPORTSWEAR [empty string] 14 38532 528957 98 53837
40 134306 69340 71-M/S SPORTSWEAR [empty string] 8 38533 528958 98 53837
41 134306 69340 71-M/S SPORTSWEAR [empty string] 7 38534 528959 98 53837
42 134306 69340 71-M/S SPORTSWEAR [empty string] 2 38535 528960 98 53837
43 134307 69340 71-M/S SPORTSWEAR [empty string] 2 38530 528961 98 53837
44 134307 69340 71-M/S SPORTSWEAR [empty string] 4 38531 528962 98 53837
45 134307 69340 71-M/S SPORTSWEAR [empty string] 14 38532 528963 98 53837
46 134307 69340 71-M/S SPORTSWEAR [empty string] 17 38533 528964 98 53837
47 134307 69340 71-M/S SPORTSWEAR [empty string] 8 38534 528965 98 53837
48 134307 69340 71-M/S SPORTSWEAR [empty string] 2 38535 528966 98 53837
49 134308 69340 71-M/S SPORTSWEAR [empty string] 1 38530 528967 98 53837
50 134308 69340 71-M/S SPORTSWEAR [empty string] 3 38531 528968 98 53837
51 134308 69340 71-M/S SPORTSWEAR [empty string] 13 38532 528969 98 53837
52 134308 69340 71-M/S SPORTSWEAR [empty string] 15 38533 528970 98 53837
53 134308 69340 71-M/S SPORTSWEAR [empty string] 8 38534 528971 98 53837
54 134308 69340 71-M/S SPORTSWEAR [empty string] 1 38535 528972 98 53837
55 134309 69340 71-M/S SPORTSWEAR [empty string] 0 38530 528973 98 53837
56 134309 69340 71-M/S SPORTSWEAR [empty string] 0 38531 528974 98 53837
57 134309 69340 71-M/S SPORTSWEAR [empty string] 0 38532 528975 98 53837
58 134309 69340 71-M/S SPORTSWEAR [empty string] 0 38533 528976 98 53837
59 134309 69340 71-M/S SPORTSWEAR [empty string] 0 38534 528977 98 53837
60 134309 69340 71-M/S SPORTSWEAR [empty string] 0 38535 528978 98 53837
61 134310 69340 71-M/S SPORTSWEAR [empty string] 0 38530 528979 98 53837
62 134310 69340 71-M/S SPORTSWEAR [empty string] 0 38531 528980 98 53837
63 134310 69340 71-M/S SPORTSWEAR [empty string] 0 38532 528981 98 53837
64 134310 69340 71-M/S SPORTSWEAR [empty string] 0 38533 528982 98 53837
65 134310 69340 71-M/S SPORTSWEAR [empty string] 0 38534 528983 98 53837
66 134310 69340 71-M/S SPORTSWEAR [empty string] 0 38535 528984 98 53837
67 134311 69340 71-M/S SPORTSWEAR [empty string] 0 38530 528985 98 53837
68 134311 69340 71-M/S SPORTSWEAR [empty string] 0 38531 528986 98 53837
69 134311 69340 71-M/S SPORTSWEAR [empty string] 0 38532 528987 98 53837
70 134311 69340 71-M/S SPORTSWEAR [empty string] 0 38533 528988 98 53837
71 134311 69340 71-M/S SPORTSWEAR [empty string] 0 38534 528989 98 53837
72 134311 69340 71-M/S SPORTSWEAR [empty string] 0 38535 528990 98 53837
73 134312 69340 71-M/S SPORTSWEAR [empty string] 0 38530 528991 98 53837
74 134312 69340 71-M/S SPORTSWEAR [empty string] 0 38531 528992 98 53837
75 134312 69340 71-M/S SPORTSWEAR [empty string] 0 38532 528993 98 53837
76 134312 69340 71-M/S SPORTSWEAR [empty string] 0 38533 528994 98 53837
77 134312 69340 71-M/S SPORTSWEAR [empty string] 0 38534 528995 98 53837
78 134312 69340 71-M/S SPORTSWEAR [empty string] 0 38535 528996 98 53837
79 134313 69340 71-M/S SPORTSWEAR [empty string] 0 38530 528997 98 53837
80 134313 69340 71-M/S SPORTSWEAR [empty string] 0 38531 528998 98 53837
81 134313 69340 71-M/S SPORTSWEAR [empty string] 0 38532 528999 98 53837
82 134313 69340 71-M/S SPORTSWEAR [empty string] 0 38533 529000 98 53837
83 134313 69340 71-M/S SPORTSWEAR [empty string] 0 38534 529001 98 53837
84 134313 69340 71-M/S SPORTSWEAR [empty string] 0 38535 529002 98 53837
CACHED false
EXECUTIONTIME 108
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 = '53837' ) 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 = 69340 AND isNull(b.sell_web,'Y') = 'Y' GROUP BY b.sku_id ORDER BY b.sku_id
SQLPARAMETERS
array
1 131586
127
Add to Cart Find in Store Add to Wish List

product description

Made of exceptionally fine, long-staple 100% organic pima cotton that requires no synthetic chemicals or fertilizers to grow, the Patagonia Men's Long-Sleeved Organic Pima Cotton Shirt will give you years of stalwart service. Soft and durable, this iconic shirt is available in a range of eye-pleasing colored plaids. It features two button-through chest patch pockets, offset shoulder seams for comfort under shoulder straps and a shirttail hem.

product specs
  • Traditional button front
  • Two single-button patch pockets
  • Shirttail hem
  • Relaxed fit
  • 272g (9.6oz)
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>Traditional button front</li> <li>Two single-button patch pockets</li> <li>Shirttail hem</li> <li>Relaxed fit</li> <li>272g (9.6oz)</li> </ul> [empty string] [empty string] 60942 LAVA_PRML,GREY_PAFY,BLUE_PRWB,LPBL_BLK, 69318 PATAGONIA PATAGONIA CLOTHING & FOOTWEAR Clothing & Footwear &gt Men's &gt Tops &gt Shirts &gt L/S Button Front [empty string] [empty string] [empty string] 596 [empty string] 27422474 [empty string] 79 39 39.99 [empty string] 27079-DEFAULT-l.jpg 79 [empty string] 27079-DEFAULT-m.jpg Enjoy years of years of stalwart service with the iconic Patagonia Men's Long-Sleeved Organic Pima Cotton Shirt. This iconic shirt is made of exceptionally fine yarn-dyed 100% organic pima cotton. [empty string] M/ Pima Cotton L/S N NEWATTR [empty string] [empty string] [empty string] [empty string] BTSTFW [empty string] [empty string] PIN [empty string] [empty string] A 71D [empty string] [empty string] FALL_3 [empty string] [empty string] [empty string] N PATAGONIA 123 0 [empty string] 27079 27079 25-to-50 0.00 0 [empty string] [empty string] [empty string] Patagonia Men's Long-Sleeved Organic Pima Cotton Shirt <p>Made of exceptionally fine, long-staple 100% organic pima cotton that requires no synthetic chemicals or fertilizers to grow, the Patagonia Men&#39;s Long-Sleeved Organic Pima Cotton Shirt will give you years of stalwart service. Soft and durable, this iconic shirt is available in a range of eye-pleasing colored plaids. It features two button-through chest patch pockets, offset shoulder seams for comfort under shoulder straps and a shirttail hem.</p> [empty string] Y 39.99 79 12775 0 L,M,S,XL,XS,XXL, [empty string] 27079-DEFAULT-s.jpg 1000 53837 131586 TOPS SHIRTS L/S BUTTON FRONT 0 [empty string] [empty string] 27079-DEFAULT-xs.jpg MENS shop/patagonia-mens-long-sleeved-or-131586 0 [empty string] 53837 [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 9
SQL SELECT * from [dbo].[web_all_products] WHERE style_id='131586' order by ID desc