KUHL

KUHL Women's Splash 11 Shorts

$65.00 $45.9929% off

Item # 6084

query
RESULTSET
query
  ORIGSIZ QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SKU_ID STYLE_ID
1 6 2 47906 6 [empty string] 472411 108195
2 0 2 47903 0 31 504709 108195
3 2 7 47904 2 177 504377 108195
CACHED false
EXECUTIONTIME 377
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 6084
2 108195
query
RESULTSET
query
  ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID FAM HEX ORIGATTR1 QOH SIZE SKU_ID SORT_ORDER STYLE_ID
1 Shadow Shadow 127219 [empty string] [empty string] SHADOW 5 47906 472411 [empty string] 108195
2 PINE [empty string] 127220 [empty string] [empty string] PINE 4 47904 504709 [empty string] 108195
3 Lt Khaki Lt Khaki 127217 [empty string] [empty string] LTKHAKI 2 47904 472393 [empty string] 108195
CACHED false
EXECUTIONTIME 3
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 108195
KUHL Women's Splash 11 Shorts SHADOW KUHL Women's Splash 11 Shorts PINE KUHL Women's Splash 11 Shorts LTKHAKI
6 0 2
query
RESULTSET
query
  ATTR1_ENTRY_ID ATTR2_ENTRY_ID DEPT PURCHASE_AMOUNT QOH SCALE_ENTRY_ID SKU_ID STORE_ID STYLE
