PATAGONIA

Patagonia Women's Barely Baggies Shorts - 2.5in

$55.00

Item # 57043

query
RESULTSET
query
  ORIGSIZ QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SKU_ID STYLE_ID
1 XS 5 142501 XS [empty string] 511078 127584
2 S 4 142502 S [empty string] 511069 127584
3 M 11 142503 M [empty string] 511085 127584
4 L 30 142504 L [empty string] 511138 127584
5 XL 44 142505 XL [empty string] 511139 127584
CACHED false
EXECUTIONTIME 373
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 57043
2 127584
query
RESULTSET
query
  ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID FAM HEX ORIGATTR1 QOH SIZE SKU_ID SORT_ORDER STYLE_ID
1 PAPB_BLUE [empty string] 129928 [empty string] [empty string] PAPB_BLUE 20 142505 511062 [empty string] 127584
2 WWTT_TEAL [empty string] 129930 [empty string] [empty string] WWTT_TEAL 15 142505 511072 [empty string] 127584
3 REPI_PINK [empty string] 129933 [empty string] [empty string] REPI_PINK 13 142505 511087 [empty string] 127584
4 VALV_VLET [empty string] 129932 [empty string] [empty string] VALV_VLET 13 142505 511082 [empty string] 127584
5 BLK_BLACK [empty string] 129916 [empty string] [empty string] BLK_BLACK 12 142505 471105 [empty string] 127584
6 WREP_PINK [empty string] 129931 [empty string] [empty string] WREP_PINK 9 142505 511077 [empty string] 127584
7 LVBL_VLET [empty string] 129936 [empty string] [empty string] LVBL_VLET 6 142505 511139 [empty string] 127584
8 POBL_BLUE [empty string] 129934 [empty string] [empty string] POBL_BLUE 6 142505 511092 [empty string] 127584
CACHED false
EXECUTIONTIME 3
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 127584
Patagonia Women's Barely Baggies Shorts - 2.5in PAPB_BLUE Patagonia Women's Barely Baggies Shorts - 2.5in WWTT_TEAL Patagonia Women's Barely Baggies Shorts - 2.5in REPI_PINK Patagonia Women's Barely Baggies Shorts - 2.5in VALV_VLET Patagonia Women's Barely Baggies Shorts - 2.5in BLK_BLACK Patagonia Women's Barely Baggies Shorts - 2.5in WREP_PINK Patagonia Women's Barely Baggies Shorts - 2.5in LVBL_VLET Patagonia Women's Barely Baggies Shorts - 2.5in POBL_BLUE
XS S M L XL
query
RESULTSET
query
  ATTR1_ENTRY_ID ATTR2_ENTRY_ID DEPT PURCHASE_AMOUNT QOH SCALE_ENTRY_ID SKU_ID STORE_ID STYLE
