HOKA ONE ONE

HOKA ONE ONE Men’s Bondi 6 Running Shoes

$150.00

Item # 1019269

This item ships for FREE
query
RESULTSET
query
  ORIGSIZ QOH SCALE_ENTRY_ID SIZ SIZE_ORDER SKU_ID STYLE_ID
1 8 4 146093 8 [empty string] 522591 129416
2 8.5 10 146094 8.5 [empty string] 522592 129416
3 9 12 146095 9 [empty string] 522593 129416
4 9.5 11 146096 9.5 [empty string] 522594 129416
5 10 16 146097 10 88 522595 129416
6 10.5 21 146098 10.5 89 522596 129416
7 11 19 146099 11 117 522597 129416
8 11.5 7 146100 11.5 118 522598 129416
9 12 6 146101 12 125 522599 129416
10 13 4 146102 13 139 522600 129416
CACHED false
EXECUTIONTIME 390
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 1019269
2 129416
query
RESULTSET
query
  ATTR1 ATTR1_ALIAS ATTR1_ENTRY_ID FAM HEX ORIGATTR1 QOH SIZE SKU_ID SORT_ORDER STYLE_ID
1 BLACK_BLK [empty string] 136330 [empty string] [empty string] BLACK_BLK 66 146102 522600 [empty string] 129416
2 ALY.STGRY_ASGY [empty string] 136328 [empty string] [empty string] ALY.STGRY_ASGY 40 146101 480980 [empty string] 129416
3 BKIR.SBLU_BISB [empty string] 136329 [empty string] [empty string] BKIR.SBLU_BISB 4 146098 501509 [empty string] 129416
CACHED false
EXECUTIONTIME 0
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 129416
HOKA ONE ONE Men’s Bondi 6 Running Shoes BLACK_BLK HOKA ONE ONE Men’s Bondi 6 Running Shoes ALY.STGRY_ASGY HOKA ONE ONE Men’s Bondi 6 Running Shoes BKIR.SBLU_BISB
8 8.5 9 9.5 10 10.5 11 11.5 12 13
query
RESULTSET
query
  ATTR1_ENTRY_ID ATTR2_ENTRY_ID DEPT PURCHASE_AMOUNT QOH SCALE_ENTRY_ID SKU_ID STORE_ID STYLE
1 136328 [empty string] 49-MENS FOOTWEAR [empty string] 1 146093 480972 98 1019269
2 136328 [empty string] 49-MENS FOOTWEAR [empty string] 5 146094 480973 98 1019269
3 136328 [empty string] 49-MENS FOOTWEAR [empty string] 4 146095 480974 98 1019269
4 136328 [empty string] 49-MENS FOOTWEAR [empty string] 5 146096 480975 98 1019269
5 136328 [empty string] 49-MENS FOOTWEAR [empty string] 8 146097 480976 98 1019269
6 136328 [empty string] 49-MENS FOOTWEAR [empty string] 7 146098 480977 98 1019269
7 136328 [empty string] 49-MENS FOOTWEAR [empty string] 7 146099 480978 98 1019269
8 136328 [empty string] 49-MENS FOOTWEAR [empty string] 2 146100 480979 98 1019269
9 136328 [empty string] 49-MENS FOOTWEAR [empty string] 2 146101 480980 98 1019269
10 136328 [empty string] 49-MENS FOOTWEAR [empty string] 1 146102 480981 98 1019269
11 136329 [empty string] 49-MENS FOOTWEAR [empty string] 1 146093 501504 98 1019269
12 136329 [empty string] 49-MENS FOOTWEAR [empty string] 1 146094 501505 98 1019269
13 136329 [empty string] 49-MENS FOOTWEAR [empty string] 2 146095 501506 98 1019269
14 136329 [empty string] 49-MENS FOOTWEAR [empty string] 0 146096 501507 98 1019269
15 136329 [empty string] 49-MENS FOOTWEAR [empty string] 0 146097 501508 98 1019269
16 136329 [empty string] 49-MENS FOOTWEAR [empty string] 2 146098 501509 98 1019269
17 136329 [empty string] 49-MENS FOOTWEAR [empty string] 1 146099 501510 98 1019269
18 136329 [empty string] 49-MENS FOOTWEAR [empty string] 0 146100 501511 98 1019269
19 136329 [empty string] 49-MENS FOOTWEAR [empty string] 0 146101 501512 98 1019269
20 136329 [empty string] 49-MENS FOOTWEAR [empty string] 0 146102 501513 98 1019269
21 136330 [empty string] 49-MENS FOOTWEAR [empty string] 4 146093 522591 98 1019269
22 136330 [empty string] 49-MENS FOOTWEAR [empty string] 5 146094 522592 98 1019269
23 136330 [empty string] 49-MENS FOOTWEAR [empty string] 6 146095 522593 98 1019269
24 136330 [empty string] 49-MENS FOOTWEAR [empty string] 6 146096 522594 98 1019269
25 136330 [empty string] 49-MENS FOOTWEAR [empty string] 8 146097 522595 98 1019269
26 136330 [empty string] 49-MENS FOOTWEAR [empty string] 12 146098 522596 98 1019269
27 136330 [empty string] 49-MENS FOOTWEAR [empty string] 12 146099 522597 98 1019269
28 136330 [empty string] 49-MENS FOOTWEAR [empty string] 5 146100 522598 98 1019269
29 136330 [empty string] 49-MENS FOOTWEAR [empty string] 4 146101 522599 98 1019269
30 136330 [empty string] 49-MENS FOOTWEAR [empty string] 4 146102 522600 98 1019269
31 136331 [empty string] 49-MENS FOOTWEAR [empty string] 0 146093 535114 98 1019269
32 136331 [empty string] 49-MENS FOOTWEAR [empty string] 0 146094 535115 98 1019269
33 136331 [empty string] 49-MENS FOOTWEAR [empty string] 0 146095 535116 98 1019269
34 136331 [empty string] 49-MENS FOOTWEAR [empty string] 0 146096 535117 98 1019269
35 136331 [empty string] 49-MENS FOOTWEAR [empty string] 0 146097 535118 98 1019269
36 136331 [empty string] 49-MENS FOOTWEAR [empty string] 0 146098 535119 98 1019269
37 136331 [empty string] 49-MENS FOOTWEAR [empty string] 0 146099 535120 98 1019269
38 136331 [empty string] 49-MENS FOOTWEAR [empty string] 0 146100 535121 98 1019269
39 136331 [empty string] 49-MENS FOOTWEAR [empty string] 0 146101 535122 98 1019269
40 136331 [empty string] 49-MENS FOOTWEAR [empty string] 0 146102 535123 98 1019269
CACHED false
EXECUTIONTIME 719
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 = '1019269' ) or b.style_id =?) and c.store_id in(98,8,9,2,5,7,6,3) --AND c.qoh > 1 AND isNull(b.sell_web,'Y') = 'Y' GROUP BY b.sku_id ORDER BY b.sku_id
SQLPARAMETERS
array
1 129416
115
Add to Cart Find in Store Add to Wish List

