PATAGONIA

Patagonia Boys Baggies Longs

$39.00

Item # 67040

query
RESULTSET
query
  ORIGSIZ QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SKU_ID STYLE_ID
1 XS 10 143201 XS [empty string] 510176 127769
2 S 15 143202 S [empty string] 510177 127769
3 M 14 143203 M [empty string] 510178 127769
4 L 12 143204 L [empty string] 510179 127769
CACHED false
EXECUTIONTIME 1062
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+e.qc) 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) LEFT JOIN tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.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.store_id in (98,8,9,2,5,7,6,3) GROUP BY b.siz HAVING sum(e.qoh+e.qc) > 0 ORDER BY max(b.size_order), max(a.scale_entry_id)
SQLPARAMETERS
array
1 67040
2 127769
Patagonia Boys Baggies Longs BLUE_BAPO Patagonia Boys Baggies Longs NAVY_NENA
XS S M L
Add to Cart Find in Store Add to Wish List


product description

No childhood is complete without a proper romp in Colorado River mud. Made to slough off mud and water, the Patagonia Boys Baggies Longs are made from recycled nylon with a DWR (durable water repellent) finish plus 50+ UPF sun protection. It has an elasticized waist with an internal drawcord for an easy on/off fit that won't slip during cannonballs. These versatile shorts have a quick-drying, built-in mesh liner. The mesh pockets drain quickly and have bartacked seams for durability. The inseam is 9½ inches long.

product specs
  • Wind- and water-resistant 100% recycled nylon dries quickly
  • Elasticized waist with internal, adjustable drawcord
  • Quick-drying mesh liner
  • Pockets with mesh for drainage; bartacks on pocket seams for durability
  • Regular fit
  • Inseam (size M) is 9in
  • 145g (5.1oz)
  • 4.5-oz (prints: 4.3-oz) 100% recycled nylon with a DWR (durable water repellent) finish
  • Fabric is certified as bluesign® approved
  • Made in Vietnam

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>Wind- and water-resistant 100% recycled nylon dries quickly</li> <li>Elasticized waist with internal, adjustable drawcord</li> <li>Quick-drying mesh liner</li> <li>Pockets with mesh for drainage; bartacks on pocket seams for durability</li> <li>Regular fit</li> <li>Inseam (size M) is 9in</li> <li>145g (5.1oz)</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> <li>Made in Vietnam</li> </ul> [empty string] [empty string] 59000 BLUE_BAPO,NAVY_NENA, 65743 PATAGONIA PATAGONIA DISCOVER Discover &gt Gifts For &gt Kid's Swim [empty string] [empty string] [empty string] 596 [empty string] 23779985 [empty string] 39 39 39 kids, bottoms, beach, water, baggy, shorts 16940-DEFAULT-l.jpg 39 [empty string] 16940-DEFAULT-m.jpg Get your kiddo some shorts that are baller for the beach or trail. The Patagonia Boys Baggies Longs are made of lightweight 100% recycled nylon fabric that has a DWR (durable water repellent) finish and dries quickly. [empty string] K/BAGGIES LONGS N [empty string] [empty string] [empty string] [empty string] [empty string] BTSTFW [empty string] [empty string] PIN [empty string] [empty string] [empty string] 48A [empty string] [empty string] SPRING [empty string] [empty string] [empty string] N PATAGONIA 51 0 [empty string] 16940 16940 25-to-50 0.00 0 [empty string] [empty string] [empty string] Patagonia Boys Baggies Longs <p>No childhood is complete without a proper romp in Colorado River mud. Made to slough off mud and water, the Patagonia Boys Baggies Longs are made from recycled nylon with a DWR (durable water repellent) finish plus 50+ UPF sun protection. It has an elasticized waist with an internal drawcord for an easy on/off fit that won&#39;t slip during cannonballs. These versatile shorts have a quick-drying, built-in mesh liner. The mesh pockets drain quickly and have bartacked seams for durability. The inseam is 9&frac12; inches long.</p> [empty string] N 39 39 57112 0 L,M,S,XS, [empty string] 16940-DEFAULT-s.jpg 1000 67040 127769 KIDS SWIM EMPTY EMPTY 0 2 [empty string] 16940-DEFAULT-xs.jpg GIFTS FOR shop/patagonia-boys-baggies-longs-127769 0 [empty string] 67040 [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='127769' order by ID desc