PATAGONIA

Patagonia Men's Baggies Longs - 7in

$55.00

Item # 58034

query
RESULTSET
query
  ORIGSIZ QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SKU_ID STYLE_ID
1 XS 2 38530 XS [empty string] 514480 127526
2 S 14 38531 S [empty string] 529268 127526
3 M 44 38532 M [empty string] 529269 127526
4 L 59 38533 L [empty string] 529270 127526
5 XL 78 38534 XL [empty string] 529271 127526
6 XXL 20 38535 XXL [empty string] 514521 127526
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 58034
2 127526
query
RESULTSET
query
  ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID FAM HEX ORIGATTR1 QOH SIZE SKU_ID SORT_ORDER STYLE_ID
1 BLK_BLACK [empty string] 134433 [empty string] [empty string] BLK_BLACK 45 38535 470603 [empty string] 127526
2 Forge Grey Forge Grey 134434 [empty string] [empty string] FGE_GREY 42 38535 470604 [empty string] 127526
3 SNBL_BLUE [empty string] 134452 [empty string] [empty string] SNBL_BLUE 32 38535 514515 [empty string] 127526
4 PEAKS_PPSE [empty string] 134455 [empty string] [empty string] PEAKS_PPSE 31 38534 529271 [empty string] 127526
5 MACH_GRN [empty string] 134447 [empty string] [empty string] MACH_GRN 20 38535 514485 [empty string] 127526
6 PABL_BLU [empty string] 134448 [empty string] [empty string] PABL_BLU 13 38534 514490 [empty string] 127526
7 TRMA_MBLU [empty string] 134453 [empty string] [empty string] TRMA_MBLU 13 38535 514521 [empty string] 127526
8 POBL_BLUE [empty string] 134449 [empty string] [empty string] POBL_BLUE 11 38535 514497 [empty string] 127526
9 TATE_TEAL [empty string] 134450 [empty string] [empty string] TATE_TEAL 7 38534 514502 [empty string] 127526
10 SPCL_CORAL [empty string] 134451 [empty string] [empty string] SPCL_CORAL 3 38534 514508 [empty string] 127526
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 127526
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 134433 65543 71-M/S SPORTSWEAR [empty string] 0 38530 470543 98 58034
2 134434 65543 71-M/S SPORTSWEAR [empty string] 0 38530 470544 98 58034
3 134435 65543 71-M/S SPORTSWEAR [empty string] 0 38530 470545 98 58034
4 134436 65543 71-M/S SPORTSWEAR [empty string] 0 38530 470546 98 58034
5 134437 65543 71-M/S SPORTSWEAR [empty string] 0 38530 470547 98 58034
6 134438 65543 71-M/S SPORTSWEAR [empty string] 0 38530 470548 98 58034
7 134439 65543 71-M/S SPORTSWEAR [empty string] 0 38530 470549 98 58034
8 134440 65543 71-M/S SPORTSWEAR [empty string] 0 38530 470550 98 58034
9 134441 65543 71-M/S SPORTSWEAR [empty string] 0 38530 470551 98 58034
10 134442 65543 71-M/S SPORTSWEAR [empty string] 0 38530 470552 98 58034
11 134443 65543 71-M/S SPORTSWEAR [empty string] 0 38530 470553 98 58034
12 134444 65543 71-M/S SPORTSWEAR [empty string] 0 38530 470554 98 58034
13 134433 65543 71-M/S SPORTSWEAR [empty string] 6 38531 470555 98 58034
14 134434 65543 71-M/S SPORTSWEAR [empty string] 4 38531 470556 98 58034
15 134435 65543 71-M/S SPORTSWEAR [empty string] 0 38531 470557 98 58034
16 134436 65543 71-M/S SPORTSWEAR [empty string] 0 38531 470558 98 58034
17 134437 65543 71-M/S SPORTSWEAR [empty string] 0 38531 470559 98 58034
18 134438 65543 71-M/S SPORTSWEAR [empty string] 0 38531 470560 98 58034
19 134439 65543 71-M/S SPORTSWEAR [empty string] 0 38531 470561 98 58034
20 134440 65543 71-M/S SPORTSWEAR [empty string] 0 38531 470562 98 58034
21 134441 65543 71-M/S SPORTSWEAR [empty string] 0 38531 470563 98 58034
22 134442 65543 71-M/S SPORTSWEAR [empty string] 0 38531 470564 98 58034
23 134443 65543 71-M/S SPORTSWEAR [empty string] 0 38531 470565 98 58034
24 134444 65543 71-M/S SPORTSWEAR [empty string] 0 38531 470566 98 58034
25 134433 65543 71-M/S SPORTSWEAR [empty string] 13 38532 470567 98 58034
26 134434 65543 71-M/S SPORTSWEAR [empty string] 7 38532 470568 98 58034
27 134435 65543 71-M/S SPORTSWEAR [empty string] 0 38532 470569 98 58034
28 134436 65543 71-M/S SPORTSWEAR [empty string] 0 38532 470570 98 58034
29 134437 65543 71-M/S SPORTSWEAR [empty string] 0 38532 470571 98 58034
30 134438 65543 71-M/S SPORTSWEAR [empty string] 0 38532 470572 98 58034
31 134439 65543 71-M/S SPORTSWEAR [empty string] 0 38532 470573 98 58034
32 134440 65543 71-M/S SPORTSWEAR [empty string] 0 38532 470574 98 58034
33 134441 65543 71-M/S SPORTSWEAR [empty string] 0 38532 470575 98 58034
34 134442 65543 71-M/S SPORTSWEAR [empty string] 0 38532 470576 98 58034
35 134443 65543 71-M/S SPORTSWEAR [empty string] 0 38532 470577 98 58034
36 134444 65543 71-M/S SPORTSWEAR [empty string] 0 38532 470578 98 58034
37 134433 65543 71-M/S SPORTSWEAR [empty string] 12 38533 470579 98 58034
38 134434 65543 71-M/S SPORTSWEAR [empty string] 10 38533 470580 98 58034
39 134435 65543 71-M/S SPORTSWEAR [empty string] 0 38533 470581 98 58034
40 134436 65543 71-M/S SPORTSWEAR [empty string] 0 38533 470582 98 58034
41 134437 65543 71-M/S SPORTSWEAR [empty string] 0 38533 470583 98 58034
42 134438 65543 71-M/S SPORTSWEAR [empty string] 0 38533 470584 98 58034
43 134439 65543 71-M/S SPORTSWEAR [empty string] 0 38533 470585 98 58034
44 134440 65543 71-M/S SPORTSWEAR [empty string] 0 38533 470586 98 58034
45 134441 65543 71-M/S SPORTSWEAR [empty string] 0 38533 470587 98 58034
46 134442 65543 71-M/S SPORTSWEAR [empty string] 0 38533 470588 98 58034
47 134443 65543 71-M/S SPORTSWEAR [empty string] 0 38533 470589 98 58034
48 134444 65543 71-M/S SPORTSWEAR [empty string] 0 38533 470590 98 58034
49 134433 65543 71-M/S SPORTSWEAR [empty string] 10 38534 470591 98 58034
50 134434 65543 71-M/S SPORTSWEAR [empty string] 18 38534 470592 98 58034
51 134435 65543 71-M/S SPORTSWEAR [empty string] 0 38534 470593 98 58034
52 134436 65543 71-M/S SPORTSWEAR [empty string] 0 38534 470594 98 58034
53 134437 65543 71-M/S SPORTSWEAR [empty string] 0 38534 470595 98 58034
54 134438 65543 71-M/S SPORTSWEAR [empty string] 0 38534 470596 98 58034
55 134439 65543 71-M/S SPORTSWEAR [empty string] 0 38534 470597 98 58034
56 134440 65543 71-M/S SPORTSWEAR [empty string] 0 38534 470598 98 58034
57 134441 65543 71-M/S SPORTSWEAR [empty string] 0 38534 470599 98 58034
58 134442 65543 71-M/S SPORTSWEAR [empty string] 0 38534 470600 98 58034
59 134443 65543 71-M/S SPORTSWEAR [empty string] 0 38534 470601 98 58034
60 134444 65543 71-M/S SPORTSWEAR [empty string] 0 38534 470602 98 58034
61 134433 65543 71-M/S SPORTSWEAR [empty string] 4 38535 470603 98 58034
62 134434 65543 71-M/S SPORTSWEAR [empty string] 3 38535 470604 98 58034
63 134435 65543 71-M/S SPORTSWEAR [empty string] 0 38535 470605 98 58034
64 134436 65543 71-M/S SPORTSWEAR [empty string] 0 38535 470606 98 58034
65 134437 65543 71-M/S SPORTSWEAR [empty string] 0 38535 470607 98 58034
66 134438 65543 71-M/S SPORTSWEAR [empty string] 0 38535 470608 98 58034
67 134439 65543 71-M/S SPORTSWEAR [empty string] 0 38535 470609 98 58034
68 134440 65543 71-M/S SPORTSWEAR [empty string] 0 38535 470610 98 58034
69 134441 65543 71-M/S SPORTSWEAR [empty string] 0 38535 470611 98 58034
70 134442 65543 71-M/S SPORTSWEAR [empty string] 0 38535 470612 98 58034
71 134443 65543 71-M/S SPORTSWEAR [empty string] 0 38535 470613 98 58034
72 134444 65543 71-M/S SPORTSWEAR [empty string] 0 38535 470614 98 58034
73 134445 65543 71-M/S SPORTSWEAR [empty string] 0 38530 488883 98 58034
74 134445 65543 71-M/S SPORTSWEAR [empty string] 0 38531 488884 98 58034
75 134445 65543 71-M/S SPORTSWEAR [empty string] 0 38532 488885 98 58034
76 134445 65543 71-M/S SPORTSWEAR [empty string] 0 38533 488886 98 58034
77 134445 65543 71-M/S SPORTSWEAR [empty string] 0 38534 488887 98 58034
78 134445 65543 71-M/S SPORTSWEAR [empty string] 0 38535 488888 98 58034
79 134446 65543 71-M/S SPORTSWEAR [empty string] 0 38530 488889 98 58034
80 134446 65543 71-M/S SPORTSWEAR [empty string] 0 38531 488890 98 58034
81 134446 65543 71-M/S SPORTSWEAR [empty string] 0 38532 488891 98 58034
82 134446 65543 71-M/S SPORTSWEAR [empty string] 0 38533 488892 98 58034
83 134446 65543 71-M/S SPORTSWEAR [empty string] 0 38534 488893 98 58034
84 134446 65543 71-M/S SPORTSWEAR [empty string] 0 38535 488894 98 58034
85 134447 65543 71-M/S SPORTSWEAR [empty string] 2 38530 514480 98 58034
86 134447 65543 71-M/S SPORTSWEAR [empty string] 1 38531 514481 98 58034
87 134447 65543 71-M/S SPORTSWEAR [empty string] 0 38532 514482 98 58034
88 134447 65543 71-M/S SPORTSWEAR [empty string] 6 38533 514483 98 58034
89 134447 65543 71-M/S SPORTSWEAR [empty string] 9 38534 514484 98 58034
90 134447 65543 71-M/S SPORTSWEAR [empty string] 3 38535 514485 98 58034
91 134448 65543 71-M/S SPORTSWEAR [empty string] 1 38530 514486 98 58034
92 134448 65543 71-M/S SPORTSWEAR [empty string] 0 38531 514487 98 58034
93 134448 65543 71-M/S SPORTSWEAR [empty string] 4 38532 514488 98 58034
94 134448 65543 71-M/S SPORTSWEAR [empty string] 5 38533 514489 98 58034
95 134448 65543 71-M/S SPORTSWEAR [empty string] 4 38534 514490 98 58034
96 134448 65543 71-M/S SPORTSWEAR [empty string] 1 38535 514491 98 58034
97 134449 65543 71-M/S SPORTSWEAR [empty string] 1 38530 514492 98 58034
98 134449 65543 71-M/S SPORTSWEAR [empty string] 0 38531 514493 98 58034
99 134449 65543 71-M/S SPORTSWEAR [empty string] 0 38532 514494 98 58034
100 134449 65543 71-M/S SPORTSWEAR [empty string] 3 38533 514495 98 58034
101 134449 65543 71-M/S SPORTSWEAR [empty string] 3 38534 514496 98 58034
102 134449 65543 71-M/S SPORTSWEAR [empty string] 5 38535 514497 98 58034
103 134450 65543 71-M/S SPORTSWEAR [empty string] 1 38530 514498 98 58034
104 134450 65543 71-M/S SPORTSWEAR [empty string] 1 38531 514499 98 58034
105 134450 65543 71-M/S SPORTSWEAR [empty string] 1 38532 514500 98 58034
106 134450 65543 71-M/S SPORTSWEAR [empty string] 1 38533 514501 98 58034
107 134450 65543 71-M/S SPORTSWEAR [empty string] 7 38534 514502 98 58034
108 134450 65543 71-M/S SPORTSWEAR [empty string] 1 38535 514503 98 58034
109 134451 65543 71-M/S SPORTSWEAR [empty string] 1 38530 514504 98 58034
110 134451 65543 71-M/S SPORTSWEAR [empty string] 0 38531 514505 98 58034
111 134451 65543 71-M/S SPORTSWEAR [empty string] 0 38532 514506 98 58034
112 134451 65543 71-M/S SPORTSWEAR [empty string] 1 38533 514507 98 58034
113 134451 65543 71-M/S SPORTSWEAR [empty string] 3 38534 514508 98 58034
114 134451 65543 71-M/S SPORTSWEAR [empty string] 1 38535 514509 98 58034
115 134452 65543 71-M/S SPORTSWEAR [empty string] 0 38530 514510 98 58034
116 134452 65543 71-M/S SPORTSWEAR [empty string] 2 38531 514511 98 58034
117 134452 65543 71-M/S SPORTSWEAR [empty string] 8 38532 514512 98 58034
118 134452 65543 71-M/S SPORTSWEAR [empty string] 9 38533 514513 98 58034
119 134452 65543 71-M/S SPORTSWEAR [empty string] 10 38534 514514 98 58034
120 134452 65543 71-M/S SPORTSWEAR [empty string] 3 38535 514515 98 58034
121 134453 65543 71-M/S SPORTSWEAR [empty string] 0 38530 514516 98 58034
122 134453 65543 71-M/S SPORTSWEAR [empty string] 0 38531 514517 98 58034
123 134453 65543 71-M/S SPORTSWEAR [empty string] 2 38532 514518 98 58034
124 134453 65543 71-M/S SPORTSWEAR [empty string] 2 38533 514519 98 58034
125 134453 65543 71-M/S SPORTSWEAR [empty string] 7 38534 514520 98 58034
126 134453 65543 71-M/S SPORTSWEAR [empty string] 2 38535 514521 98 58034
127 134455 65543 71-M/S SPORTSWEAR [empty string] 0 38530 529267 98 58034
128 134455 65543 71-M/S SPORTSWEAR [empty string] 2 38531 529268 98 58034
129 134455 65543 71-M/S SPORTSWEAR [empty string] 10 38532 529269 98 58034
130 134455 65543 71-M/S SPORTSWEAR [empty string] 12 38533 529270 98 58034
131 134455 65543 71-M/S SPORTSWEAR [empty string] 7 38534 529271 98 58034
132 134455 65543 71-M/S SPORTSWEAR [empty string] 1 38535 529272 98 58034
CACHED false
EXECUTIONTIME 0
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 = '58034' ) 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 = 65543 AND isNull(b.sell_web,'Y') = 'Y' GROUP BY b.sku_id ORDER BY b.sku_id
SQLPARAMETERS
array
1 127526
230
Add to Cart Find in Store Add to Wish List

