7IDP

7iDp is well known for pushing the boundaries of protection design to produce premium level protection gear. With this range of MTB helmets and protection pads, you can be sure you’re getting the best for your money. When you're racing, getting laps at the bike park or hitting your local trails, invest in some great protective gear to enhance your riding experience and keep you safe. Shop now and get Free Delivery on orders over £40.

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 (87984, 89277, 89283, 89284, 89286, 59334, 92560, 92563, 92564, 87983, 87986, 89280, 92559, 92561, 87985, 92562, 151398, 151399, 151403, 151404, 151405))) AND (e.created_in <= '1638356402') AND (e.updated_in > '1638356402') ORDER BY FIELD(e.entity_id,87984,89277,89283,89284,89286,59334,92560,92563,92564,87983,87986,89280,92559,92561,87985,92562,151398,151399,151403,151404,151405)