ODI

ODI

ODI Is the world leader in grip technology. That's not an exaggeration, ODI pioneered lock on grips and over the past 25 years have been dedicated to providing the best products there is to offer.

54 items found

per page
SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `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`, IF(at_price_desc.value_id > 0, at_price_desc.value, at_price_desc_default.value) AS `price_desc` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=20942 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 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 `search_tmp_6076d22c8f7777_45831983` AS `search_result` ON e.entity_id = search_result.entity_id LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 LEFT JOIN `catalog_product_entity_decimal` AS `at_price_desc_default` ON (`at_price_desc_default`.`row_id` = `e`.`row_id`) AND (`at_price_desc_default`.`attribute_id` = '887') AND `at_price_desc_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_decimal` AS `at_price_desc` ON (`at_price_desc`.`row_id` = `e`.`row_id`) AND (`at_price_desc`.`attribute_id` = '887') AND (`at_price_desc`.`store_id` = 1) WHERE (e.created_in '1617663541') ORDER BY `price_index`.`min_price` desc, `price_desc` ASC, `price_index`.`min_price` desc LIMIT 30
  1. AG2 v2.1 MTB Lock On Grips

    ODI AG2 v2.1 MTB Lock On Grips

  2. AG1 MTB Lock On Grips

    ODI AG1 MTB Lock On Grips

  3. Troy Lee Designs MTB Lock On Grips

    ODI Troy Lee Designs MTB Lock On Grips

  4. Dread Lock MTB Grips

    ODI Dread Lock MTB Grips

  5. Stay Strong BMX Lock On Grips

    ODI Stay Strong BMX Lock On Grips

  6. Rogue MTB Lock On Grips

    ODI Rogue MTB Lock On Grips

  7. Elite Motion MTB Lock On Grips

    ODI Elite Motion MTB Lock On Grips

  8. Vans MTB Lock On Grips

    ODI Vans MTB Lock On Grips

    From £26.99
     
  9. SDG MTB Lock On Grips

    ODI SDG MTB Lock On Grips

  10. Rogue BMX Lock On Grips

    ODI Rogue BMX Lock On Grips

  11. Best Seller
    Elite Flow MTB Lock On Grips

    ODI Elite Flow MTB Lock On Grips

  12. Ruffian MTB Lock On Grips

    ODI Ruffian MTB Lock On Grips

  13. Ruffian BMX Lock On Grips

    ODI Ruffian BMX Lock On Grips

  14. New
    Elite Pro MTB Lock On Grips

    ODI Elite Pro MTB Lock On Grips

  15. X-Treme MTB Lock On Grips

    ODI X-Treme MTB Lock On Grips

  16. Performance Bar Tape 3.5mm

    ODI Performance Bar Tape 3.5mm

  17. Best Seller
    Performance Bar Tape 2.5mm

    ODI Performance Bar Tape 2.5mm

  18. DH Number Plate

    ODI DH Number Plate

  19. Aluminum End Plug

    ODI Aluminum End Plug

Page