WRIST GUARDS

As anyone will vouch for, having the right protection when you’re skating, rollerblading or scootering is an essential part of being safe – especially if you take a tumble. Wrist guards and ramp gloves are particularly key though for keeping these important parts of our anatomy intact. So before you hit the streets and skate parks, be sure to take a look through our wrist guards and wristsavers. There’s plenty to choose from, all for great value prices and leading industry names. So place your order today on a new or replacement pair of wrist guards and get yourself safe with Skate Hut.

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 (98462, 98463, 98465, 98468, 132264, 167793, 98469, 98471, 98473, 98476, 132263, 132272, 98464, 98470, 98472, 98474, 98475, 174919))) AND (e.created_in <= '1638356402') AND (e.updated_in > '1638356402') ORDER BY FIELD(e.entity_id,98462,98463,98465,98468,132264,167793,98469,98471,98473,98476,132263,132272,98464,98470,98472,98474,98475,174919)