1 127213 48443 72-W/S SPORTSWEAR [empty string] 0 47904 424610 98 6084
2 127214 48443 72-W/S SPORTSWEAR [empty string] 0 47904 424611 98 6084
3 127213 48443 72-W/S SPORTSWEAR [empty string] 0 47905 424612 98 6084
4 127214 48443 72-W/S SPORTSWEAR [empty string] 0 47905 424613 98 6084
5 127213 48443 72-W/S SPORTSWEAR [empty string] 0 47906 424614 98 6084
6 127214 48443 72-W/S SPORTSWEAR [empty string] 0 47906 424615 98 6084
7 127213 48443 72-W/S SPORTSWEAR [empty string] 0 47907 424616 98 6084
8 127214 48443 72-W/S SPORTSWEAR [empty string] 0 47907 424617 98 6084
9 127213 48443 72-W/S SPORTSWEAR [empty string] 0 47908 424618 98 6084
10 127214 48443 72-W/S SPORTSWEAR [empty string] 0 47908 424619 98 6084
11 127213 48443 72-W/S SPORTSWEAR [empty string] 0 47909 424620 98 6084
12 127214 48443 72-W/S SPORTSWEAR [empty string] 0 47909 424621 98 6084
13 127213 48443 72-W/S SPORTSWEAR [empty string] 0 47910 424622 98 6084
14 127214 48443 72-W/S SPORTSWEAR [empty string] 0 47910 424623 98 6084
15 127213 48443 72-W/S SPORTSWEAR [empty string] 0 47911 424624 98 6084
16 127214 48443 72-W/S SPORTSWEAR [empty string] 0 47911 424625 98 6084
17 127215 48443 72-W/S SPORTSWEAR [empty string] 0 47904 424626 98 6084
18 127215 48443 72-W/S SPORTSWEAR [empty string] 0 47905 424627 98 6084
19 127215 48443 72-W/S SPORTSWEAR [empty string] 0 47906 424628 98 6084
20 127215 48443 72-W/S SPORTSWEAR [empty string] 0 47907 424629 98 6084
21 127215 48443 72-W/S SPORTSWEAR [empty string] 0 47908 424630 98 6084
22 127215 48443 72-W/S SPORTSWEAR [empty string] 0 47909 424631 98 6084
23 127215 48443 72-W/S SPORTSWEAR [empty string] 0 47910 424632 98 6084
24 127215 48443 72-W/S SPORTSWEAR [empty string] 0 47911 424633 98 6084
25 127216 48443 72-W/S SPORTSWEAR [empty string] 0 47904 424634 98 6084
26 127216 48443 72-W/S SPORTSWEAR [empty string] 0 47905 424635 98 6084
27 127216 48443 72-W/S SPORTSWEAR [empty string] 0 47906 424636 98 6084
28 127216 48443 72-W/S SPORTSWEAR [empty string] 0 47907 424637 98 6084
29 127216 48443 72-W/S SPORTSWEAR [empty string] 0 47908 424638 98 6084
30 127216 48443 72-W/S SPORTSWEAR [empty string] 0 47909 424639 98 6084
31 127216 48443 72-W/S SPORTSWEAR [empty string] 0 47910 424640 98 6084
32 127216 48443 72-W/S SPORTSWEAR [empty string] 0 47911 424641 98 6084
33 127217 48443 72-W/S SPORTSWEAR [empty string] 2 47904 472393 98 6084
34 127217 48443 72-W/S SPORTSWEAR [empty string] 1 47905 472394 98 6084
35 127217 48443 72-W/S SPORTSWEAR [empty string] 0 47906 472395 98 6084
36 127217 48443 72-W/S SPORTSWEAR [empty string] 0 47907 472396 98 6084
37 127217 48443 72-W/S SPORTSWEAR [empty string] 0 47908 472397 98 6084
38 127217 48443 72-W/S SPORTSWEAR [empty string] 1 47909 472398 98 6084
39 127217 48443 72-W/S SPORTSWEAR [empty string] 1 47910 472399 98 6084
40 127217 48443 72-W/S SPORTSWEAR [empty string] 0 47911 472400 98 6084
41 127218 48443 72-W/S SPORTSWEAR [empty string] 0 47904 472401 98 6084
42 127218 48443 72-W/S SPORTSWEAR [empty string] 0 47905 472402 98 6084
43 127218 48443 72-W/S SPORTSWEAR [empty string] 0 47906 472403 98 6084
44 127218 48443 72-W/S SPORTSWEAR [empty string] 0 47907 472404 98 6084
45 127218 48443 72-W/S SPORTSWEAR [empty string] 0 47908 472405 98 6084
46 127218 48443 72-W/S SPORTSWEAR [empty string] 0 47909 472406 98 6084
47 127218 48443 72-W/S SPORTSWEAR [empty string] 0 47910 472407 98 6084
48 127218 48443 72-W/S SPORTSWEAR [empty string] 0 47911 472408 98 6084
49 127219 48443 72-W/S SPORTSWEAR [empty string] 3 47904 472409 98 6084
50 127219 48443 72-W/S SPORTSWEAR [empty string] 0 47905 472410 98 6084
51 127219 48443 72-W/S SPORTSWEAR [empty string] 2 47906 472411 98 6084
52 127219 48443 72-W/S SPORTSWEAR [empty string] 0 47907 472412 98 6084
53 127219 48443 72-W/S SPORTSWEAR [empty string] 1 47908 472413 98 6084
54 127219 48443 72-W/S SPORTSWEAR [empty string] 0 47909 472414 98 6084
55 127219 48443 72-W/S SPORTSWEAR [empty string] 0 47910 472415 98 6084
56 127219 48443 72-W/S SPORTSWEAR [empty string] 0 47911 472416 98 6084
57 127220 48443 72-W/S SPORTSWEAR [empty string] 2 47904 504377 98 6084
58 127220 48443 72-W/S SPORTSWEAR [empty string] 1 47905 504378 98 6084
59 127220 48443 72-W/S SPORTSWEAR [empty string] 1 47906 504379 98 6084
60 127220 48443 72-W/S SPORTSWEAR [empty string] 1 47907 504380 98 6084
61 127220 48443 72-W/S SPORTSWEAR [empty string] -1 47908 504381 98 6084
62 127220 48443 72-W/S SPORTSWEAR [empty string] 0 47909 504382 98 6084
63 127220 48443 72-W/S SPORTSWEAR [empty string] 0 47910 504383 98 6084
64 127220 48443 72-W/S SPORTSWEAR [empty string] 1 47911 504384 98 6084
65 127221 48443 72-W/S SPORTSWEAR [empty string] 0 47904 504385 98 6084
66 127221 48443 72-W/S SPORTSWEAR [empty string] 0 47905 504386 98 6084
67 127221 48443 72-W/S SPORTSWEAR [empty string] 0 47906 504387 98 6084
68 127221 48443 72-W/S SPORTSWEAR [empty string] 1 47907 504388 98 6084
69 127221 48443 72-W/S SPORTSWEAR [empty string] 1 47908 504389 98 6084
70 127221 48443 72-W/S SPORTSWEAR [empty string] 0 47909 504390 98 6084
71 127221 48443 72-W/S SPORTSWEAR [empty string] 0 47910 504391 98 6084
72 127221 48443 72-W/S SPORTSWEAR [empty string] 0 47911 504392 98 6084
73 127213 48443 72-W/S SPORTSWEAR [empty string] 0 47903 504702 98 6084
74 127214 48443 72-W/S SPORTSWEAR [empty string] 0 47903 504703 98 6084
75 127215 48443 72-W/S SPORTSWEAR [empty string] 0 47903 504704 98 6084
76 127216 48443 72-W/S SPORTSWEAR [empty string] 0 47903 504705 98 6084
77 127217 48443 72-W/S SPORTSWEAR [empty string] 1 47903 504706 98 6084
78 127218 48443 72-W/S SPORTSWEAR [empty string] 0 47903 504707 98 6084
79 127219 48443 72-W/S SPORTSWEAR [empty string] 0 47903 504708 98 6084
80 127220 48443 72-W/S SPORTSWEAR [empty string] 2 47903 504709 98 6084
81 127221 48443 72-W/S SPORTSWEAR [empty string] 0 47903 504710 98 6084
CACHED false
EXECUTIONTIME 6
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 = '6084' ) 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 = 48443 AND isNull(b.sell_web,'Y') = 'Y' GROUP BY b.sku_id ORDER BY b.sku_id
SQLPARAMETERS
array
1 108195
21
Add to Cart Find in Store Add to Wish List

