56 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 (422845, 485861, 485858, 474837, 414089, 469753, 474108, 488509, 470095, 470710, 486598, 470491, 424069, 445683, 478646, 504370, 475959, 475956, 425327, 425326, 420629, 474183, 480200, 422868, 480197, 472130, 472127, 488410, 424876, 424877))) AND (e.created_in '1626130800') ORDER BY FIELD(e.entity_id,422845,485861,485858,474837,414089,469753,474108,488509,470095,470710,486598,470491,424069,445683,478646,504370,475959,475956,425327,425326,420629,474183,480200,422868,480197,472130,472127,488410,424876,424877)
  1. FC-M8120 XT chainset, double 36 / 26, 12-speed, 51.8 mm chainline

    Shimano Deore XT FC-M8120 XT chainset, double 36 / 26, 12-speed, 51.8 mm chainline

    £204.99
     
  2. FC-M8100 XT chainset, double 36 / 26, 12-speed, 48.8 mm chainline

    Shimano Deore XT FC-M8100 XT chainset, double 36 / 26, 12-speed, 48.8 mm chainline

    £204.99
     
  3. Deore XT FC-T8000 chainset

    Shimano Deore XT Deore XT FC-T8000 chainset

    £199.99
    Out of stock
  4. BR-M8120/BL-M8100 XT 4 pot bled brake lever/post mount calliper

    Shimano Deore XT BR-M8120/BL-M8100 XT 4 pot bled brake lever/post mount calliper

    £184.99
    Out of stock
  5. CS-M8100 XT 12-Speed Cassette

    Shimano Deore XT CS-M8100 XT 12-Speed Cassette

    £149.99
    Out of stock
  6. FC-M8100 XT Crank set without ring, 12-speed, 52 mm chainline

    Shimano Deore XT FC-M8100 XT Crank set without ring, 12-speed, 52 mm chainline

    £144.99
     
  7. New
    FC-M8130 XT Crank set without ring, 12-speed, 56.5 mm chainline

    Shimano Deore XT FC-M8130 XT Crank set without ring, 12-speed, 56.5 mm chainline

    £144.99
    Out of stock
  8. FC-M8120 XT Crank set without ring, 12-speed, 55 mm chainline

    Shimano Deore XT FC-M8120 XT Crank set without ring, 12-speed, 55 mm chainline

    £144.99
     
  9. BR-M8100 XT bled I-spec-EV compatible brake lever and calliper

    Shimano Deore XT BR-M8100 XT bled I-spec-EV compatible brake lever and calliper

    £139.99
     
  10. Best Seller
    CS-M8000 XT 11-speed cassette

    Shimano Deore XT CS-M8000 XT 11-speed cassette

    From £94.99
    Out of stock
  11. XT RD-M8000 11-speed rear derailleur

    Shimano Deore XT XT RD-M8000 11-speed rear derailleur

    £92.99
    Out of stock
  12. XT RD-M786 10-speed rear derailleur

    Shimano Deore XT XT RD-M786 10-speed rear derailleur

    From £79.99
    Out of stock
  13. XT RD-M781 10-speed rear derailleur

    Shimano Deore XT XT RD-M781 10-speed rear derailleur

    £71.99
    Out of stock
  14. XT FC-M8100/8130 SM-CRM85 12-speed chainring

    Shimano Deore XT XT FC-M8100/8130 SM-CRM85 12-speed chainring

  15. XT FC-M8000 SM-CRM81 11-speed chainring

    Shimano Deore XT XT FC-M8000 SM-CRM81 11-speed chainring

Page