PRANA

prAna Men's Furrow Shorts - 8in

$69.00 $47.9930% off

Item # M3FU08115

query
RESULTSET
query
  ORIGSIZ QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SKU_ID STYLE_ID
1 30 2 5687 30 257 511195 109356
2 33 2 5690 33 273 511206 109356
3 34 9 5691 34 274 511198 109356
4 36 4 5693 36 278 511200 109356
5 38 2 5694 38 285 511201 109356
6 40 2 5695 40 308 476137 109356
CACHED false
EXECUTIONTIME 379
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 M3FU08115
2 109356
query
RESULTSET
query
  ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID FAM HEX ORIGATTR1 QOH SIZE SKU_ID SORT_ORDER STYLE_ID
1 Mud Mud 128768 [empty string] [empty string] MUD 10 5695 476137 [empty string] 109356
2 GRAVEL [empty string] 128770 [empty string] [empty string] GRAVEL 9 5694 511201 [empty string] 109356
3 NORIGRN [empty string] 128771 [empty string] [empty string] NORIGRN 2 5690 511206 [empty string] 109356
CACHED false
EXECUTIONTIME 5
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 109356
prAna Men's Furrow Shorts - 8in MUD GRAVEL NORIGRN
30 33 34 36 38 40
query
RESULTSET
query
  ATTR1_ENTRY_ID ATTR2_ENTRY_ID DEPT PURCHASE_AMOUNT QOH SCALE_ENTRY_ID SKU_ID STORE_ID STYLE
