ICE SKATE GUARDS

Protect your blades with our superb range of skate guards. We have a wide range of skate guards available in a wide range of colours to suit your personal style. Our durable skate guards will protect all kinds of blades in transit allowing you to take your skates on the move without damaging them or yourself. Here at SkateHut, safety is our top priority and you can count on us for skate guards of the highest quality. Browse our skate guards online and have them delivered to your door in the colour of your choice.

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 (82442, 118793, 82451, 82449, 82447, 82445, 82452, 82448, 158453, 82468, 82432, 82444, 82462, 82431, 158455, 82446, 158454, 158456, 82437, 82456, 82450, 158458, 82436, 82438))) AND (e.created_in <= '1638144073') AND (e.updated_in > '1638144073') ORDER BY FIELD(e.entity_id,82442,118793,82451,82449,82447,82445,82452,82448,158453,82468,82432,82444,82462,82431,158455,82446,158454,158456,82437,82456,82450,158458,82436,82438)
Page