Nike Kyrie S1 Hybrid Opening Night Black/White-Green For Sale

$120.00  $75.00
  • Model: HO1299
  • 116 Units in Stock

Please Choose:

Add to Cart:

Kyrie Irving has been one of the most talked about NBA players this past offseason since announcing he wanted to be traded away from LeBron James and the Cleveland Cavaliers, and inevitably ended up being traded to the Boston Celtics. Kicking off his Celtics career tonight against the Cavs, Irving has debuted a brand new Nike model.Irving warmed up for the game in a black, white, and green pair of sneakers that looks to be a mash up of his first three signature models. It takes the triangular midsole pattern and spiked heel from the Kyrie 1, midfoot strap from the Kyrie 2, and the overall upper design of the Kyrie 3, and fuses it into a brand new hybrid silhouette.

1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'newx013_cheapjordansinc1.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
[select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '1172' and opa.orders_id = opb.orders_id and opb.products_id != '1172' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = 1 group by p.products_id order by o.date_purchased desc limit 6]