At SkateHut we’ve got some of the coolest brands on the market. Our massive range of Hype backpacks, pencil cases, clothing and accessories will not leave you unsatisfied. This cult brand can be seen worn by skaters all over the world, showing off their style credentials with Hype backpacks, school bags, t-shirts, hoodies and jumpers and raising the fashion stakes. If you want something that you can use every single day, Hype bags are the perfect school bags to take you straight to the skate park and the same goes for the rucksacks, which are perfect for work too. Kit yourself out in Hype clothing all year round, with jumpers and hoodies keeping you warm in the colder months and t-shirts for when the weather warms up. All of them feature the distinctive Hype branding that make it such a popular and distinctive range of clothing and bags. Shop here and get Free Delivery on all orders over £40.

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 = '8' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 8 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 (374244, 374031, 374025, 368593, 305155, 155391, 31953, 31923, 374310, 374253, 374247, 374241, 374004, 368686, 67461, 297402, 368683, 374313, 374304, 374301, 374295, 374034, 374013, 373935))) AND (e.created_in <= '1698796860') AND (e.updated_in > '1698796860') ORDER BY FIELD(e.entity_id,374244,374031,374025,368593,305155,155391,31953,31923,374310,374253,374247,374241,374004,368686,67461,297402,368683,374313,374304,374301,374295,374034,374013,373935)

Showing 24 out of 27