PATAGONIA

Patagonia Baby Baggies Cap

$25.00 $14.9940% off

Item # 66086

query
RESULTSET
query
  ORIGSIZ QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SKU_ID STYLE_ID
1 6_12 7 151227 6-12M [empty string] 510103 127760
2 24M 6 151229 24M 218 510105 127760
3 3_6 3 151226 3-6M 245 510086 127760
CACHED false
EXECUTIONTIME 443
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 66086
2 127760
query
RESULTSET
query
  ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID FAM HEX ORIGATTR1 QOH SIZE SKU_ID SORT_ORDER STYLE_ID
1 PINK_WIPP [empty string] 128400 [empty string] [empty string] PINK_WIPP 9 151229 510089 [empty string] 127760
2 PTBLU_BEPO [empty string] 128402 [empty string] [empty string] PTBLU_BEPO 5 151229 510105 [empty string] 127760
3 PRBLU_BGBR [empty string] 128401 [empty string] [empty string] PRBLU_BGBR 2 151229 510097 [empty string] 127760
CACHED false
EXECUTIONTIME 2
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 127760
Patagonia Baby Baggies Cap PINK_WIPP Patagonia Baby Baggies Cap PTBLU_BEPO Patagonia Baby Baggies Cap PRBLU_BGBR
6-12M 24M 3-6M
query
RESULTSET
query
  ATTR1_ENTRY_ID ATTR2_ENTRY_ID DEPT PURCHASE_AMOUNT QOH SCALE_ENTRY_ID SKU_ID STORE_ID STYLE
1 128398 65756 48-KIDS [empty string] 0 151226 472631 98 66086
2 128399 65756 48-KIDS [empty string] 0 151226 472632 98 66086
3 128398 65756 48-KIDS [empty string] 0 151227 472633 98 66086
4 128399 65756 48-KIDS [empty string] 0 151227 472634 98 66086
5 128398 65756 48-KIDS [empty string] 0 151228 472635 98 66086
6 128399 65756 48-KIDS [empty string] 0 151228 472636 98 66086
7 128398 65756 48-KIDS [empty string] 0 151230 472637 98 66086
8 128399 65756 48-KIDS [empty string] 0 151230 472638 98 66086
9 128398 65756 48-KIDS [empty string] 0 151231 472639 98 66086
10 128399 65756 48-KIDS [empty string] 0 151231 472640 98 66086
11 128398 65756 48-KIDS [empty string] 0 151232 472641 98 66086
12 128399 65756 48-KIDS [empty string] 0 151232 472642 98 66086
13 128398 65756 48-KIDS [empty string] 0 151229 486689 98 66086
14 128399 65756 48-KIDS [empty string] 0 151229 486690 98 66086
15 128398 65756 48-KIDS [empty string] 0 151233 495806 98 66086
16 128399 65756 48-KIDS [empty string] 0 151233 495807 98 66086
17 128400 65756 48-KIDS [empty string] 3 151226 510086 98 66086
18 128400 65756 48-KIDS [empty string] 4 151227 510087 98 66086
19 128400 65756 48-KIDS [empty string] 0 151228 510088 98 66086
20 128400 65756 48-KIDS [empty string] 2 151229 510089 98 66086
21 128400 65756 48-KIDS [empty string] 0 151230 510090 98 66086
22 128400 65756 48-KIDS [empty string] 0 151231 510091 98 66086
23 128400 65756 48-KIDS [empty string] 0 151232 510092 98 66086
24 128400 65756 48-KIDS [empty string] 0 151233 510093 98 66086
25 128401 65756 48-KIDS [empty string] -1 151226 510094 98 66086
26 128401 65756 48-KIDS [empty string] 0 151227 510095 98 66086
27 128401 65756 48-KIDS [empty string] 0 151228 510096 98 66086
28 128401 65756 48-KIDS [empty string] 2 151229 510097 98 66086
29 128401 65756 48-KIDS [empty string] 0 151230 510098 98 66086
30 128401 65756 48-KIDS [empty string] 0 151231 510099 98 66086
31 128401 65756 48-KIDS [empty string] 0 151232 510100 98 66086
32 128401 65756 48-KIDS [empty string] 0 151233 510101 98 66086
33 128402 65756 48-KIDS [empty string] 0 151226 510102 98 66086
34 128402 65756 48-KIDS [empty string] 3 151227 510103 98 66086
35 128402 65756 48-KIDS [empty string] 0 151228 510104 98 66086
36 128402 65756 48-KIDS [empty string] 2 151229 510105 98 66086
37 128402 65756 48-KIDS [empty string] 0 151230 510106 98 66086
38 128402 65756 48-KIDS [empty string] 0 151231 510107 98 66086
39 128402 65756 48-KIDS [empty string] 0 151232 510108 98 66086
40 128402 65756 48-KIDS [empty string] 0 151233 510109 98 66086
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 = '66086' ) 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 = 65756 AND isNull(b.sell_web,'Y') = 'Y' GROUP BY b.sku_id ORDER BY b.sku_id
SQLPARAMETERS
array
1 127760
15
Add to Cart Find in Store Add to Wish List

