PATAGONIA

Patagonia Women's Micro D 1/4-Zip Fleece

$43.99 to $59.00

Item # 26278

query
RESULTSET
query
  ORIGSIZ QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SKU_ID STYLE_ID
1 XS 28 125745 XS [empty string] 527118 114210
2 S 50 125746 S [empty string] 527119 114210
3 M 53 125747 M [empty string] 527120 114210
4 L 35 125748 L [empty string] 527121 114210
5 XL 16 125749 XL [empty string] 527122 114210
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 26278
2 114210
query
RESULTSET
query
  ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID FAM HEX ORIGATTR1 QOH SIZE SKU_ID SORT_ORDER STYLE_ID
1 GREEN_PIGR [empty string] 133712 [empty string] [empty string] GREEN_PIGR 37 125749 527107 [empty string] 114210
2 NAVY_NENA [empty string] 133714 [empty string] [empty string] NAVY_NENA 37 125749 527117 [empty string] 114210
3 BLK_BLACK [empty string] 133708 [empty string] [empty string] BLK_BLACK 36 125749 447128 [empty string] 114210
4 BALSAMIC_LIT [empty string] 133713 [empty string] [empty string] BALSAMIC_LIT 32 125749 527112 [empty string] 114210
5 SKYBLUE_BSBL [empty string] 133715 [empty string] [empty string] SKYBLUE_BSBL 32 125749 527122 [empty string] 114210
6 Feather Grey Feather Grey 133709 [empty string] [empty string] FEA_GREY 4 125748 447126 [empty string] 114210
7 Navy Blue Navy Blue 133710 [empty string] [empty string] NVYB_BLUE 4 125746 447121 [empty string] 114210
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 114210
Patagonia Women's Micro D 1/4-Zip Fleece GREEN_PIGR Patagonia Women's Micro D 1/4-Zip Fleece NAVY_NENA Patagonia Women's Micro D 1/4-Zip Fleece BLK_BLACK Patagonia Women's Micro D 1/4-Zip Fleece BALSAMIC_LIT Patagonia Women's Micro D 1/4-Zip Fleece SKYBLUE_BSBL Patagonia Women's Micro D 1/4-Zip Fleece FEA_GREY Patagonia Women's Micro D 1/4-Zip Fleece NVYB_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 133708 52794 72-W/S SPORTSWEAR [empty string] 6 125745 447116 98 26278
2 133709 52794 72-W/S SPORTSWEAR [empty string] 2 125745 447117 98 26278
3 133710 52794 72-W/S SPORTSWEAR [empty string] 0 125745 447118 98 26278
4 133708 52794 72-W/S SPORTSWEAR [empty string] 9 125746 447119 98 26278
5 133709 52794 72-W/S SPORTSWEAR [empty string] 1 125746 447120 98 26278
6 133710 52794 72-W/S SPORTSWEAR [empty string] 4 125746 447121 98 26278
7 133708 52794 72-W/S SPORTSWEAR [empty string] 11 125747 447122 98 26278
8 133709 52794 72-W/S SPORTSWEAR [empty string] 0 125747 447123 98 26278
9 133710 52794 72-W/S SPORTSWEAR [empty string] 0 125747 447124 98 26278
10 133708 52794 72-W/S SPORTSWEAR [empty string] 7 125748 447125 98 26278
11 133709 52794 72-W/S SPORTSWEAR [empty string] 2 125748 447126 98 26278
12 133710 52794 72-W/S SPORTSWEAR [empty string] 0 125748 447127 98 26278
13 133708 52794 72-W/S SPORTSWEAR [empty string] 3 125749 447128 98 26278
14 133709 52794 72-W/S SPORTSWEAR [empty string] 0 125749 447129 98 26278
15 133710 52794 72-W/S SPORTSWEAR [empty string] 0 125749 447130 98 26278
16 133711 52794 72-W/S SPORTSWEAR [empty string] 1 125745 488397 98 26278
17 133711 52794 72-W/S SPORTSWEAR [empty string] 0 125746 488398 98 26278
18 133711 52794 72-W/S SPORTSWEAR [empty string] 0 125747 488399 98 26278
19 133711 52794 72-W/S SPORTSWEAR [empty string] 0 125748 488400 98 26278
20 133711 52794 72-W/S SPORTSWEAR [empty string] 0 125749 488401 98 26278
21 133712 52794 72-W/S SPORTSWEAR [empty string] 5 125745 527103 98 26278
22 133712 52794 72-W/S SPORTSWEAR [empty string] 10 125746 527104 98 26278
23 133712 52794 72-W/S SPORTSWEAR [empty string] 11 125747 527105 98 26278
24 133712 52794 72-W/S SPORTSWEAR [empty string] 7 125748 527106 98 26278
25 133712 52794 72-W/S SPORTSWEAR [empty string] 4 125749 527107 98 26278
26 133713 52794 72-W/S SPORTSWEAR [empty string] 5 125745 527108 98 26278
27 133713 52794 72-W/S SPORTSWEAR [empty string] 8 125746 527109 98 26278
28 133713 52794 72-W/S SPORTSWEAR [empty string] 10 125747 527110 98 26278
29 133713 52794 72-W/S SPORTSWEAR [empty string] 6 125748 527111 98 26278
30 133713 52794 72-W/S SPORTSWEAR [empty string] 3 125749 527112 98 26278
31 133714 52794 72-W/S SPORTSWEAR [empty string] 5 125745 527113 98 26278
32 133714 52794 72-W/S SPORTSWEAR [empty string] 10 125746 527114 98 26278
33 133714 52794 72-W/S SPORTSWEAR [empty string] 12 125747 527115 98 26278
34 133714 52794 72-W/S SPORTSWEAR [empty string] 7 125748 527116 98 26278
35 133714 52794 72-W/S SPORTSWEAR [empty string] 3 125749 527117 98 26278
36 133715 52794 72-W/S SPORTSWEAR [empty string] 5 125745 527118 98 26278
37 133715 52794 72-W/S SPORTSWEAR [empty string] 9 125746 527119 98 26278
38 133715 52794 72-W/S SPORTSWEAR [empty string] 9 125747 527120 98 26278
39 133715 52794 72-W/S SPORTSWEAR [empty string] 6 125748 527121 98 26278
40 133715 52794 72-W/S SPORTSWEAR [empty string] 3 125749 527122 98 26278
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 = '26278' ) 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 = 52794 AND isNull(b.sell_web,'Y') = 'Y' GROUP BY b.sku_id ORDER BY b.sku_id
SQLPARAMETERS
array
1 114210
184
Add to Cart Find in Store Add to Wish List

