PATAGONIA

Patagonia Women's Wavefarer Boardshorts - 5in

$59.00

Item # 76598

query
RESULTSET
query
  ORIGSIZ QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SKU_ID STYLE_ID
1 6 3 125809 6 [empty string] 471151 127588
2 10 7 125811 10 88 511303 127588
3 12 2 125812 12 125 511296 127588
4 14 3 125813 14 145 471159 127588
5 16 2 125814 16 154 513002 127588
6 18 2 125815 18 161 513007 127588
7 2 2 125807 2 177 471147 127588
CACHED false
EXECUTIONTIME 391
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 76598
2 127588
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] 128783 [empty string] [empty string] BLK_BLACK 10 125813 471159 [empty string] 127588
2 WADM_BLUE [empty string] 128784 [empty string] [empty string] WADM_BLUE 7 125814 513002 [empty string] 127588
3 WRSY_YELLW [empty string] 128785 [empty string] [empty string] WRSY_YELLW 4 125815 513007 [empty string] 127588
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 127588
6 10 12 14 16 18 2
query
RESULTSET
query
  ATTR1_ENTRY_ID ATTR2_ENTRY_ID DEPT PURCHASE_AMOUNT QOH SCALE_ENTRY_ID SKU_ID STORE_ID STYLE
1 128782 65597 72-W/S SPORTSWEAR [empty string] 0 125806 471144 98 76598
2 128783 65597 72-W/S SPORTSWEAR [empty string] 1 125806 471145 98 76598
3 128782 65597 72-W/S SPORTSWEAR [empty string] 0 125807 471146 98 76598
4 128783 65597 72-W/S SPORTSWEAR [empty string] 2 125807 471147 98 76598
5 128782 65597 72-W/S SPORTSWEAR [empty string] 0 125808 471148 98 76598
6 128783 65597 72-W/S SPORTSWEAR [empty string] 0 125808 471149 98 76598
7 128782 65597 72-W/S SPORTSWEAR [empty string] 0 125809 471150 98 76598
8 128783 65597 72-W/S SPORTSWEAR [empty string] 3 125809 471151 98 76598
9 128782 65597 72-W/S SPORTSWEAR [empty string] 0 125810 471152 98 76598
10 128783 65597 72-W/S SPORTSWEAR [empty string] 1 125810 471153 98 76598
11 128782 65597 72-W/S SPORTSWEAR [empty string] 0 125811 471154 98 76598
12 128783 65597 72-W/S SPORTSWEAR [empty string] 2 125811 471155 98 76598
13 128782 65597 72-W/S SPORTSWEAR [empty string] 0 125812 471156 98 76598
14 128783 65597 72-W/S SPORTSWEAR [empty string] 1 125812 471157 98 76598
15 128782 65597 72-W/S SPORTSWEAR [empty string] 0 125813 471158 98 76598
16 128783 65597 72-W/S SPORTSWEAR [empty string] 3 125813 471159 98 76598
17 128784 65597 72-W/S SPORTSWEAR [empty string] 1 125806 511290 98 76598
18 128784 65597 72-W/S SPORTSWEAR [empty string] 0 125807 511291 98 76598
19 128784 65597 72-W/S SPORTSWEAR [empty string] 0 125808 511292 98 76598
20 128784 65597 72-W/S SPORTSWEAR [empty string] 1 125809 511293 98 76598
21 128784 65597 72-W/S SPORTSWEAR [empty string] 1 125810 511294 98 76598
22 128784 65597 72-W/S SPORTSWEAR [empty string] 3 125811 511295 98 76598
23 128784 65597 72-W/S SPORTSWEAR [empty string] 2 125812 511296 98 76598
24 128784 65597 72-W/S SPORTSWEAR [empty string] 1 125813 511297 98 76598
25 128785 65597 72-W/S SPORTSWEAR [empty string] 1 125806 511298 98 76598
26 128785 65597 72-W/S SPORTSWEAR [empty string] 0 125807 511299 98 76598
27 128785 65597 72-W/S SPORTSWEAR [empty string] 1 125808 511300 98 76598
28 128785 65597 72-W/S SPORTSWEAR [empty string] 0 125809 511301 98 76598
29 128785 65597 72-W/S SPORTSWEAR [empty string] 0 125810 511302 98 76598
30 128785 65597 72-W/S SPORTSWEAR [empty string] 2 125811 511303 98 76598
31 128785 65597 72-W/S SPORTSWEAR [empty string] 1 125812 511304 98 76598
32 128785 65597 72-W/S SPORTSWEAR [empty string] 1 125813 511305 98 76598
33 128782 65597 72-W/S SPORTSWEAR [empty string] 0 125814 513000 98 76598
34 128783 65597 72-W/S SPORTSWEAR [empty string] 1 125814 513001 98 76598
35 128784 65597 72-W/S SPORTSWEAR [empty string] 2 125814 513002 98 76598
36 128785 65597 72-W/S SPORTSWEAR [empty string] 1 125814 513003 98 76598
37 128782 65597 72-W/S SPORTSWEAR [empty string] 0 125815 513004 98 76598
38 128783 65597 72-W/S SPORTSWEAR [empty string] 1 125815 513005 98 76598
39 128784 65597 72-W/S SPORTSWEAR [empty string] 1 125815 513006 98 76598
40 128785 65597 72-W/S SPORTSWEAR [empty string] 2 125815 513007 98 76598
CACHED false
EXECUTIONTIME 31
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 = '76598' ) 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 = 65597 AND isNull(b.sell_web,'Y') = 'Y' GROUP BY b.sku_id ORDER BY b.sku_id
SQLPARAMETERS
array
1 127588
36
Add to Cart Find in Store Add to Wish List