product description

The original fun-hogs, all-dependable, up-for-anything Patagonia Men's Baggies Longs - 7in are made of sturdy SUPPLEX® nylon with a DWR (durable water repellent) finish to shed moisture. They have a casual fit, an elasticized waistband with internal drawstring and a polyester mesh lining. Front pockets (with self-draining mesh corners) are positioned to reduce drag in the water, and the rear pocket closes securely with a snap. And they’re Fair Trade Certified sewn, which means the people who made them earned a premium for their labor. The inseam is 7 inches.

product specs
  • Made of quick-drying 100% recycled nylon with a DWR (durable water repellent) finish
  • Elasticized waistband with internal drawstring; quick-drying black mesh liner
  • Rear snap pocket
  • Relaxed fit
  • 227g (8oz)
  • 4.5-oz (prints: 4.3-oz) 100% recycled nylon with a DWR (durable water repellent) finish
  • Fabric is certified as bluesign® approved
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 quick-drying 100% recycled nylon&nbsp;with a DWR (durable water repellent) finish</li> <li>Elasticized waistband with internal drawstring; quick-drying black mesh liner</li> <li>Rear snap pocket</li> <li>Relaxed fit</li> <li>227g (8oz)</li> <li>4.5-oz (prints: 4.3-oz) 100% recycled nylon with a DWR (durable water repellent) finish</li> <li>Fabric is certified as bluesign&reg; approved</li> </ul> [empty string] [empty string] 60964 BLK_BLACK,FGE_GREY,SNBL_BLUE,PEAKS_PPSE,MACH_GRN,PABL_BLU,TRMA_MBLU,POBL_BLUE,TATE_TEAL,SPCL_CORAL, 65521 PATAGONIA PATAGONIA CLOTHING & FOOTWEAR Clothing & Footwear &gt Men's &gt Bottoms &gt Shorts [empty string] [empty string] [empty string] 596 [empty string] 27447828 [empty string] 55 55 55 swim, activewear 16896-DEFAULT-l.jpg 55 [empty string] 16896-DEFAULT-m.jpg Throw on the Patagonia Men's Baggies Longs - 7in and be prepared for everything under the sun. These up-for-anything bottoms are made of sturdy SUPPLEX nylon with a DWR finish to shed moisture. [empty string] M/ Baggies Shorts 7in 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] IN_98 [empty string] N PATAGONIA 216 0 [empty string] 16896 16896 50-to-100 0.00 0 [empty string] [empty string] [empty string] Patagonia Men's Baggies Longs - 7in <p>The original fun-hogs, all-dependable, up-for-anything Patagonia Men&#39;s Baggies Longs&nbsp;- 7in are made of sturdy SUPPLEX&reg; nylon with a DWR (durable water repellent) finish to shed moisture. They have a casual fit, an elasticized waistband with internal drawstring and a polyester mesh lining. Front pockets (with self-draining mesh corners) are positioned to reduce drag in the water, and the rear pocket closes securely with a snap. 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 7&nbsp;inches.</p> [empty string] N 55 55 12775 0 L,M,S,XL,XS,XXL, [empty string] 16896-DEFAULT-s.jpg 1000 58034 127526 BOTTOMS SHORTS EMPTY 0 [empty string] [empty string] 16896-DEFAULT-xs.jpg MENS shop/patagonia-mens-baggies-longs---127526 0 [empty string] 58034 [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='127526' order by ID desc