GBP £

For Sales & Advice Call Us on 0121 501 1111

Search

Menu
Settings
  • AUD A$
  • CAD CA$
  • USD $

    • BAUER

    Here at SkateHut, we know that you want the best brands when it comes to your skate sport; that’s why we stock Bauer skates. Bauer produces a whole range of different pieces of equipment but they are known for their excellent hockey gear. Offering ice skates, hockey skates and a range of accessories, Bauer pride themselves on pushing the boundaries to combine comfort with performance to provide top quality equipment. So if you’re looking for a pair of Bauer ice hockey skates, then you’ve come to the right place. At SkateHut, we offer great prices and excellent delivery options, so make sure you buy your Bauer skates with us today

    Loading...
    SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE ((stock_status_index.stock_status = 1) AND (e.entity_id IN (82845, 82846, 131507, 158508))) AND (e.created_in <= '1637884861') AND (e.updated_in > '1637884861') ORDER BY FIELD(e.entity_id,82845,82846,131507,158508)