CLOTHING SALE

Shop our skate clothing sale and find some great offers from top brands. SkateHut is the UK's number one online skate shop and we are product leaders in all things skate – that includes one of the most extensive collections of skate clothing around! If you’re on the hunt for discounted skate clothes from your favourite brands look no further. We have offers on top brands including Vans, Nike SB, Brixton, Element, Hype, Dickies, Herschel, Levi’s, Huf, Primitive and more.

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 (66136, 66146, 66147, 66151, 66152, 66154, 66156, 66157, 66158, 66159, 66161, 66162, 66163, 66164, 66165, 66166, 66167, 66170, 66176, 66178, 66185, 66517, 112598, 124171))) AND (e.created_in <= '1638356402') AND (e.updated_in > '1638356402') ORDER BY FIELD(e.entity_id,66136,66146,66147,66151,66152,66154,66156,66157,66158,66159,66161,66162,66163,66164,66165,66166,66167,66170,66176,66178,66185,66517,112598,124171)
Page