32 items found

per page
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.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')) 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 WHERE ((e.entity_id IN (464487, 470314, 429129, 470308, 470311, 474111, 459327, 412533, 459159, 497748, 459156, 474318, 447722, 455532, 472133, 447770, 479918, 459135, 474981, 474984, 454416, 439689, 447201, 424921, 424915, 474447, 424920, 425097, 474444, 424919))) AND (e.created_in '1626130800') ORDER BY FIELD(e.entity_id,464487,470314,429129,470308,470311,474111,459327,412533,459159,497748,459156,474318,447722,455532,472133,447770,479918,459135,474981,474984,454416,439689,447201,424921,424915,474447,424920,425097,474444,424919)
  1. New
    FC-M9100 XTR chainset, 48.8 mm chain line, 12-speed, 38 / 28T

    Shimano XTR FC-M9100 XTR chainset, 48.8 mm chain line, 12-speed, 38 / 28T

    £459.99
    Out of stock
  2. FC-M9120 XTR chainset, 51.8 mm chain line, 12-speed, 38 / 28T

    Shimano XTR FC-M9120 XTR chainset, 51.8 mm chain line, 12-speed, 38 / 28T

    £459.99
     
  3. Sale
    FC-M9020 11-speed XTR Trail chainset HollowTech II

    Shimano XTR FC-M9020 11-speed XTR Trail chainset HollowTech II

    Was £369.99 From £319.99 (Save 14%)
     
  4. FC-M9100 XTR crank set without ring, 52mm chain line, 12-speed

    Shimano XTR FC-M9100 XTR crank set without ring, 52mm chain line, 12-speed

    £324.99
     
  5. New
    FC-M9120 XTR crank set without ring, 52 mm chain line, 12-speed

    Shimano XTR FC-M9120 XTR crank set without ring, 52 mm chain line, 12-speed

    £324.99
     
  6. CS-M9100 XTR 12-speed cassette

    Shimano XTR CS-M9100 XTR 12-speed cassette

    £319.99
    Out of stock
  7. BR-M9120 XTR bled I-spec-EV ready brake lever/Post mount 4 pot calliper

    Shimano XTR BR-M9120 XTR bled I-spec-EV ready brake lever/Post mount 4 pot calliper

    £239.99
     
  8. FH-M9111 XTR 12-Speed Freehub

    Shimano XTR FH-M9111 XTR 12-Speed Freehub

    £239.99
     
  9. BR-M9100 XTR bled I-spec-EV ready brake lever/Post mount calliper

    Shimano XTR BR-M9100 XTR bled I-spec-EV ready brake lever/Post mount calliper

    £229.99
     
  10. XTR RD-M9000 11-speed rear derailleur

    Shimano XTR XTR RD-M9000 11-speed rear derailleur

    £179.99
    Out of stock
  11. XTR FC-M9000/9020 SM-CRM91 single chainring

    Shimano XTR XTR FC-M9000/9020 SM-CRM91 single chainring

    £119.99
     
  12. XTR FC-M9100/9120 SM-CRM95 single chainring

    Shimano XTR XTR FC-M9100/9120 SM-CRM95 single chainring

    £109.99
     
  13. FD-M9100-M XTR double front derailleur

    Shimano XTR FD-M9100-M XTR double front derailleur

  14. XTR BL-M9100 I-spec-II compatible disc brake lever

    Shimano XTR XTR BL-M9100 I-spec-II compatible disc brake lever

    £79.99
    Out of stock
  15. XTR BL-M9120 I-spec-II compatible disc brake lever

    Shimano XTR XTR BL-M9120 I-spec-II compatible disc brake lever

    £79.99
    Out of stock
Page