product description

You know that one sweatshirt that can't seem to make it into the laundry because you want to wear it every day? This basic pullover is one. Providing warmth without bulk and an unbound, layerable fit, the Patagonia Women's Micro D 1/4-Zip Fleece is made from Patagonia's lightest-weight polyester microfleece (100% recycled) and styled with princess seams for a contoured fit that layers easily under a shell or over activewear. The Micro D® Fleece's details include a zip-through, high, doubled-fleece stand-up collar and clean-finish detailing throughout.

product specs
  • Made of ultrasoft, quick-drying 100% recycled polyester microfleece
  • Set-in sleeves with raglan overlock stitch detail
  • Hip length
  • Regular fit
  • 187g (6.6oz)
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 ultrasoft, quick-drying 100% recycled polyester microfleece</li> <li>Set-in sleeves with raglan overlock stitch detail</li> <li>Hip length</li> <li>Regular fit</li> <li>187g (6.6oz)</li> </ul> [empty string] [empty string] 60781 BLK_BLACK,GREEN_PIGR,NAVY_NENA,BALSAMIC_LIT,SKYBLUE_BSBL,NVYB_BLUE,FEA_GREY, 52772 PATAGONIA PATAGONIA CLOTHING & FOOTWEAR Clothing & Footwear &gt Women's &gt Tops &gt Hoodies & Sweaters [empty string] [empty string] [empty string] 596 [empty string] 27431773 [empty string] 59 43 43.99 [empty string] 13946-DEFAULT-l.jpg 59 [empty string] 13946-DEFAULT-m.jpg Get warm without the bulk with the ultrasoft Patagonia Women's Micro D 1/4-Zip Fleece. Made with 100% recycled polyester, it's styled with princess seams for a contoured fit that layers easily under a shell or over activewear. [empty string] W/ Micro D 1/4 Zip N NEWATTR [empty string] [empty string] [empty string] [empty string] BTSTFW [empty string] [empty string] LANYARD [empty string] [empty string] A 72B [empty string] [empty string] FALL_3 [empty string] [empty string] PICK ME N PATAGONIA 182 0 [empty string] 13946 13946 25-to-50 0.00 0 [empty string] [empty string] [empty string] Patagonia Women's Micro D 1/4-Zip Fleece <p>You know that one sweatshirt that can&#39;t seem to make it into the laundry because you want to wear it every day? This basic pullover is one. Providing warmth without bulk and an unbound, layerable fit, the Patagonia Women&#39;s Micro D 1/4-Zip Fleece is made from Patagonia&#39;s lightest-weight polyester microfleece (100% recycled) and styled with princess seams for a contoured fit that layers easily under a shell or over activewear. The Micro D&reg; Fleece&#39;s details include a zip-through, high, doubled-fleece stand-up collar and clean-finish detailing throughout.</p> [empty string] Y 43.99 59 44646 0 L,M,S,XL,XS, [empty string] 13946-DEFAULT-s.jpg 1000 26278 114210 TOPS HOODIES & SWEATERS EMPTY 0 [empty string] [empty string] 13946-DEFAULT-xs.jpg WOMENS shop/patagonia-womens-micro-d-1/4-z-114210 0 [empty string] 26278 [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 16
SQL SELECT * from [dbo].[web_all_products] WHERE style_id='114210' order by ID desc