TRIPLE 8

If you're searching for the best protective gear for all your favourite action sports, look no further than Triple 8. Established in 1996, the brand was born on the streets of NYC, with their first Triple 8 helmet evolving into their huge collection of tough and stylish protection you can find today. They're best known for their Triple 8 Brainsaver helmets, with a durable ABS outer shell and customisable Sweatsaver pads for the perfect fit. It's a classic skate-style helmet, but streamlined to become the perfect combination of style, comfort and protection. Other Triple 8 protection products featuring their expert eye for design includes elbow pads, knee pads, slider gloves and wrist guards. These products have been developed by experts to keep you safe, whether you're into skating, biking, skateboarding or scootering. Whether you play action sports competitively or just for fun, your safety is vital and Triple 8 protection gear should be your ideal companion.

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 (92567, 95115, 98474, 151410, 154607))) AND (e.created_in <= '1632902400') AND (e.updated_in > '1632902400') ORDER BY FIELD(e.entity_id,92567,95115,98474,151410,154607)