PRANA

prAna Men's Mojo Shorts

$34.99 to $50.00

Item # M3MOJO110

query
RESULTSET
query
  ORIGSIZ QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SKU_ID STYLE_ID
1 S 3 38531 S [empty string] 316477 84777
2 M 13 38532 M [empty string] 529851 84777
3 L 15 38533 L [empty string] 529852 84777
4 XL 7 38534 XL [empty string] 529853 84777
CACHED false
EXECUTIONTIME 524
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 M3MOJO110
2 84777
query
RESULTSET
query
  ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID FAM HEX ORIGATTR1 QOH SIZE SKU_ID SORT_ORDER STYLE_ID
1 BLACK [empty string] 134617 [empty string] [empty string] BLACK 21 38534 316492 [empty string] 84777
2 BLKTIDE [empty string] 134634 [empty string] [empty string] BLKTIDE 15 38534 529853 [empty string] 84777
3 COAL [empty string] 134631 [empty string] [empty string] COAL 2 38533 493269 [empty string] 84777
CACHED false
EXECUTIONTIME 4
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 84777
prAna Men's Mojo Shorts BLACK prAna Men's Mojo Shorts BLKTIDE prAna Men's Mojo Shorts COAL
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 134615 29568 71-M/S SPORTSWEAR [empty string] 0 38531 316475 98 M3MOJO110
2 134616 29568 71-M/S SPORTSWEAR [empty string] 0 38531 316476 98 M3MOJO110
3 134617 29568 71-M/S SPORTSWEAR [empty string] 3 38531 316477 98 M3MOJO110
4 134618 29568 71-M/S SPORTSWEAR [empty string] 0 38531 316478 98 M3MOJO110
5 134619 29568 71-M/S SPORTSWEAR [empty string] 0 38531 316479 98 M3MOJO110
6 134615 29568 71-M/S SPORTSWEAR [empty string] 0 38532 316480 98 M3MOJO110
7 134616 29568 71-M/S SPORTSWEAR [empty string] 0 38532 316481 98 M3MOJO110
8 134617 29568 71-M/S SPORTSWEAR [empty string] 8 38532 316482 98 M3MOJO110
9 134618 29568 71-M/S SPORTSWEAR [empty string] 0 38532 316483 98 M3MOJO110
10 134619 29568 71-M/S SPORTSWEAR [empty string] 0 38532 316484 98 M3MOJO110
11 134615 29568 71-M/S SPORTSWEAR [empty string] 0 38533 316485 98 M3MOJO110
12 134616 29568 71-M/S SPORTSWEAR [empty string] 0 38533 316486 98 M3MOJO110
13 134617 29568 71-M/S SPORTSWEAR [empty string] 5 38533 316487 98 M3MOJO110
14 134618 29568 71-M/S SPORTSWEAR [empty string] 0 38533 316488 98 M3MOJO110
15 134619 29568 71-M/S SPORTSWEAR [empty string] 0 38533 316489 98 M3MOJO110
16 134615 29568 71-M/S SPORTSWEAR [empty string] 0 38534 316490 98 M3MOJO110
17 134616 29568 71-M/S SPORTSWEAR [empty string] 0 38534 316491 98 M3MOJO110
18 134617 29568 71-M/S SPORTSWEAR [empty string] 5 38534 316492 98 M3MOJO110
19 134618 29568 71-M/S SPORTSWEAR [empty string] 0 38534 316493 98 M3MOJO110
20 134619 29568 71-M/S SPORTSWEAR [empty string] 0 38534 316494 98 M3MOJO110
21 134615 29568 71-M/S SPORTSWEAR [empty string] 0 38535 316495 98 M3MOJO110
22 134616 29568 71-M/S SPORTSWEAR [empty string] 0 38535 316496 98 M3MOJO110
23 134617 29568 71-M/S SPORTSWEAR [empty string] 1 38535 316497 98 M3MOJO110
24 134618 29568 71-M/S SPORTSWEAR [empty string] 0 38535 316498 98 M3MOJO110
25 134619 29568 71-M/S SPORTSWEAR [empty string] 0 38535 316499 98 M3MOJO110
26 134620 29568 71-M/S SPORTSWEAR [empty string] 0 38531 325931 98 M3MOJO110
27 134620 29568 71-M/S SPORTSWEAR [empty string] 0 38532 325932 98 M3MOJO110
28 134620 29568 71-M/S SPORTSWEAR [empty string] 0 38533 325933 98 M3MOJO110
29 134620 29568 71-M/S SPORTSWEAR [empty string] 0 38534 325934 98 M3MOJO110
30 134620 29568 71-M/S SPORTSWEAR [empty string] 0 38535 325935 98 M3MOJO110
31 134621 29568 71-M/S SPORTSWEAR [empty string] 0 38531 347737 98 M3MOJO110
32 134621 29568 71-M/S SPORTSWEAR [empty string] 0 38532 347738 98 M3MOJO110
33 134621 29568 71-M/S SPORTSWEAR [empty string] 0 38533 347739 98 M3MOJO110
34 134621 29568 71-M/S SPORTSWEAR [empty string] 0 38534 347740 98 M3MOJO110
35 134621 29568 71-M/S SPORTSWEAR [empty string] 0 38535 347741 98 M3MOJO110
36 134622 29568 71-M/S SPORTSWEAR [empty string] 0 38531 347742 98 M3MOJO110
37 134622 29568 71-M/S SPORTSWEAR [empty string] 0 38532 347743 98 M3MOJO110
38 134622 29568 71-M/S SPORTSWEAR [empty string] 0 38533 347744 98 M3MOJO110
39 134622 29568 71-M/S SPORTSWEAR [empty string] 0 38534 347745 98 M3MOJO110
40 134622 29568 71-M/S SPORTSWEAR [empty string] 0 38535 347746 98 M3MOJO110
41 134623 29568 71-M/S SPORTSWEAR [empty string] 0 38531 347747 98 M3MOJO110
42 134623 29568 71-M/S SPORTSWEAR [empty string] 0 38532 347748 98 M3MOJO110
43 134623 29568 71-M/S SPORTSWEAR [empty string] 0 38533 347749 98 M3MOJO110
44 134623 29568 71-M/S SPORTSWEAR [empty string] 0 38534 347750 98 M3MOJO110
45 134623 29568 71-M/S SPORTSWEAR [empty string] 0 38535 347751 98 M3MOJO110
46 134624 29568 71-M/S SPORTSWEAR [empty string] 0 38531 347752 98 M3MOJO110
47 134624 29568 71-M/S SPORTSWEAR [empty string] 0 38532 347753 98 M3MOJO110
48 134624 29568 71-M/S SPORTSWEAR [empty string] 0 38533 347754 98 M3MOJO110
49 134624 29568 71-M/S SPORTSWEAR [empty string] 0 38534 347755 98 M3MOJO110
50 134624 29568 71-M/S SPORTSWEAR [empty string] 0 38535 347756 98 M3MOJO110
51 134615 29568 71-M/S SPORTSWEAR [empty string] 0 38530 347757 98 M3MOJO110
52 134616 29568 71-M/S SPORTSWEAR [empty string] 0 38530 347758 98 M3MOJO110
53 134617 29568 71-M/S SPORTSWEAR [empty string] 0 38530 347759 98 M3MOJO110
54 134618 29568 71-M/S SPORTSWEAR [empty string] 0 38530 347760 98 M3MOJO110
55 134619 29568 71-M/S SPORTSWEAR [empty string] 0 38530 347761 98 M3MOJO110
56 134620 29568 71-M/S SPORTSWEAR [empty string] 0 38530 347762 98 M3MOJO110
57 134621 29568 71-M/S SPORTSWEAR [empty string] 0 38530 347763 98 M3MOJO110
58 134622 29568 71-M/S SPORTSWEAR [empty string] 0 38530 347764 98 M3MOJO110
59 134623 29568 71-M/S SPORTSWEAR [empty string] 0 38530 347765 98 M3MOJO110
60 134624 29568 71-M/S SPORTSWEAR [empty string] 0 38530 347766 98 M3MOJO110
61 134625 29568 71-M/S SPORTSWEAR [empty string] 0 38530 371159 98 M3MOJO110
62 134625 29568 71-M/S SPORTSWEAR [empty string] 0 38531 371160 98 M3MOJO110
63 134625 29568 71-M/S SPORTSWEAR [empty string] 0 38532 371161 98 M3MOJO110
64 134625 29568 71-M/S SPORTSWEAR [empty string] 0 38533 371162 98 M3MOJO110
65 134625 29568 71-M/S SPORTSWEAR [empty string] 0 38534 371163 98 M3MOJO110
66 134625 29568 71-M/S SPORTSWEAR [empty string] 0 38535 371164 98 M3MOJO110
67 134626 29568 71-M/S SPORTSWEAR [empty string] 0 38530 393442 98 M3MOJO110
68 134626 29568 71-M/S SPORTSWEAR [empty string] 0 38531 393443 98 M3MOJO110
69 134626 29568 71-M/S SPORTSWEAR [empty string] 0 38532 393444 98 M3MOJO110
70 134626 29568 71-M/S SPORTSWEAR [empty string] 0 38533 393445 98 M3MOJO110
71 134626 29568 71-M/S SPORTSWEAR [empty string] 0 38534 393446 98 M3MOJO110
72 134626 29568 71-M/S SPORTSWEAR [empty string] 0 38535 393447 98 M3MOJO110
73 134627 29568 71-M/S SPORTSWEAR [empty string] 0 38530 415968 98 M3MOJO110
74 134627 29568 71-M/S SPORTSWEAR [empty string] 0 38531 415969 98 M3MOJO110
75 134627 29568 71-M/S SPORTSWEAR [empty string] 0 38532 415970 98 M3MOJO110
76 134627 29568 71-M/S SPORTSWEAR [empty string] 0 38533 415971 98 M3MOJO110
77 134627 29568 71-M/S SPORTSWEAR [empty string] 0 38534 415972 98 M3MOJO110
78 134627 29568 71-M/S SPORTSWEAR [empty string] 0 38535 415973 98 M3MOJO110
79 134628 29568 71-M/S SPORTSWEAR [empty string] 0 38530 430673 98 M3MOJO110
80 134628 29568 71-M/S SPORTSWEAR [empty string] 0 38531 430674 98 M3MOJO110
81 134628 29568 71-M/S SPORTSWEAR [empty string] 0 38532 430675 98 M3MOJO110
82 134628 29568 71-M/S SPORTSWEAR [empty string] 0 38533 430676 98 M3MOJO110
83 134628 29568 71-M/S SPORTSWEAR [empty string] 0 38534 430677 98 M3MOJO110
84 134628 29568 71-M/S SPORTSWEAR [empty string] 0 38535 430678 98 M3MOJO110
85 134629 29568 71-M/S SPORTSWEAR [empty string] 0 38530 430679 98 M3MOJO110
86 134629 29568 71-M/S SPORTSWEAR [empty string] 0 38531 430680 98 M3MOJO110
87 134629 29568 71-M/S SPORTSWEAR [empty string] 0 38532 430681 98 M3MOJO110
88 134629 29568 71-M/S SPORTSWEAR [empty string] 0 38533 430682 98 M3MOJO110
89 134629 29568 71-M/S SPORTSWEAR [empty string] 0 38534 430683 98 M3MOJO110
90 134629 29568 71-M/S SPORTSWEAR [empty string] 0 38535 430684 98 M3MOJO110
91 134630 29568 71-M/S SPORTSWEAR [empty string] 0 38530 430685 98 M3MOJO110
92 134630 29568 71-M/S SPORTSWEAR [empty string] 0 38531 430686 98 M3MOJO110
93 134630 29568 71-M/S SPORTSWEAR [empty string] 0 38532 430687 98 M3MOJO110
94 134630 29568 71-M/S SPORTSWEAR [empty string] 0 38533 430688 98 M3MOJO110
95 134630 29568 71-M/S SPORTSWEAR [empty string] 0 38534 430689 98 M3MOJO110
96 134630 29568 71-M/S SPORTSWEAR [empty string] 0 38535 430690 98 M3MOJO110
97 134631 29568 71-M/S SPORTSWEAR [empty string] 0 38530 493266 98 M3MOJO110
98 134631 29568 71-M/S SPORTSWEAR [empty string] 0 38531 493267 98 M3MOJO110
99 134631 29568 71-M/S SPORTSWEAR [empty string] 0 38532 493268 98 M3MOJO110
100 134631 29568 71-M/S SPORTSWEAR [empty string] 2 38533 493269 98 M3MOJO110
101 134631 29568 71-M/S SPORTSWEAR [empty string] 1 38534 493270 98 M3MOJO110
102 134631 29568 71-M/S SPORTSWEAR [empty string] 0 38535 493271 98 M3MOJO110
103 134632 29568 71-M/S SPORTSWEAR [empty string] 0 38530 493272 98 M3MOJO110
104 134632 29568 71-M/S SPORTSWEAR [empty string] 0 38531 493273 98 M3MOJO110
105 134632 29568 71-M/S SPORTSWEAR [empty string] 0 38532 493274 98 M3MOJO110
106 134632 29568 71-M/S SPORTSWEAR [empty string] 0 38533 493275 98 M3MOJO110
107 134632 29568 71-M/S SPORTSWEAR [empty string] 0 38534 493276 98 M3MOJO110
108 134632 29568 71-M/S SPORTSWEAR [empty string] 0 38535 493277 98 M3MOJO110
109 134634 29568 71-M/S SPORTSWEAR [empty string] 1 38531 529850 98 M3MOJO110
110 134634 29568 71-M/S SPORTSWEAR [empty string] 5 38532 529851 98 M3MOJO110
111 134634 29568 71-M/S SPORTSWEAR [empty string] 8 38533 529852 98 M3MOJO110
112 134634 29568 71-M/S SPORTSWEAR [empty string] 2 38534 529853 98 M3MOJO110
113 134634 29568 71-M/S SPORTSWEAR [empty string] 0 38535 529854 98 M3MOJO110
CACHED false
EXECUTIONTIME 37
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 = 'M3MOJO110' ) 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 = 29568 AND isNull(b.sell_web,'Y') = 'Y' GROUP BY b.sku_id ORDER BY b.sku_id
SQLPARAMETERS
array
1 84777
41
Add to Cart Find in Store Add to Wish List