product description

The game-changing Bondi family’s new offering is enhanced with a smoother and more balanced ride. The HOKA ONE ONE Men’s Bondi 6 Running Shoes are their most cushioned offering yet. Designed for running on hard, man-made surfaces, these are constructed with a full EVA midsole that delivers plush cushioning for shock absorption. The neutral stability allows the foot to adopt its natural placement. With the signature Meta-Rocker technology, your foot will naturally roll from impact to toe-off, complementing your normal gait cycle. The lightweight and breathable upper, compression set, and padded tongue offer superior all-around comfort. The Bondi 6 will take you far and wide in comfort.

product specs
  • Open, engineered mesh construction
  • Lycra comfort frame heel section
  • Internal heel counter
  • Early stage Meta-Rocker technology
  • Full-length compression molded EVA midsole
  • Rubber outsole
  • Beveled heel
  • Optimized for road running
  • Weight (US sz 9): 10.90oz
  • Heel-toe drop: 4.00mm
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>Open, engineered mesh construction</li> <li>Lycra comfort frame heel section</li> <li>Internal heel counter</li> <li>Early stage Meta-Rocker technology</li> <li>Full-length compression molded EVA midsole</li> <li>Rubber outsole</li> <li>Beveled heel</li> <li>Optimized for road running</li> <li>Weight (US sz 9): 10.90oz</li> <li>Heel-toe drop: 4.00mm</li> </ul> [empty string] [empty string] 61570 BLACK_BLK,ALY.STGRY_ASGY,BKIR.SBLU_BISB, [empty string] HOKA ONE ONE HOKA ONE ONE CLOTHING & FOOTWEAR Clothing & Footwear &gt Men's &gt Footwear &gt Active Outdoor [empty string] [empty string] [empty string] 596 [empty string] 27422447 [empty string] 150 150 150 [empty string] 29490-DEFAULT-l.jpg 150 [empty string] 29490-DEFAULT-m.jpg Get a smoother and more balanced ride. The HOKA ONE ONE Men’s Bondi 6 Shoes are a game changer. Designed for running on hard, man-made surfaces, these are the Bondi family's most cushioned offering yet. [empty string] M/Bondi 6 N NEWATTR [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] ACTIVE A 49A [empty string] [empty string] FALL_3 [empty string] [empty string] [empty string] N HOKA ONE ONE 109 0 [empty string] 29490 29490 100-to-150 0.00 0 [empty string] [empty string] [empty string] HOKA ONE ONE Men’s Bondi 6 Running Shoes <p>The game-changing Bondi family&rsquo;s new offering is enhanced with a smoother and more balanced ride. The HOKA ONE ONE Men&rsquo;s Bondi 6 Running Shoes are their most cushioned offering yet. Designed for running on hard, man-made surfaces, these are constructed with a full EVA midsole that delivers plush cushioning for shock absorption. The neutral stability allows the foot to adopt its natural placement. With the signature Meta-Rocker technology, your foot will naturally roll from impact to toe-off, complementing your normal gait cycle. The lightweight and breathable upper, compression set, and padded tongue offer superior all-around comfort. The Bondi 6 will take you far and wide in comfort.</p> [empty string] N 150 150 58192 0 10,10.5,11,11.5,12,13,8,8.5,9,9.5, [empty string] 29490-DEFAULT-s.jpg 1000 1019269 129416 FOOTWEAR ACTIVE OUTDOOR EMPTY 0 [empty string] [empty string] 29490-DEFAULT-xs.jpg MENS shop/hoka-one-one-men’s-bondi-6-run-129416 0 [empty string] 1019269 [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 0
SQL SELECT * from [dbo].[web_all_products] WHERE style_id='129416' order by ID desc