1 128765 49295 71-M/S SPORTSWEAR [empty string] 0 5687 430870 98 M3FU08115
2 128766 49295 71-M/S SPORTSWEAR [empty string] 0 5687 430871 98 M3FU08115
3 128765 49295 71-M/S SPORTSWEAR [empty string] 0 5689 430872 98 M3FU08115
4 128766 49295 71-M/S SPORTSWEAR [empty string] 0 5689 430873 98 M3FU08115
5 128765 49295 71-M/S SPORTSWEAR [empty string] 0 5690 430874 98 M3FU08115
6 128766 49295 71-M/S SPORTSWEAR [empty string] 0 5690 430875 98 M3FU08115
7 128765 49295 71-M/S SPORTSWEAR [empty string] 0 5691 430876 98 M3FU08115
8 128766 49295 71-M/S SPORTSWEAR [empty string] 0 5691 430877 98 M3FU08115
9 128765 49295 71-M/S SPORTSWEAR [empty string] 0 5692 430878 98 M3FU08115
10 128766 49295 71-M/S SPORTSWEAR [empty string] 0 5692 430879 98 M3FU08115
11 128765 49295 71-M/S SPORTSWEAR [empty string] 0 5693 430880 98 M3FU08115
12 128766 49295 71-M/S SPORTSWEAR [empty string] 0 5693 430881 98 M3FU08115
13 128765 49295 71-M/S SPORTSWEAR [empty string] 0 5694 430882 98 M3FU08115
14 128766 49295 71-M/S SPORTSWEAR [empty string] 0 5694 430883 98 M3FU08115
15 128767 49295 71-M/S SPORTSWEAR [empty string] 0 5687 443148 98 M3FU08115
16 128767 49295 71-M/S SPORTSWEAR [empty string] 0 5689 443149 98 M3FU08115
17 128767 49295 71-M/S SPORTSWEAR [empty string] 0 5690 443150 98 M3FU08115
18 128767 49295 71-M/S SPORTSWEAR [empty string] 0 5691 443151 98 M3FU08115
19 128767 49295 71-M/S SPORTSWEAR [empty string] 0 5692 443152 98 M3FU08115
20 128767 49295 71-M/S SPORTSWEAR [empty string] 0 5693 443153 98 M3FU08115
21 128767 49295 71-M/S SPORTSWEAR [empty string] 0 5694 443154 98 M3FU08115
22 128768 49295 71-M/S SPORTSWEAR [empty string] 1 5687 475874 98 M3FU08115
23 128768 49295 71-M/S SPORTSWEAR [empty string] 1 5689 475875 98 M3FU08115
24 128768 49295 71-M/S SPORTSWEAR [empty string] 1 5690 475876 98 M3FU08115
25 128768 49295 71-M/S SPORTSWEAR [empty string] 6 5691 475877 98 M3FU08115
26 128768 49295 71-M/S SPORTSWEAR [empty string] 0 5692 475878 98 M3FU08115
27 128768 49295 71-M/S SPORTSWEAR [empty string] 2 5693 475879 98 M3FU08115
28 128768 49295 71-M/S SPORTSWEAR [empty string] 0 5694 475880 98 M3FU08115
29 128769 49295 71-M/S SPORTSWEAR [empty string] 0 5687 475881 98 M3FU08115
30 128769 49295 71-M/S SPORTSWEAR [empty string] 0 5689 475882 98 M3FU08115
31 128769 49295 71-M/S SPORTSWEAR [empty string] 0 5690 475883 98 M3FU08115
32 128769 49295 71-M/S SPORTSWEAR [empty string] 0 5691 475884 98 M3FU08115
33 128769 49295 71-M/S SPORTSWEAR [empty string] 0 5692 475885 98 M3FU08115
34 128769 49295 71-M/S SPORTSWEAR [empty string] 0 5693 475886 98 M3FU08115
35 128769 49295 71-M/S SPORTSWEAR [empty string] 0 5694 475887 98 M3FU08115
36 128765 49295 71-M/S SPORTSWEAR [empty string] 0 5695 476134 98 M3FU08115
37 128766 49295 71-M/S SPORTSWEAR [empty string] 0 5695 476135 98 M3FU08115
38 128767 49295 71-M/S SPORTSWEAR [empty string] 0 5695 476136 98 M3FU08115
39 128768 49295 71-M/S SPORTSWEAR [empty string] 2 5695 476137 98 M3FU08115
40 128769 49295 71-M/S SPORTSWEAR [empty string] 0 5695 476138 98 M3FU08115
41 128765 49295 71-M/S SPORTSWEAR [empty string] 0 5686 476139 98 M3FU08115
42 128766 49295 71-M/S SPORTSWEAR [empty string] 0 5686 476140 98 M3FU08115
43 128767 49295 71-M/S SPORTSWEAR [empty string] 0 5686 476141 98 M3FU08115
44 128768 49295 71-M/S SPORTSWEAR [empty string] 0 5686 476142 98 M3FU08115
45 128769 49295 71-M/S SPORTSWEAR [empty string] 0 5686 476143 98 M3FU08115
46 128770 49295 71-M/S SPORTSWEAR [empty string] 2 5687 511195 98 M3FU08115
47 128770 49295 71-M/S SPORTSWEAR [empty string] 0 5689 511196 98 M3FU08115
48 128770 49295 71-M/S SPORTSWEAR [empty string] 1 5690 511197 98 M3FU08115
49 128770 49295 71-M/S SPORTSWEAR [empty string] 3 5691 511198 98 M3FU08115
50 128770 49295 71-M/S SPORTSWEAR [empty string] 1 5692 511199 98 M3FU08115
51 128770 49295 71-M/S SPORTSWEAR [empty string] 2 5693 511200 98 M3FU08115
52 128770 49295 71-M/S SPORTSWEAR [empty string] 2 5694 511201 98 M3FU08115
53 128770 49295 71-M/S SPORTSWEAR [empty string] 0 5695 511202 98 M3FU08115
54 128770 49295 71-M/S SPORTSWEAR [empty string] 1 5686 511203 98 M3FU08115
55 128771 49295 71-M/S SPORTSWEAR [empty string] 1 5687 511204 98 M3FU08115
56 128771 49295 71-M/S SPORTSWEAR [empty string] 1 5689 511205 98 M3FU08115
57 128771 49295 71-M/S SPORTSWEAR [empty string] 2 5690 511206 98 M3FU08115
58 128771 49295 71-M/S SPORTSWEAR [empty string] 1 5691 511207 98 M3FU08115
59 128771 49295 71-M/S SPORTSWEAR [empty string] 0 5692 511208 98 M3FU08115
60 128771 49295 71-M/S SPORTSWEAR [empty string] 1 5693 511209 98 M3FU08115
61 128771 49295 71-M/S SPORTSWEAR [empty string] 1 5694 511210 98 M3FU08115
62 128771 49295 71-M/S SPORTSWEAR [empty string] 0 5695 511211 98 M3FU08115
63 128771 49295 71-M/S SPORTSWEAR [empty string] 0 5686 511212 98 M3FU08115
64 128765 49295 71-M/S SPORTSWEAR [empty string] 0 5688 511213 98 M3FU08115
65 128766 49295 71-M/S SPORTSWEAR [empty string] 0 5688 511214 98 M3FU08115
66 128767 49295 71-M/S SPORTSWEAR [empty string] 0 5688 511215 98 M3FU08115
67 128768 49295 71-M/S SPORTSWEAR [empty string] 0 5688 511216 98 M3FU08115
68 128769 49295 71-M/S SPORTSWEAR [empty string] 0 5688 511217 98 M3FU08115
69 128770 49295 71-M/S SPORTSWEAR [empty string] 0 5688 511218 98 M3FU08115
70 128771 49295 71-M/S SPORTSWEAR [empty string] 0 5688 511219 98 M3FU08115
CACHED false
EXECUTIONTIME 16
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 = 'M3FU08115' ) 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 = 49295 AND isNull(b.sell_web,'Y') = 'Y' GROUP BY b.sku_id ORDER BY b.sku_id
SQLPARAMETERS
array
1 109356
32
Add to Cart Find in Store Add to Wish List

