GBP £

For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Settings

  • AUD A$
  • CAD CA$
  • USD $

    • THOUSAND

    Named after their commitment to help to save 1000 lives with their helmets, Thousand are a helmet company with heart. All of their helmets come with an accident replacement policy and anti-theft guarantee, to make sure that you’ve always got the protection you need. On top of this, Thousand are also incredibly conscious of their environmental impact and are working towards being climate positive. We’re proud to be a UK stockist of Thousand Helmets!

    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 (89287, 89288, 89289, 89290, 89291, 89292, 89293, 89295, 154602, 154603))) AND (e.created_in <= '1652691602') AND (e.updated_in > '1652691602') ORDER BY FIELD(e.entity_id,89287,89288,89289,89290,89291,89292,89293,89295,154602,154603)

    10 Items