PRANA

prAna Women's Halle Pants - Regular 32in Inseam

$49.99 to $85.00

Item # W4HARG113

query
RESULTSET
query
  ORIGSIZ QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SKU_ID STYLE_ID
1 6 15 125809 6 [empty string] 315599 84665
2 8 13 125810 8 [empty string] 315601 84665
3 0 9 125806 0 31 315593 84665
4 10 11 125811 10 88 315603 84665
5 12 11 125812 12 125 315605 84665
6 14 12 125813 14 145 315607 84665
7 16 10 125814 16 154 447279 84665
8 18 2 125815 18 161 447286 84665
9 2 10 125807 2 177 315595 84665
10 4 14 125808 4 294 315597 84665
CACHED false
EXECUTIONTIME 388
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 W4HARG113
2 84665
query
RESULTSET
query
  ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID FAM HEX ORIGATTR1 QOH SIZE SKU_ID SORT_ORDER STYLE_ID
1 Dark Khaki Dark Khaki 134233 [empty string] [empty string] DKKHAKI 53 125814 447278 [empty string] 84665
2 Coal Coal 134234 [empty string] [empty string] COAL 52 125814 447279 [empty string] 84665
3 BLACK [empty string] 134235 [empty string] [empty string] BLACK 2 125815 447286 [empty string] 84665
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 84665
prAna Women's Halle Pants - Regular 32in Inseam DKKHAKI prAna Women's Halle Pants - Regular 32in Inseam COAL prAna Women's Halle Pants - Regular 32in Inseam BLACK
6 8 0 10 12 14 16 18 2 4
query
RESULTSET
query
  ATTR1_ENTRY_ID ATTR2_ENTRY_ID DEPT PURCHASE_AMOUNT QOH SCALE_ENTRY_ID SKU_ID STORE_ID STYLE