1 129916 65593 72-W/S SPORTSWEAR [empty string] 1 142501 471069 98 57043
2 129917 65593 72-W/S SPORTSWEAR [empty string] 0 142501 471070 98 57043
3 129918 65593 72-W/S SPORTSWEAR [empty string] 0 142501 471071 98 57043
4 129919 65593 72-W/S SPORTSWEAR [empty string] 0 142501 471072 98 57043
5 129920 65593 72-W/S SPORTSWEAR [empty string] 0 142501 471073 98 57043
6 129921 65593 72-W/S SPORTSWEAR [empty string] 0 142501 471074 98 57043
7 129922 65593 72-W/S SPORTSWEAR [empty string] 0 142501 471075 98 57043
8 129923 65593 72-W/S SPORTSWEAR [empty string] 0 142501 471076 98 57043
9 129924 65593 72-W/S SPORTSWEAR [empty string] 0 142501 471077 98 57043
10 129916 65593 72-W/S SPORTSWEAR [empty string] 0 142502 471078 98 57043
11 129917 65593 72-W/S SPORTSWEAR [empty string] 0 142502 471079 98 57043
12 129918 65593 72-W/S SPORTSWEAR [empty string] 0 142502 471080 98 57043
13 129919 65593 72-W/S SPORTSWEAR [empty string] 0 142502 471081 98 57043
14 129920 65593 72-W/S SPORTSWEAR [empty string] 0 142502 471082 98 57043
15 129921 65593 72-W/S SPORTSWEAR [empty string] 0 142502 471083 98 57043
16 129922 65593 72-W/S SPORTSWEAR [empty string] 0 142502 471084 98 57043
17 129923 65593 72-W/S SPORTSWEAR [empty string] 0 142502 471085 98 57043
18 129924 65593 72-W/S SPORTSWEAR [empty string] 0 142502 471086 98 57043
19 129916 65593 72-W/S SPORTSWEAR [empty string] 0 142503 471087 98 57043
20 129917 65593 72-W/S SPORTSWEAR [empty string] 0 142503 471088 98 57043
21 129918 65593 72-W/S SPORTSWEAR [empty string] 0 142503 471089 98 57043
22 129919 65593 72-W/S SPORTSWEAR [empty string] 0 142503 471090 98 57043
23 129920 65593 72-W/S SPORTSWEAR [empty string] 0 142503 471091 98 57043
24 129921 65593 72-W/S SPORTSWEAR [empty string] 0 142503 471092 98 57043
25 129922 65593 72-W/S SPORTSWEAR [empty string] 0 142503 471093 98 57043
26 129923 65593 72-W/S SPORTSWEAR [empty string] 0 142503 471094 98 57043
27 129924 65593 72-W/S SPORTSWEAR [empty string] 0 142503 471095 98 57043
28 129916 65593 72-W/S SPORTSWEAR [empty string] 4 142504 471096 98 57043
29 129917 65593 72-W/S SPORTSWEAR [empty string] 0 142504 471097 98 57043
30 129918 65593 72-W/S SPORTSWEAR [empty string] 0 142504 471098 98 57043
31 129919 65593 72-W/S SPORTSWEAR [empty string] 0 142504 471099 98 57043
32 129920 65593 72-W/S SPORTSWEAR [empty string] 0 142504 471100 98 57043
33 129921 65593 72-W/S SPORTSWEAR [empty string] 0 142504 471101 98 57043
34 129922 65593 72-W/S SPORTSWEAR [empty string] 0 142504 471102 98 57043
35 129923 65593 72-W/S SPORTSWEAR [empty string] 0 142504 471103 98 57043
36 129924 65593 72-W/S SPORTSWEAR [empty string] 0 142504 471104 98 57043
37 129916 65593 72-W/S SPORTSWEAR [empty string] 8 142505 471105 98 57043
38 129917 65593 72-W/S SPORTSWEAR [empty string] 0 142505 471106 98 57043
39 129918 65593 72-W/S SPORTSWEAR [empty string] 0 142505 471107 98 57043
40 129919 65593 72-W/S SPORTSWEAR [empty string] 0 142505 471108 98 57043
41 129920 65593 72-W/S SPORTSWEAR [empty string] 0 142505 471109 98 57043
42 129921 65593 72-W/S SPORTSWEAR [empty string] 0 142505 471110 98 57043
43 129922 65593 72-W/S SPORTSWEAR [empty string] 0 142505 471111 98 57043
44 129923 65593 72-W/S SPORTSWEAR [empty string] 0 142505 471112 98 57043
45 129924 65593 72-W/S SPORTSWEAR [empty string] 0 142505 471113 98 57043
46 129925 65593 72-W/S SPORTSWEAR [empty string] 0 142501 488402 98 57043
47 129925 65593 72-W/S SPORTSWEAR [empty string] 0 142502 488403 98 57043
48 129925 65593 72-W/S SPORTSWEAR [empty string] 0 142503 488404 98 57043
49 129925 65593 72-W/S SPORTSWEAR [empty string] 0 142504 488405 98 57043
50 129925 65593 72-W/S SPORTSWEAR [empty string] 0 142505 488406 98 57043
51 129926 65593 72-W/S SPORTSWEAR [empty string] 0 142501 488407 98 57043
52 129926 65593 72-W/S SPORTSWEAR [empty string] 0 142502 488408 98 57043
53 129926 65593 72-W/S SPORTSWEAR [empty string] 0 142503 488409 98 57043
54 129926 65593 72-W/S SPORTSWEAR [empty string] 0 142504 488410 98 57043
55 129926 65593 72-W/S SPORTSWEAR [empty string] 0 142505 488411 98 57043
56 129927 65593 72-W/S SPORTSWEAR [empty string] 0 142501 488412 98 57043
57 129927 65593 72-W/S SPORTSWEAR [empty string] 0 142502 488413 98 57043
58 129927 65593 72-W/S SPORTSWEAR [empty string] 0 142503 488414 98 57043
59 129927 65593 72-W/S SPORTSWEAR [empty string] 0 142504 488415 98 57043
60 129927 65593 72-W/S SPORTSWEAR [empty string] 0 142505 488416 98 57043
61 129928 65593 72-W/S SPORTSWEAR [empty string] 3 142501 511058 98 57043
62 129928 65593 72-W/S SPORTSWEAR [empty string] 2 142502 511059 98 57043
63 129928 65593 72-W/S SPORTSWEAR [empty string] 2 142503 511060 98 57043
64 129928 65593 72-W/S SPORTSWEAR [empty string] 9 142504 511061 98 57043
65 129928 65593 72-W/S SPORTSWEAR [empty string] 4 142505 511062 98 57043
66 129929 65593 72-W/S SPORTSWEAR [empty string] 0 142501 511063 98 57043
67 129929 65593 72-W/S SPORTSWEAR [empty string] 0 142502 511064 98 57043
68 129929 65593 72-W/S SPORTSWEAR [empty string] 1 142503 511065 98 57043
69 129929 65593 72-W/S SPORTSWEAR [empty string] 0 142504 511066 98 57043
70 129929 65593 72-W/S SPORTSWEAR [empty string] 1 142505 511067 98 57043
71 129930 65593 72-W/S SPORTSWEAR [empty string] 1 142501 511068 98 57043
72 129930 65593 72-W/S SPORTSWEAR [empty string] 2 142502 511069 98 57043
73 129930 65593 72-W/S SPORTSWEAR [empty string] 5 142503 511070 98 57043
74 129930 65593 72-W/S SPORTSWEAR [empty string] 4 142504 511071 98 57043
75 129930 65593 72-W/S SPORTSWEAR [empty string] 4 142505 511072 98 57043
76 129931 65593 72-W/S SPORTSWEAR [empty string] 1 142501 511073 98 57043
77 129931 65593 72-W/S SPORTSWEAR [empty string] 1 142502 511074 98 57043
78 129931 65593 72-W/S SPORTSWEAR [empty string] 0 142503 511075 98 57043
79 129931 65593 72-W/S SPORTSWEAR [empty string] 3 142504 511076 98 57043
80 129931 65593 72-W/S SPORTSWEAR [empty string] 6 142505 511077 98 57043
81 129932 65593 72-W/S SPORTSWEAR [empty string] 2 142501 511078 98 57043
82 129932 65593 72-W/S SPORTSWEAR [empty string] 1 142502 511079 98 57043
83 129932 65593 72-W/S SPORTSWEAR [empty string] 1 142503 511080 98 57043
84 129932 65593 72-W/S SPORTSWEAR [empty string] 4 142504 511081 98 57043
85 129932 65593 72-W/S SPORTSWEAR [empty string] 7 142505 511082 98 57043
86 129933 65593 72-W/S SPORTSWEAR [empty string] 0 142501 511083 98 57043
87 129933 65593 72-W/S SPORTSWEAR [empty string] 0 142502 511084 98 57043
88 129933 65593 72-W/S SPORTSWEAR [empty string] 4 142503 511085 98 57043
89 129933 65593 72-W/S SPORTSWEAR [empty string] 4 142504 511086 98 57043
90 129933 65593 72-W/S SPORTSWEAR [empty string] 5 142505 511087 98 57043
91 129934 65593 72-W/S SPORTSWEAR [empty string] 1 142501 511088 98 57043
92 129934 65593 72-W/S SPORTSWEAR [empty string] 0 142502 511089 98 57043
93 129934 65593 72-W/S SPORTSWEAR [empty string] 0 142503 511090 98 57043
94 129934 65593 72-W/S SPORTSWEAR [empty string] 1 142504 511091 98 57043
95 129934 65593 72-W/S SPORTSWEAR [empty string] 6 142505 511092 98 57043
96 129935 65593 72-W/S SPORTSWEAR [empty string] 0 142501 511130 98 57043
97 129935 65593 72-W/S SPORTSWEAR [empty string] 0 142502 511131 98 57043
98 129935 65593 72-W/S SPORTSWEAR [empty string] 0 142503 511132 98 57043
99 129935 65593 72-W/S SPORTSWEAR [empty string] 0 142504 511133 98 57043
100 129935 65593 72-W/S SPORTSWEAR [empty string] 1 142505 511134 98 57043
101 129936 65593 72-W/S SPORTSWEAR [empty string] 0 142501 511135 98 57043
102 129936 65593 72-W/S SPORTSWEAR [empty string] 0 142502 511136 98 57043
103 129936 65593 72-W/S SPORTSWEAR [empty string] 1 142503 511137 98 57043
104 129936 65593 72-W/S SPORTSWEAR [empty string] 2 142504 511138 98 57043
105 129936 65593 72-W/S SPORTSWEAR [empty string] 4 142505 511139 98 57043
CACHED false
EXECUTIONTIME 7
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 = '57043' ) 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 = 65593 AND isNull(b.sell_web,'Y') = 'Y' GROUP BY b.sku_id ORDER BY b.sku_id
SQLPARAMETERS
array
1 127584
106
Add to Cart Find in Store Add to Wish List

