Air Jordan XXX1 All-Star Purple and Teal For Sale

$200.00  $85.00
  • Model: HO880
  • 119 Units in Stock

Please Choose:

Add to Cart:

Originally, the 2017 NBA All-Star Game was scheduled to take place in Charlotte, however, the event has moved and will take place in New Orleans.Having a Charlotte Hornets theme, this Air Jordan XXX1 will use Flyweave uppers with a honeycomb design. On the midsole, we have iridescent that shows shades of Purple and Teal. Other highlights include a translucent outsole and Hornets logo on the inside of the tongue.Air Jordan XXX1 All-StarFebruary 16, 2017$200905847-004

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