KUHL

KUHL Men's Renegade Shorts - 10in

$59.99 to $75.00

Item # 5121 10

query
RESULTSET
query
  ORIGSIZ QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SKU_ID STYLE_ID
1 30 9 117037 30 257 509765 108180
2 31 2 117038 31 264 509766 108180
3 32 9 117039 32 265 509767 108180
4 33 10 117040 33 273 509768 108180
5 34 13 117041 34 274 509769 108180
6 35 6 117042 35 275 509770 108180
7 36 15 117043 36 278 509771 108180
8 38 8 117044 38 285 509772 108180
9 40 6 117045 40 308 509773 108180
CACHED false
EXECUTIONTIME 534
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 5121 10
2 108180
query
RESULTSET
query
  ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID FAM HEX ORIGATTR1 QOH SIZE SKU_ID SORT_ORDER STYLE_ID
1 KHAKI [empty string] 128315 [empty string] [empty string] KHAKI 38 117045 509773 [empty string] 108180
2 Pewter Pewter 128313 [empty string] [empty string] PEWTER 38 117045 473459 [empty string] 108180
3 Brushed Nickel Brushed Nickel 128310 [empty string] [empty string] BRUSHNICK 2 117045 424392 [empty string] 108180
CACHED false
EXECUTIONTIME 8
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 108180
KUHL Men's Renegade Shorts - 10in KHAKI KUHL Men's Renegade Shorts - 10in PEWTER KUHL Men's Renegade Shorts - 10in BRUSHNICK
30 31 32 33 34 35 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 128309 48428 71-M/S SPORTSWEAR [empty string] 0 117037 424367 98 5121 10
2 128310 48428 71-M/S SPORTSWEAR [empty string] 1 117037 424368 98 5121 10
3 128311 48428 71-M/S SPORTSWEAR [empty string] 0 117037 424369 98 5121 10
4 128309 48428 71-M/S SPORTSWEAR [empty string] 0 117038 424370 98 5121 10
5 128310 48428 71-M/S SPORTSWEAR [empty string] 0 117038 424371 98 5121 10
6 128311 48428 71-M/S SPORTSWEAR [empty string] 0 117038 424372 98 5121 10
7 128309 48428 71-M/S SPORTSWEAR [empty string] 0 117039 424373 98 5121 10
8 128310 48428 71-M/S SPORTSWEAR [empty string] 1 117039 424374 98 5121 10
9 128311 48428 71-M/S SPORTSWEAR [empty string] 0 117039 424375 98 5121 10
10 128309 48428 71-M/S SPORTSWEAR [empty string] 0 117040 424376 98 5121 10
11 128310 48428 71-M/S SPORTSWEAR [empty string] 1 117040 424377 98 5121 10
12 128311 48428 71-M/S SPORTSWEAR [empty string] 0 117040 424378 98 5121 10
13 128309 48428 71-M/S SPORTSWEAR [empty string] 0 117041 424379 98 5121 10
14 128310 48428 71-M/S SPORTSWEAR [empty string] 0 117041 424380 98 5121 10
15 128311 48428 71-M/S SPORTSWEAR [empty string] 0 117041 424381 98 5121 10
16 128309 48428 71-M/S SPORTSWEAR [empty string] 0 117042 424382 98 5121 10
17 128310 48428 71-M/S SPORTSWEAR [empty string] 0 117042 424383 98 5121 10
18 128311 48428 71-M/S SPORTSWEAR [empty string] 0 117042 424384 98 5121 10
19 128309 48428 71-M/S SPORTSWEAR [empty string] 0 117043 424385 98 5121 10
20 128310 48428 71-M/S SPORTSWEAR [empty string] 0 117043 424386 98 5121 10
21 128311 48428 71-M/S SPORTSWEAR [empty string] 0 117043 424387 98 5121 10
22 128309 48428 71-M/S SPORTSWEAR [empty string] 0 117044 424388 98 5121 10
23 128310 48428 71-M/S SPORTSWEAR [empty string] -1 117044 424389 98 5121 10
24 128311 48428 71-M/S SPORTSWEAR [empty string] 0 117044 424390 98 5121 10
25 128309 48428 71-M/S SPORTSWEAR [empty string] 0 117045 424391 98 5121 10
26 128310 48428 71-M/S SPORTSWEAR [empty string] 2 117045 424392 98 5121 10
27 128311 48428 71-M/S SPORTSWEAR [empty string] 0 117045 424393 98 5121 10
28 128312 48428 71-M/S SPORTSWEAR [empty string] 1 117037 464991 98 5121 10
29 128312 48428 71-M/S SPORTSWEAR [empty string] 0 117038 464992 98 5121 10
30 128312 48428 71-M/S SPORTSWEAR [empty string] 0 117039 464993 98 5121 10
31 128312 48428 71-M/S SPORTSWEAR [empty string] 0 117040 464994 98 5121 10
32 128312 48428 71-M/S SPORTSWEAR [empty string] 0 117041 464995 98 5121 10
33 128312 48428 71-M/S SPORTSWEAR [empty string] 0 117042 464996 98 5121 10
34 128312 48428 71-M/S SPORTSWEAR [empty string] 0 117043 464997 98 5121 10
35 128312 48428 71-M/S SPORTSWEAR [empty string] 0 117044 464998 98 5121 10
36 128312 48428 71-M/S SPORTSWEAR [empty string] 0 117045 464999 98 5121 10
37 128313 48428 71-M/S SPORTSWEAR [empty string] 4 117037 473451 98 5121 10
38 128313 48428 71-M/S SPORTSWEAR [empty string] 1 117038 473452 98 5121 10
39 128313 48428 71-M/S SPORTSWEAR [empty string] 4 117039 473453 98 5121 10
40 128313 48428 71-M/S SPORTSWEAR [empty string] 5 117040 473454 98 5121 10
41 128313 48428 71-M/S SPORTSWEAR [empty string] 8 117041 473455 98 5121 10
42 128313 48428 71-M/S SPORTSWEAR [empty string] 4 117042 473456 98 5121 10
43 128313 48428 71-M/S SPORTSWEAR [empty string] 7 117043 473457 98 5121 10
44 128313 48428 71-M/S SPORTSWEAR [empty string] 4 117044 473458 98 5121 10
45 128313 48428 71-M/S SPORTSWEAR [empty string] 2 117045 473459 98 5121 10
46 128314 48428 71-M/S SPORTSWEAR [empty string] 0 117037 473460 98 5121 10
47 128314 48428 71-M/S SPORTSWEAR [empty string] 0 117038 473461 98 5121 10
48 128314 48428 71-M/S SPORTSWEAR [empty string] 0 117039 473462 98 5121 10
49 128314 48428 71-M/S SPORTSWEAR [empty string] 0 117040 473463 98 5121 10
50 128314 48428 71-M/S SPORTSWEAR [empty string] 0 117041 473464 98 5121 10
51 128314 48428 71-M/S SPORTSWEAR [empty string] 0 117042 473465 98 5121 10
52 128314 48428 71-M/S SPORTSWEAR [empty string] 0 117043 473466 98 5121 10
53 128314 48428 71-M/S SPORTSWEAR [empty string] 0 117044 473467 98 5121 10
54 128314 48428 71-M/S SPORTSWEAR [empty string] 0 117045 473468 98 5121 10
55 128315 48428 71-M/S SPORTSWEAR [empty string] 5 117037 509765 98 5121 10
56 128315 48428 71-M/S SPORTSWEAR [empty string] 2 117038 509766 98 5121 10
57 128315 48428 71-M/S SPORTSWEAR [empty string] 5 117039 509767 98 5121 10
58 128315 48428 71-M/S SPORTSWEAR [empty string] 5 117040 509768 98 5121 10
59 128315 48428 71-M/S SPORTSWEAR [empty string] 5 117041 509769 98 5121 10
60 128315 48428 71-M/S SPORTSWEAR [empty string] 2 117042 509770 98 5121 10
61 128315 48428 71-M/S SPORTSWEAR [empty string] 8 117043 509771 98 5121 10
62 128315 48428 71-M/S SPORTSWEAR [empty string] 4 117044 509772 98 5121 10
63 128315 48428 71-M/S SPORTSWEAR [empty string] 2 117045 509773 98 5121 10
CACHED false
EXECUTIONTIME 74
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 = '5121 10' ) 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 = 48428 AND isNull(b.sell_web,'Y') = 'Y' GROUP BY b.sku_id ORDER BY b.sku_id
SQLPARAMETERS
array
1 108180
82
Add to Cart Find in Store Add to Wish List