1 134233 29488 72-W/S SPORTSWEAR [empty string] 4 125806 315592 98 W4HARG113
2 134234 29488 72-W/S SPORTSWEAR [empty string] 5 125806 315593 98 W4HARG113
3 134233 29488 72-W/S SPORTSWEAR [empty string] 6 125807 315594 98 W4HARG113
4 134234 29488 72-W/S SPORTSWEAR [empty string] 4 125807 315595 98 W4HARG113
5 134233 29488 72-W/S SPORTSWEAR [empty string] 9 125808 315596 98 W4HARG113
6 134234 29488 72-W/S SPORTSWEAR [empty string] 5 125808 315597 98 W4HARG113
7 134233 29488 72-W/S SPORTSWEAR [empty string] 3 125809 315598 98 W4HARG113
8 134234 29488 72-W/S SPORTSWEAR [empty string] 12 125809 315599 98 W4HARG113
9 134233 29488 72-W/S SPORTSWEAR [empty string] 8 125810 315600 98 W4HARG113
10 134234 29488 72-W/S SPORTSWEAR [empty string] 5 125810 315601 98 W4HARG113
11 134233 29488 72-W/S SPORTSWEAR [empty string] 6 125811 315602 98 W4HARG113
12 134234 29488 72-W/S SPORTSWEAR [empty string] 5 125811 315603 98 W4HARG113
13 134233 29488 72-W/S SPORTSWEAR [empty string] 6 125812 315604 98 W4HARG113
14 134234 29488 72-W/S SPORTSWEAR [empty string] 5 125812 315605 98 W4HARG113
15 134233 29488 72-W/S SPORTSWEAR [empty string] 6 125813 315606 98 W4HARG113
16 134234 29488 72-W/S SPORTSWEAR [empty string] 6 125813 315607 98 W4HARG113
17 134235 29488 72-W/S SPORTSWEAR [empty string] 0 125806 370940 98 W4HARG113
18 134235 29488 72-W/S SPORTSWEAR [empty string] 0 125807 370941 98 W4HARG113
19 134235 29488 72-W/S SPORTSWEAR [empty string] 0 125808 370942 98 W4HARG113
20 134235 29488 72-W/S SPORTSWEAR [empty string] 0 125809 370943 98 W4HARG113
21 134235 29488 72-W/S SPORTSWEAR [empty string] 0 125810 370944 98 W4HARG113
22 134235 29488 72-W/S SPORTSWEAR [empty string] 0 125811 370945 98 W4HARG113
23 134235 29488 72-W/S SPORTSWEAR [empty string] 0 125812 370946 98 W4HARG113
24 134235 29488 72-W/S SPORTSWEAR [empty string] 0 125813 370947 98 W4HARG113
25 134236 29488 72-W/S SPORTSWEAR [empty string] 0 125806 415632 98 W4HARG113
26 134236 29488 72-W/S SPORTSWEAR [empty string] 0 125807 415633 98 W4HARG113
27 134236 29488 72-W/S SPORTSWEAR [empty string] 0 125808 415634 98 W4HARG113
28 134236 29488 72-W/S SPORTSWEAR [empty string] 0 125809 415635 98 W4HARG113
29 134236 29488 72-W/S SPORTSWEAR [empty string] 0 125810 415636 98 W4HARG113
30 134236 29488 72-W/S SPORTSWEAR [empty string] 0 125811 415637 98 W4HARG113
31 134236 29488 72-W/S SPORTSWEAR [empty string] 0 125812 415638 98 W4HARG113
32 134236 29488 72-W/S SPORTSWEAR [empty string] 0 125813 415639 98 W4HARG113
33 134237 29488 72-W/S SPORTSWEAR [empty string] 0 125806 430950 98 W4HARG113
34 134237 29488 72-W/S SPORTSWEAR [empty string] 0 125807 430951 98 W4HARG113
35 134237 29488 72-W/S SPORTSWEAR [empty string] 0 125808 430952 98 W4HARG113
36 134237 29488 72-W/S SPORTSWEAR [empty string] 0 125809 430953 98 W4HARG113
37 134237 29488 72-W/S SPORTSWEAR [empty string] 0 125810 430954 98 W4HARG113
38 134237 29488 72-W/S SPORTSWEAR [empty string] 0 125811 430955 98 W4HARG113
39 134237 29488 72-W/S SPORTSWEAR [empty string] 0 125812 430956 98 W4HARG113
40 134237 29488 72-W/S SPORTSWEAR [empty string] 0 125813 430957 98 W4HARG113
41 134238 29488 72-W/S SPORTSWEAR [empty string] 0 125806 447181 98 W4HARG113
42 134238 29488 72-W/S SPORTSWEAR [empty string] 0 125807 447182 98 W4HARG113
43 134238 29488 72-W/S SPORTSWEAR [empty string] 0 125808 447183 98 W4HARG113
44 134238 29488 72-W/S SPORTSWEAR [empty string] 0 125809 447184 98 W4HARG113
45 134238 29488 72-W/S SPORTSWEAR [empty string] 0 125810 447185 98 W4HARG113
46 134238 29488 72-W/S SPORTSWEAR [empty string] 1 125811 447186 98 W4HARG113
47 134238 29488 72-W/S SPORTSWEAR [empty string] 0 125812 447187 98 W4HARG113
48 134238 29488 72-W/S SPORTSWEAR [empty string] 0 125813 447188 98 W4HARG113
49 134233 29488 72-W/S SPORTSWEAR [empty string] 5 125814 447278 98 W4HARG113
50 134234 29488 72-W/S SPORTSWEAR [empty string] 5 125814 447279 98 W4HARG113
51 134235 29488 72-W/S SPORTSWEAR [empty string] 1 125814 447280 98 W4HARG113
52 134236 29488 72-W/S SPORTSWEAR [empty string] 0 125814 447281 98 W4HARG113
53 134237 29488 72-W/S SPORTSWEAR [empty string] 0 125814 447282 98 W4HARG113
54 134238 29488 72-W/S SPORTSWEAR [empty string] 1 125814 447283 98 W4HARG113
55 134233 29488 72-W/S SPORTSWEAR [empty string] 0 125815 447284 98 W4HARG113
56 134234 29488 72-W/S SPORTSWEAR [empty string] 0 125815 447285 98 W4HARG113
57 134235 29488 72-W/S SPORTSWEAR [empty string] 2 125815 447286 98 W4HARG113
58 134236 29488 72-W/S SPORTSWEAR [empty string] 0 125815 447287 98 W4HARG113
59 134237 29488 72-W/S SPORTSWEAR [empty string] 0 125815 447288 98 W4HARG113
60 134238 29488 72-W/S SPORTSWEAR [empty string] 1 125815 447289 98 W4HARG113
61 134239 29488 72-W/S SPORTSWEAR [empty string] 0 125806 492964 98 W4HARG113
62 134239 29488 72-W/S SPORTSWEAR [empty string] 0 125807 492965 98 W4HARG113
63 134239 29488 72-W/S SPORTSWEAR [empty string] 0 125808 492966 98 W4HARG113
64 134239 29488 72-W/S SPORTSWEAR [empty string] 0 125809 492967 98 W4HARG113
65 134239 29488 72-W/S SPORTSWEAR [empty string] 0 125810 492968 98 W4HARG113
66 134239 29488 72-W/S SPORTSWEAR [empty string] 0 125811 492969 98 W4HARG113
67 134239 29488 72-W/S SPORTSWEAR [empty string] 0 125812 492970 98 W4HARG113
68 134239 29488 72-W/S SPORTSWEAR [empty string] 0 125813 492971 98 W4HARG113
69 134239 29488 72-W/S SPORTSWEAR [empty string] 0 125814 492972 98 W4HARG113
70 134239 29488 72-W/S SPORTSWEAR [empty string] 0 125815 492973 98 W4HARG113
71 134240 29488 72-W/S SPORTSWEAR [empty string] 0 125806 528695 98 W4HARG113
72 134240 29488 72-W/S SPORTSWEAR [empty string] 0 125807 528696 98 W4HARG113
73 134240 29488 72-W/S SPORTSWEAR [empty string] 0 125808 528697 98 W4HARG113
74 134240 29488 72-W/S SPORTSWEAR [empty string] 0 125809 528698 98 W4HARG113
75 134240 29488 72-W/S SPORTSWEAR [empty string] 0 125810 528699 98 W4HARG113
76 134240 29488 72-W/S SPORTSWEAR [empty string] 0 125811 528700 98 W4HARG113
77 134240 29488 72-W/S SPORTSWEAR [empty string] 0 125812 528701 98 W4HARG113
78 134240 29488 72-W/S SPORTSWEAR [empty string] 0 125813 528702 98 W4HARG113
79 134240 29488 72-W/S SPORTSWEAR [empty string] 0 125814 528703 98 W4HARG113
80 134240 29488 72-W/S SPORTSWEAR [empty string] 0 125815 528704 98 W4HARG113
CACHED false
EXECUTIONTIME 33
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 = 'W4HARG113' ) 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 = 29488 AND isNull(b.sell_web,'Y') = 'Y' GROUP BY b.sku_id ORDER BY b.sku_id
SQLPARAMETERS
array
1 84665
111
Add to Cart Find in Store Add to Wish List

