Nike Air VaporMax Dark Team Red and Black-University Red For Sal

  • Model: HO1077
  • 123 Units in Stock

Please Choose:

Add to Cart:

This Nike Air VaporMax for the Summer features a Dark Team Red, Black and University Red color combination. Constructed with Flyknit across the uppers which is highlighted with the two shades of Red. In addition we have Black that lands on the Nike Swoosh as well as the outsole. Completing the look is the traditional full length bubble cushioning which has a smokey Black hue.Nike Air VaporMaxDark Team Red/Black-University RedJuly 13, 2017849558-601$190

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 = '954' and opa.orders_id = opb.orders_id and opb.products_id != '954' 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]