product description

The wind-resistant and water-resistant Patagonia Baby Baggies Cap meets oppressive heat and sun with cool, light-wearing ease. The baseball cap-style hat is made from 100% Supplex® nylon with a DWR (durable water repellent) finish. Its ample brim shades tender faces, and an adjustable hook-and-loop closure in back customizes the fit. For extra comfort, the internal headband is made of a quick-wicking 94% polyester (35% recycled)/6% spandex fabric blend with Polygiene® permanent odor control.

product specs
  • Wind-resistant and water-resistant Supplex® nylon dries quickly and has Polygiene® permanent odor control
  • Brim protects face from sun
  • Adjustable hook-and-loop closure in back
  • Soft internal headband wicks moisture
  • Hat packs small; easy care
  • Regular fit
  • 4.5-oz (prints: 4.3-oz) SUPPLEX® 100% recycled nylon with a DWR (durable water repellent) finish
  • Headband: 4-oz 94% polyester (35% recycled)/6% spandex with Polygiene® permanent odor control
  • Fabric is certified as bluesign® approved
  • Fair Trade Certified sewn
  • 40g (1.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>Wind-resistant and water-resistant Supplex&reg; nylon dries quickly and has Polygiene&reg; permanent odor control</li> <li>Brim protects face from sun</li> <li>Adjustable hook-and-loop closure in back</li> <li>Soft internal headband wicks moisture</li> <li>Hat packs small; easy care</li> <li>Regular fit</li> <li>4.5-oz (prints: 4.3-oz) SUPPLEX&reg; 100% recycled nylon with a DWR (durable water repellent) finish</li> <li>Headband: 4-oz 94% polyester (35% recycled)/6% spandex with Polygiene&reg; permanent odor control</li> <li>Fabric is certified as bluesign&reg; approved</li> <li>Fair Trade Certified sewn</li> <li>40g (1.4oz)</li> </ul> [empty string] [empty string] 58991 PINK_WIPP,PTBLU_BEPO,PRBLU_BGBR, 65734 PATAGONIA PATAGONIA CLOTHING & FOOTWEAR Clothing & Footwear &gt Kids &gt Infant & Toddler &gt Clothing & Accessories &gt Accessories [empty string] [empty string] [empty string] 596 [empty string] 27244511 [empty string] 25 14 14.99 hat, ballcap, infant, boy, girl 16931-DEFAULT-l.jpg 25 [empty string] 16931-DEFAULT-m.jpg Guard your little one's crown from oppressive heat and sun. The Patagonia Baby Baggies Cap is wind-resistant and water-resistant, and has a quick-wicking internal headband for extra comfort. [empty string] I/BABY BAGGIES CAP N [empty string] [empty string] [empty string] [empty string] [empty string] BTSTFW [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] 48A [empty string] [empty string] FALL_3 [empty string] [empty string] [empty string] N PATAGONIA 15 0 [empty string] 16931 16931 10-to-15 0.00 0 [empty string] [empty string] [empty string] Patagonia Baby Baggies Cap <p>The wind-resistant and water-resistant Patagonia Baby Baggies Cap meets oppressive heat and sun with cool, light-wearing ease. The baseball cap-style hat is made from 100% Supplex&reg; nylon with a DWR (durable water repellent) finish. Its ample brim shades tender faces, and an adjustable hook-and-loop closure in back customizes the fit. For extra comfort, the internal headband is made of a quick-wicking 94% polyester (35% recycled)/6% spandex fabric blend with Polygiene&reg; permanent odor control.</p> [empty string] Y 14.99 14.99 60477 0 24M,3-6M,6-12M, [empty string] 16931-DEFAULT-s.jpg 1000 66086 127760 INFANT & TODDLER CLOTHING & ACCESSORIES ACCESSORIES 0 [empty string] [empty string] 16931-DEFAULT-xs.jpg KIDS shop/patagonia-baby-baggies-cap-127760 0 [empty string] 66086 [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 24
SQL SELECT * from [dbo].[web_all_products] WHERE style_id='127760' order by ID desc