product description The prAna Men's Mojo Shorts are cut from a recycled microfiber fabric that is quick drying for intense workouts and features UPF 50+ for sun protection. These active shorts are designed with a plush elastic waistband for comfort and a full inseam gusset for durability. The Mojo Shorts are complete with mesh-lined front pockets and a back patch pocket with a pull tab velcro closure.
product specs
  • Recycled polyester microfiber fabric
  • Plush elastic waistband
  • Full inseam gusset
  • Back patch pocket with pull tab Velcro closure
  • Mesh-lined front pockets
  • Quick drying
  • Inseam: 10in (25.4cm) = size M
  • Standard fit
  • 100% recycled polyester
  • UPF 50+

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 <li>Recycled polyester microfiber fabric</li> <li>Plush elastic waistband</li> <li>Full inseam gusset</li> <li>Back patch pocket with pull tab Velcro closure</li> <li>Mesh-lined front pockets</li> <li>Quick drying</li> <li>Inseam: 10in (25.4cm) = size M</li> <li>Standard fit</li> <li>100% recycled polyester</li> <li>UPF 50+</li> [empty string] [empty string] 61021 BLACK,BLKTIDE,COAL, 29554 PRANA PRANA DISCOVER Discover &gt Gifts For [empty string] [empty string] [empty string] 596 [empty string] 27377413 [empty string] 50 34 34.99 [empty string] 14621-DEFAULT-l.jpg 50 [empty string] 14621-DEFAULT-m.jpg Push yourself further during intense workouts with some prAna Men's Mojo Shorts. They're cut from a recycled microfiber fabric that is quick drying with UPF 50+ for sun protection. [empty string] M/Mojo Short N NEWATTR [empty string] [empty string] [empty string] [empty string] BTSTFW [empty string] [empty string] PIN [empty string] [empty string] A 71I [empty string] [empty string] FALL_3 [empty string] [empty string] [empty string] N PRANA 38 0 [empty string] 14621 14621 25-to-50 0.00 0 [empty string] [empty string] [empty string] prAna Men's Mojo Shorts The prAna Men&#39;s Mojo Shorts are cut from a recycled microfiber fabric that is quick drying for intense workouts and features UPF 50+ for sun protection. These active shorts are designed with a plush elastic waistband for comfort and a full inseam gusset for durability. The Mojo Shorts are complete with mesh-lined front pockets and a back patch pocket with a pull tab velcro closure. [empty string] Y 34.99 50 12775 0 L,M,S,XL, [empty string] 14621-DEFAULT-s.jpg 1000 M3MOJO110 84777 EMPTY EMPTY EMPTY 0 [empty string] [empty string] 14621-DEFAULT-xs.jpg GIFTS FOR shop/prana-mens-mojo-shorts-84777 0 [empty string] M3MOJO110 [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 5
SQL SELECT * from [dbo].[web_all_products] WHERE style_id='84777' order by ID desc