42 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 (429133, 497859, 497862, 498575, 422864, 470533, 429132, 425291, 470530, 477027, 429114, 470587, 414127, 470578, 470581, 470590, 445713, 428869, 422863, 425336, 470584, 499247, 445701, 425335, 449756, 425331, 445818, 424799, 440490, 470557))) AND (e.created_in '1626130800') ORDER BY FIELD(e.entity_id,429133,497859,497862,498575,422864,470533,429132,425291,470530,477027,429114,470587,414127,470578,470581,470590,445713,428869,422863,425336,470584,499247,445701,425335,449756,425331,445818,424799,440490,470557)
  1. FC-R9100-P Dura-Ace double Power Meter chainset, HollowTech II

    Shimano Dura-Ace FC-R9100-P Dura-Ace double Power Meter chainset, HollowTech II

    £1,199.99
    Out of stock
  2. WH-R9100 Dura-Ace wheels, Carbon tubular 40 mm, Q/R

    Shimano Dura-Ace WH-R9100 Dura-Ace wheels, Carbon tubular 40 mm, Q/R

    From £1,024.99
     
  3. WH-R9170 Dura-Ace wheels

    Shimano Dura-Ace WH-R9170 Dura-Ace wheels

    From £874.99
     
  4. WH-R9100 Dura-Ace wheels

    Shimano Dura-Ace WH-R9100 Dura-Ace wheels

    From £499.99
     
  5. 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
     
  6. FC-R9100 Dura-Ace compact chainset - HollowTech II

    Shimano Dura-Ace FC-R9100 Dura-Ace compact chainset - HollowTech II

    From £509.99
     
  7. 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
     
  8. 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
  9. FC-7710 Dura-Ace Track Crankset, Without Chainring

    Shimano Dura-Ace FC-7710 Dura-Ace Track Crankset, Without Chainring

    £369.99
     
  10. ST-R9170 Dura-Ace hydraulic Di2 STI for drop bar

    Shimano Dura-Ace ST-R9170 Dura-Ace hydraulic Di2 STI for drop bar

    £354.99
    Out of stock
  11. ST-R9100 Dura-Ace 11-speed hydraulic / mechanical STI lever

    Shimano Dura-Ace ST-R9100 Dura-Ace 11-speed hydraulic / mechanical STI lever

    £289.99
    Out of stock
  12. ST-R9150 Dura-Ace Di2 STI for drop bar

    Shimano Dura-Ace ST-R9150 Dura-Ace Di2 STI for drop bar

    From £284.99
     
  13. ST-R9180 Dura-Ace hydraulic Di2 STI for TT bar

    Shimano Dura-Ace ST-R9180 Dura-Ace hydraulic Di2 STI for TT bar

    £264.99
    Out of stock
  14. Best Seller
    CS-R9100 Dura-Ace 11-speed cassette

    Shimano Dura-Ace CS-R9100 Dura-Ace 11-speed cassette

    From £224.99
     
  15. CS-7900 Dura-Ace 10-speed cassette

    Shimano Dura-Ace CS-7900 Dura-Ace 10-speed cassette

    Was £199.99 From £199.99
     
  16. ST-R9160 Dura-Ace Di2, STI for TT / Triathlon

    Shimano Dura-Ace ST-R9160 Dura-Ace Di2, STI for TT / Triathlon

    From £169.99
     
  17. BR-R9110 Dura-Ace brake calliper

    Shimano Dura-Ace BR-R9110 Dura-Ace brake calliper

    From £167.99
     
  18. BR-R9100 Dura-Ace brake calliper

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

    £167.99
     
  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. FD-R9100 Dura-Ace 11-speed front derailleur

    Shimano Dura-Ace FD-R9100 Dura-Ace 11-speed front derailleur

    From £99.99
     
  21. Best Seller
    SM-RT900 Dura-Ace Ice Tech FREEZA Center Lock rotor

    Shimano Dura-Ace SM-RT900 Dura-Ace Ice Tech FREEZA Center Lock rotor

    £71.99
    Out of stock
Page