43 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 (422864, 470533, 477027, 470587, 414127, 470581, 470590, 425333, 425336, 470584, 442263, 425335, 449756, 425004, 413603, 440553, 440559, 440562, 425331, 425003, 424896, 425332, 425334, 425330, 413622, 424895, 424934, 497961, 425013, 425014))) AND (e.created_in '1626130800') ORDER BY FIELD(e.entity_id,422864,470533,477027,470587,414127,470581,470590,425333,425336,470584,442263,425335,449756,425004,413603,440553,440559,440562,425331,425003,424896,425332,425334,425330,413622,424895,424934,497961,425013,425014)
  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-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
  3. 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
  4. ST-R9150 Dura-Ace Di2 STI for drop bar

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

    From £284.99
     
  5. 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
  6. ST-R9160 Dura-Ace Di2, STI for TT / Triathlon

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

    From £169.99
     
  7. 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
  8. Best Seller
    EW-JC130 E-tube Y-split cable

    Shimano Non-Series Di2 EW-JC130 E-tube Y-split cable

Page