NEW ERA

When it comes to top skate wear, at SkateHut we know that New Era hats are leading the way. New Era are a massive skating brand who are recognisable the world over, and New Era hats have become one of the most iconic parts of skating culture. We offer the very best New Era gear, and you can use the filters on the side to make sure you don’t miss the one for you when searching. Shop our New Era beanies and snapback cap online today for the best skate headwear around.

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 (172854, 66144, 66145, 66146, 66147, 66150, 66151, 66152, 66154, 66156, 66157, 66158, 66159, 66161, 66162, 66163, 66164, 66165, 66166, 66167, 66169, 66170, 66171, 66172))) AND (e.created_in <= '1632902400') AND (e.updated_in > '1632902400') ORDER BY FIELD(e.entity_id,172854,66144,66145,66146,66147,66150,66151,66152,66154,66156,66157,66158,66159,66161,66162,66163,66164,66165,66166,66167,66169,66170,66171,66172)
Page