Currencies: 

Shoes Adidas Adidas HotStreak Low Black/White-Metallic Silver G47418 Mens

Shoes Adidas Adidas HotStreak Low Black/White-Metallic Silver G47418 Mens

  • Add to Cart:
    • Price: £35.56
    • Model: yBMHfGCmLxGH
    • 2851 Units in Stock
  • Please Choose :



  • Adolf Dassler was inspired by a single idea when he made his first shoes in 1920, at the age of just 20. His vision was to provide every athlete with the best footwear for his respective discipline. It was this principle that guided him right up until his death in 1978. All Adidas products are inspired by these principles.


    Write Review


    Review Rating: *
    Your Name: *
    Your Email: *
    Review Title: *
    Identifying Code: *
    Your review*:

    NOTE: HTML tags are not allowed.
    NOTE: Reviews require prior approval before they will be displayed
    Contact Us
    * Required information

    *
    *

    1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'upcdo_nyhtf.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
    in:
    [select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '1345' and opa.orders_id = opb.orders_id and opb.products_id != '1345' 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]