37 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 (470524, 470527, 472301, 425278, 445716, 470539, 470575, 470563, 470566, 414123, 470572, 470569, 469786, 424866, 412517, 470536, 445707, 469813, 428866, 445695, 445692, 445698, 424865, 424864, 412464, 428867, 470554, 445815, 440163, 412427))) AND (e.created_in '1626130800') ORDER BY FIELD(e.entity_id,470524,470527,472301,425278,445716,470539,470575,470563,470566,414123,470572,470569,469786,424866,412517,470536,445707,469813,428866,445695,445692,445698,424865,424864,412464,428867,470554,445815,440163,412427)
  1. 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
  2. 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
  3. 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
  4. FC-R8000 Ultegra 11-speed double chainset

    Shimano Ultegra FC-R8000 Ultegra 11-speed double chainset

    £259.99
     
  5. Best Seller
    RD-R8050 Ultegra Di2 11-speed rear derailleur E-tube

    Shimano Ultegra RD-R8050 Ultegra Di2 11-speed rear derailleur E-tube

    £254.99
    Out of stock
  6. ST-R8070 Ultegra hydraulic Di2 STI for drop bar

    Shimano Ultegra ST-R8070 Ultegra hydraulic Di2 STI for drop bar

    £244.99
    Out of stock
  7. ST-R8020 Ultegra 11-speed hydraulic / mechanical STI lever

    Shimano Ultegra ST-R8020 Ultegra 11-speed hydraulic / mechanical STI lever

    £234.99
    Out of stock
  8. ST-R8060 Ultegra Di2, STI for TT / Triathlon

    Shimano Ultegra ST-R8060 Ultegra Di2, STI for TT / Triathlon

    From £149.99
     
  9. ST-R8050 Ultegra Di2 STI for drop bar

    Shimano Ultegra ST-R8050 Ultegra Di2 STI for drop bar

    From £147.99
    Out of stock
  10. FH-RS770 Freehub for Center Lock disc mount

    Shimano Ultegra FH-RS770 Freehub for Center Lock disc mount

    £142.99
     
  11. RD-R8000 Ultegra 11-speed rear derailleur

    Shimano Ultegra RD-R8000 Ultegra 11-speed rear derailleur

    From £86.99
    Out of stock
  12. Best Seller
    CS-R8000 Ultegra 11-speed cassette

    Shimano Ultegra CS-R8000 Ultegra 11-speed cassette

    From £82.99
    Out of stock
  13. HB-RS770 Front hub for Center Lock disc mount

    Shimano Ultegra HB-RS770 Front hub for Center Lock disc mount

  14. CS-6600 Ultegra 10-speed cassette

    Shimano Ultegra CS-6600 Ultegra 10-speed cassette

  15. BR-R8010 Ultegra direct mount brake calliper

    Shimano Ultegra BR-R8010 Ultegra direct mount brake calliper

    From £74.99
     
  16. BR-R8000 Ultegra brake calliper

    Shimano Ultegra BR-R8000 Ultegra brake calliper

  17. BR-R8070 Ultegra flat mount calliper, without rotor, for 140/160 mm

    Shimano Ultegra BR-R8070 Ultegra flat mount calliper, without rotor, for 140/160 mm

    £66.99
    Out of stock
  18. CS-6700 Ultegra 10-Speed Cassette

    Shimano Ultegra CS-6700 Ultegra 10-Speed Cassette

    £72.99
    Out of stock
  19. Best Seller
    SM-RT800 Ultegra Ice Tech FREEZA Center Lock rotor

    Shimano Ultegra SM-RT800 Ultegra Ice Tech FREEZA Center Lock rotor

    £51.99
    Out of stock
  20. Best Seller
    FD-R8000 Ultegra 11-speed front derailleur

    Shimano Ultegra FD-R8000 Ultegra 11-speed front derailleur

    From £48.99
    Out of stock
Page