ICE HOCKEY

With our fantastic ice hockey range, you can channel your inner Wayne Gretzky with complete ease. Stocking the latest ice hockey skates, gloves, sticks and accessories that are suitable to help a novice get started or an experienced player enhance their game, there’s no shortage of options available. Our skates are from industry leading brands such as Bauer and CCM, while our accessories’ range includes pucks, sticks, supports and training equipment that will help you get well on your way when it comes to improving your skills. You don’t have to be from North America to have dreams of lifting the Stanley Cup, and with our range of ice hockey products here to help you on your way, those NHL ambitions could be one step closer to being fulfilled.

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 = '5' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 5 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 (158454, 158455, 82432, 82437, 82438, 82442, 82445, 82446, 82449, 82450, 82451, 82453, 82454, 82458, 82461, 82462, 82464, 82466, 82470, 82472, 158458, 82430, 82431, 82435))) AND (e.created_in <= '1638356402') AND (e.updated_in > '1638356402') ORDER BY FIELD(e.entity_id,158454,158455,82432,82437,82438,82442,82445,82446,82449,82450,82451,82453,82454,82458,82461,82462,82464,82466,82470,82472,158458,82430,82431,82435)
Page