product description

The seasons change every couple of months—maybe you should too. Whether it’s a new trail or just a different route to work, these KUHL Men's Renegade Shorts - 10in are ready for your small acts of rebellion. They’re made with innovative Duralux two-way stretch, a quick drying, softshell fabric that’s extremely comfortable and durable.

product specs
  • Fabric: main body: Duralux 95% Nylon, 5% Spandex with DWR
  • Durable 2-way stretch fabric with DWR
  • 8 pockets: 2 front mesh chino style, 2 back with Velcro closure, 2 side mesh with zipper closure, 1 3D cell phone and 1 stealth cell phone
  • Gusseted crotch for freedom of moment
  • Free Ryde waistband lined soft micro chamois for comfort
  • Bottom leg opening 21.5in
  • C6 Durable Water Repellent (DWR)
  • UPF 50
  • Imported
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>Fabric: main body: Duralux 95% Nylon, 5% Spandex with DWR</li> <li>Durable 2-way stretch fabric with DWR</li> <li>8 pockets: 2 front mesh chino style, 2 back with Velcro closure, 2 side mesh with zipper closure, 1 3D cell phone and 1 stealth cell phone</li> <li>Gusseted crotch for freedom of moment</li> <li>Free Ryde waistband lined soft micro chamois for comfort</li> <li>Bottom leg opening 21.5in</li> <li>C6 Durable Water Repellent (DWR)</li> <li>UPF 50</li> <li>Imported</li> </ul> [empty string] [empty string] 58966 PEWTER,KHAKI,BRUSHNICK, 48406 KUHL KUHL CLOTHING & FOOTWEAR Clothing & Footwear &gt Men's &gt Bottoms [empty string] [empty string] [empty string] 204 [empty string] 27313384 [empty string] 75 59 59.99 kool,kohl,cuhl,cool,10 inch inseam 12563-DEFAULT-l.jpg 75 [empty string] 12563-DEFAULT-m.jpg Great for the campgrounds or a hang in town - get a short made to be different. These KUHL Men's Renegade Shorts - 10in are ready for action or chillaxin' with a stretchy, quick drying, softshell fabric. [empty string] M/ Renegade Short 10in N NEWATTR [empty string] [empty string] [empty string] [empty string] BTSTFW [empty string] [empty string] PIN [empty string] [empty string] A 71G [empty string] [empty string] FALL_3 [empty string] [empty string] [empty string] N KUHL 79 0 [empty string] 12563 12563 50-to-100 0.00 0 [empty string] [empty string] [empty string] KUHL Men's Renegade Shorts - 10in <p>The seasons change every couple of months&mdash;maybe you should too. Whether it&rsquo;s a new trail or just a different route to work, these KUHL Men&#39;s Renegade Shorts - 10in are ready for your small acts of rebellion. They&rsquo;re made with innovative Duralux two-way stretch, a quick drying, softshell fabric that&rsquo;s extremely comfortable and durable.</p> [empty string] Y 59.99 75 41041 0 30,31,32,33,34,35,36,38,40, [empty string] 12563-DEFAULT-s.jpg 1000 5121 10 108180 BOTTOMS EMPTY EMPTY 0 [empty string] [empty string] 12563-DEFAULT-xs.jpg MENS shop/kuhl-mens-renegade-shorts---10-108180 0 [empty string] 5121 10 [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 15
SQL SELECT * from [dbo].[web_all_products] WHERE style_id='108180' order by ID desc