product description

From countryside to mountainside, the prAna Women's Halle Pants - Regular 32in inseam will be right at home no matter where your lifestyle takes you. Made from prAna's Stretch Zion fabric, these durable, water-resistant roll-up pants are prepared for just about anything, be it hiking, climbing, travel or even the office.

product specs
  • Stretch Zion performance woven fabric with durable water repellent (DWR) finish
  • Cross-functional pant
  • Quick dry
  • Trouser styling with button front fly
  • Articulated knees
  • Roll-up leg feature
  • Hidden zip stash pocket at upper right leg
  • Relaxed fit
  • Straight leg
  • Mid-rise
  • UPF 50+
  • Inseam: Regular 32in (81.3cm)
  • 97% Nylon, 3% Spandex
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>Stretch Zion performance woven fabric with durable water repellent (DWR) finish</li> <li>Cross-functional pant</li> <li>Quick dry</li> <li>Trouser styling with button front fly</li> <li>Articulated knees</li> <li>Roll-up leg feature</li> <li>Hidden zip stash pocket at upper right leg</li> <li>Relaxed fit</li> <li>Straight leg</li> <li>Mid-rise</li> <li>UPF 50+</li> <li>Inseam: Regular 32in (81.3cm)</li> <li>97% Nylon, 3% Spandex</li> </ul> [empty string] [empty string] 60926 DKKHAKI,COAL,BLACK, 29474 PRANA PRANA CLOTHING & FOOTWEAR Clothing & Footwear &gt Women's [empty string] [empty string] [empty string] 596 [empty string] 27365754 [empty string] 85 49 49.99 roll-up, rollup 11362-DEFAULT-l.jpg 85 [empty string] 11362-DEFAULT-m.jpg Take the prAna Women's Halle Pants - Regular 32in inseam anywhere! From countryside to mountainside, they're built to handle it all. [empty string] W/ Halle Roll-Up Pant 32in N NEWATTR [empty string] [empty string] [empty string] [empty string] BTSTFW [empty string] [empty string] PIN [empty string] [empty string] A 72D [empty string] [empty string] FALL_3 [empty string] [empty string] PICK ME N PRANA 106 0 [empty string] 11362 11362 25-to-50 0.00 0 [empty string] [empty string] [empty string] prAna Women's Halle Pants - Regular 32in Inseam <p>From countryside to mountainside, the prAna Women&#39;s Halle Pants - Regular 32in inseam will be right at home no matter where your lifestyle takes you. Made from prAna&#39;s Stretch Zion fabric, these durable, water-resistant roll-up pants are prepared for just about anything, be it hiking, climbing, travel or even the office.</p> [empty string] Y 49.99 85 44658 0 0,10,12,14,16,18,2,4,6,8, [empty string] 11362-DEFAULT-s.jpg 1000 W4HARG113 84665 EMPTY EMPTY EMPTY 0 [empty string] [empty string] 11362-DEFAULT-xs.jpg WOMENS shop/prana-womens-halle-pants---reg-84665 0 [empty string] W4HARG113 [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 9
SQL SELECT * from [dbo].[web_all_products] WHERE style_id='84665' order by ID desc