313 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 (470533, 470530, 477027, 470542, 470524, 470527, 472301, 478607, 459162, 459165, 470764, 459159, 471080, 459156, 420538, 474306, 469753, 467119, 420564, 445701, 467116, 476979, 488509, 470491, 488506, 455532, 449756, 447770, 476976, 441222))) AND (e.created_in '1627772401') ORDER BY FIELD(e.entity_id,470533,470530,477027,470542,470524,470527,472301,478607,459162,459165,470764,459159,471080,459156,420538,474306,469753,467119,420564,445701,467116,476979,488509,470491,488506,455532,449756,447770,476976,441222)
  1. ST-R9170 hydraulic disc, Di2 E-tube STI set, flat mount calliper

    Shimano Dura-Ace ST-R9170 hydraulic disc, Di2 E-tube STI set, flat mount calliper

    £509.99
     
  2. ST-R9120 hydraulic disc, mechanical STI set, flat mount calliper

    Shimano Dura-Ace ST-R9120 hydraulic disc, mechanical STI set, flat mount calliper

    £444.99
     
  3. ST-R9180 hydraulic disc, Di2 E-tube STI TT set, flat mount calliper

    Shimano Dura-Ace ST-R9180 hydraulic disc, Di2 E-tube STI TT set, flat mount calliper

    £409.99
    Out of stock
  4. ST-RX815 GRX Di2 11-speed STI bled with BR-RX810 calliper

    Shimano GRX ST-RX815 GRX Di2 11-speed STI bled with BR-RX810 calliper

    £329.99
    Out of stock
  5. ST-R8025 Ultegra short reach STI bled with BR-R8070 calliper

    Shimano Ultegra ST-R8025 Ultegra short reach STI bled with BR-R8070 calliper

    £324.99
    Out of stock
  6. Best Seller
    ST-R8070 bled hydraulic disc, Di2 E-tube STI set, flat mount calliper

    Shimano Ultegra ST-R8070 bled hydraulic disc, Di2 E-tube STI set, flat mount calliper

    £324.99
    Out of stock
  7. ST-R8020 bled hydraulic disc, mechanical STI set, flat mount calliper

    Shimano Ultegra ST-R8020 bled hydraulic disc, mechanical STI set, flat mount calliper

    £324.99
    Out of stock
  8. ST-R7020 105 hydraulic disc STI set, flat mount calliper

    Shimano 105 ST-R7020 105 hydraulic disc STI set, flat mount calliper

    £269.99
     
  9. ST-R7025 105 hydraulic disc STI set, flat mount calliper

    Shimano 105 ST-R7025 105 hydraulic disc STI set, flat mount calliper

    £269.99
     
  10. ST-RX600 GRX 11-speed STI bled with BR-RX400 flat mount calliper

    Shimano GRX ST-RX600 GRX 11-speed STI bled with BR-RX400 flat mount calliper

    From £244.99
    Out of stock
  11. 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
     
  12. ST-RX400 GRX 10-speed STI bled with BR-RX400 flat mount calliper

    Shimano GRX ST-RX400 GRX 10-speed STI bled with BR-RX400 flat mount calliper

    £234.99
    Out of stock
  13. 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
     
  14. Best Seller
    BR-M820 Saint bled I-spec-B compatible brake with post mount calliper

    Shimano Saint BR-M820 Saint bled I-spec-B compatible brake with post mount calliper

    £194.99
    Out of stock
  15. 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
  16. BR-R9100 Dura-Ace brake calliper

    Shimano Dura-Ace BR-R9100 Dura-Ace brake calliper

    £167.99
     
  17. SLX BR-M7120/BL-M7100 4 pot bled brake lever/post mount calliper

    Shimano SLX SLX BR-M7120/BL-M7100 4 pot bled brake lever/post mount calliper

    £159.99
     
  18. 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
    Out of stock
  19. BR-R9170 Dura-Ace flat mount calliper, without rotor, for 140/160 mm

    Shimano Dura-Ace BR-R9170 Dura-Ace flat mount calliper, without rotor, for 140/160 mm

    £124.99
    Out of stock
  20. Best Seller
    SLX BR-M7100/BL-M7100 bled brake lever/post mount calliper

    Shimano SLX SLX BR-M7100/BL-M7100 bled brake lever/post mount calliper

    £109.99
     
Page