product description

The only way to get where you want to go is by taking it one step at a time. The KUHL Women's Splash 11 Shorts won’t make the journey to your destination any shorter. But the UberKuhl Stretch fabric will give you free range of motion to keep you comfortable along the way.

product specs
  • Fabric: main body: UberKuhl Stretch 68% Cotton 29% Nylon, 3% Spandex
  • Free Ryde waistband contours to your body
  • Advanced wicking properties
  • Six pockets
  • Two snap back pockets and two snap thigh pockets
  • Regular Rise
  • Performance Cotton blend with stretch
  • Easy care, wash and wear
  • Quick dry
  • Inseam: 11in
  • UPF 50
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 <li>Fabric: main body: UberKuhl Stretch 68% Cotton 29% Nylon, 3% Spandex</li> <li>Free Ryde waistband contours to your body</li> <li>Advanced wicking properties</li> <li>Six pockets</li> <li>Two snap back pockets and two snap thigh pockets</li> <li>Regular Rise</li> <li>Performance Cotton blend with stretch</li> <li>Easy care, wash and wear</li> <li>Quick dry</li> <li>Inseam: 11in</li> <li>UPF 50</li> [empty string] [empty string] 58520 SHADOW,PINE,LTKHAKI, 48421 KUHL KUHL CLOTHING & FOOTWEAR Clothing & Footwear &gt Women's [empty string] [empty string] [empty string] 596 [empty string] 27406029 [empty string] 65 45 45.99 kool,kohl,cuhl,cool,hiking,performance 24192-DEFAULT-l.jpg 65 [empty string] 24192-DEFAULT-m.jpg Take that first step in a short that won’t hold you back. The KUHL Women's Splash 11 Shorts make moving easy with its quick-drying performance cotton blend with stretch. [empty string] W/ Splash Short 11in N NEWATTR [empty string] [empty string] [empty string] [empty string] BTSTFW [empty string] [empty string] PIN [empty string] [empty string] A 72E [empty string] [empty string] FALL_3 [empty string] [empty string] [empty string] N KUHL 10 0 [empty string] 24192 24192 25-to-50 0.00 0 [empty string] [empty string] [empty string] KUHL Women's Splash 11 Shorts <p>The only way to get where you want to go is by taking it one step at a time. The KUHL Women&#39;s Splash 11&nbsp;Shorts won&rsquo;t make the journey to your destination any shorter. But the UberKuhl Stretch fabric will give you free range of motion to keep you comfortable along the way.</p> [empty string] Y 45.99 45.99 15406 0 0,2,6, [empty string] 24192-DEFAULT-s.jpg 1000 6084 108195 EMPTY EMPTY EMPTY 0 [empty string] [empty string] 24192-DEFAULT-xs.jpg WOMENS shop/kuhl-womens-splash-11-shorts-108195 0 [empty string] 6084 [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='108195' order by ID desc