product description The amphibious Patagonia Women's Barely Baggies Shorts - 2.5in don't care if it's Sundown Falls or Surfer's Point, as long as they're submerged. The Baggies Shorts - 2.5in have a low rise and shorter inseam and are made of Supplex® nylon with a DWR (durable water repellent) finish; 2½in inseam.
product specs
  • Made of Supplex® nylon for durability with a DWR (durable water repellent) finish
  • Covered elastic waistband with inner drawcord
  • Side-entry pockets with polyester mesh for drainage
  • Right-front pocket has elastic key loop
  • Hidden top-entry mesh pocket
  • Side slits on each leg
  • 2½in inseam
  • 119g (4.2oz)
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 <li>Made of Supplex&#174; nylon for durability with a DWR (durable water repellent) finish</li> <li>Covered elastic waistband with inner drawcord</li> <li>Side-entry pockets with polyester mesh for drainage</li> <li>Right-front pocket has elastic key loop</li> <li>Hidden top-entry mesh pocket</li> <li>Side slits on each leg</li> <li>2&frac12;in inseam</li> <li>119g (4.2oz)</li> [empty string] [empty string] 59482 PAPB_BLUE,WWTT_TEAL,REPI_PINK,VALV_VLET,BLK_BLACK,WREP_PINK,LVBL_VLET,POBL_BLUE, 65571 PATAGONIA PATAGONIA CLOTHING & FOOTWEAR Clothing & Footwear &gt Women's &gt Bottoms &gt Shorts [empty string] [empty string] [empty string] 596 [empty string] 27329662 [empty string] 55 55 55 [empty string] 16906-DEFAULT-l.jpg 55 [empty string] 16906-DEFAULT-m.jpg The amphibious Patagonia Women's Barely Baggies Shorts - 2.5in don't care if it's Sundown Falls or Surfer's Point, as long as they're submerged. [empty string] W/ Barely Baggies 2.5in N [empty string] [empty string] [empty string] [empty string] [empty string] BTSTFW [empty string] [empty string] PIN [empty string] [empty string] [empty string] 72E [empty string] [empty string] FALL_3 [empty string] IN_98 PICK ME [empty string] PATAGONIA 93 0 [empty string] 16906 16906 50-to-100 0.00 0 [empty string] [empty string] [empty string] Patagonia Women's Barely Baggies Shorts - 2.5in The amphibious Patagonia Women's Barely Baggies Shorts - 2.5in don't care if it's Sundown Falls or Surfer's Point, as long as they're submerged. The Baggies Shorts - 2.5in have a low rise and shorter inseam and are made of Supplex&#174; nylon with a DWR (durable water repellent) finish; 2&frac12;in inseam. [empty string] N 55 55 56957 0 L,M,S,XL,XS, [empty string] 16906-DEFAULT-s.jpg 1000 57043 127584 BOTTOMS SHORTS EMPTY 0 [empty string] [empty string] 16906-DEFAULT-xs.jpg WOMENS shop/patagonia-womens-barely-baggie-127584 0 [empty string] 57043 [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 5
SQL SELECT * from [dbo].[web_all_products] WHERE style_id='127584' order by ID desc