product description

The Patagonia Women's Wavefarer Boardshorts - 5in are the foundation of Patagonia's board short collection. Made of quick-drying nylon (38% recycled) with a DWR (durable water repellent) finish and a female-specific fit, they're the ultimate go-anywhere, do-anything surf trunks. Fair Trade Certified sewing.

product specs
  • Durable and quick-drying nylon (38% recycled) with a DWR (durable water repellent) finish
  • Fair Trade Certified sewing
  • 3-piece, self-lined waistband contours to hips; flat-lying fly with a hidden button and ladderlock drawstring closure
  • Rolled side seams that overlap with self binding allow excellent movement and mobility
  • Self-draining right-rear pocket has a noncorroding, recyclable plastic zipper; with internal key loop and zipper pull for ease of use
  • Gusset allows for increased comfort while sitting on a surfboard
  • Inseam is 5in
  • 113g (4oz)
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>Durable and quick-drying nylon (38% recycled) with a DWR (durable water repellent) finish</li> <li>Fair Trade Certified sewing</li> <li>3-piece, self-lined waistband contours to hips; flat-lying fly with a hidden button and ladderlock drawstring closure</li> <li>Rolled side seams that overlap with self binding allow excellent movement and mobility</li> <li>Self-draining right-rear pocket has a noncorroding, recyclable plastic zipper; with internal key loop and zipper pull for ease of use</li> <li>Gusset allows for increased comfort while sitting on a surfboard</li> <li>Inseam is 5in</li> <li>113g (4oz)</li> </ul> [empty string] [empty string] 59089 BLK_BLACK,WADM_BLUE,WRSY_YELLW, 65575 PATAGONIA PATAGONIA CLOTHING & FOOTWEAR Clothing & Footwear [empty string] [empty string] [empty string] 596 [empty string] 27430115 [empty string] 59 59 59 [empty string] 16908-DEFAULT-l.jpg 59 [empty string] 16908-DEFAULT-m.jpg Trimming down the line or cleaning fresh-caught fish for dinner, the classic Patagonia Women's Wavefarer Boardshorts - 5in are as capable as it gets. [empty string] W/ Wavefarer Boardshorts 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] [empty string] [empty string] [empty string] PATAGONIA 22 0 [empty string] 16908 16908 50-to-100 0.00 0 [empty string] [empty string] [empty string] Patagonia Women's Wavefarer Boardshorts - 5in <p>The Patagonia Women&#39;s Wavefarer Boardshorts - 5in are the foundation of Patagonia&#39;s board short collection. Made of quick-drying nylon (38% recycled) with a DWR (durable water repellent) finish and a female-specific fit, they&#39;re the ultimate go-anywhere, do-anything surf trunks. Fair Trade Certified sewing.</p> [empty string] N 59 59 44658 0 10,12,14,16,18,2,6, [empty string] 16908-DEFAULT-s.jpg 1000 76598 127588 EMPTY EMPTY EMPTY 0 [empty string] [empty string] 16908-DEFAULT-xs.jpg EMPTY shop/patagonia-womens-wavefarer-boa-127588 0 [empty string] 76598 [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 15
SQL SELECT * from [dbo].[web_all_products] WHERE style_id='127588' order by ID desc