product description

The stretchy prAna Men's Furrow Shorts - 8in are stretchy standard fit hemp and recycled polyester blend shorts with plenty of pockets for holding your stuff. Features include natural UPF and odor reducing properties.

product specs
  • Sustainable hemp blend
  • Quarter top pockets
  • Back welt pockets
  • Standard fit
  • 53% Hemp / 44% Recycled Polyester / 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>Sustainable hemp blend</li> <li>Quarter top pockets</li> <li>Back welt pockets</li> <li>Standard fit</li> <li>53% Hemp / 44% Recycled Polyester / 3% Spandex</li> </ul> [empty string] [empty string] 59083 MUD,GRAVEL,NORIGRN, 49273 PRANA PRANA CLOTHING & FOOTWEAR Clothing & Footwear &gt Men's &gt Bottoms &gt Shorts [empty string] [empty string] [empty string] 596 [empty string] 27368295 [empty string] 69 47 47.99 [empty string] 22946-DEFAULT-l.jpg 69 [empty string] 22946-DEFAULT-m.jpg Perfect for patio weather, these hemp blend prAna Men's Furrow Shorts - 8in have plenty of pockets for holding your stuff. Their standard fit, natural UPF and odor reducing properties round out the features. [empty string] M/ Furrow Short 8IN N [empty string] [empty string] [empty string] [empty string] [empty string] BTSTFW [empty string] [empty string] PIN [empty string] [empty string] [empty string] 71G [empty string] [empty string] FALL_3 [empty string] [empty string] [empty string] [empty string] PRANA 20 0 [empty string] 22946 22946 25-to-50 0.00 0 [empty string] [empty string] [empty string] prAna Men's Furrow Shorts - 8in <p>The stretchy prAna Men&#39;s Furrow Shorts - 8in are stretchy standard fit hemp and recycled polyester blend shorts with plenty of pockets for holding your stuff. Features include natural UPF and odor reducing properties.</p> [empty string] Y 47.99 47.99 2178 0 30,33,34,36,38,40, [empty string] 22946-DEFAULT-s.jpg 1000 M3FU08115 109356 BOTTOMS SHORTS EMPTY 0 [empty string] [empty string] 22946-DEFAULT-xs.jpg MENS shop/prana-mens-furrow-shorts---8in-109356 0 [empty string] M3FU08115 [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 6
SQL SELECT * from [dbo].[web_all_products] WHERE style_id='109356' order by ID desc