38 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 (470527, 470539, 470575, 470566, 414123, 425333, 442263, 470572, 470569, 413603, 425004, 440553, 440559, 440562, 425003, 424896, 425332, 425334, 425330, 413622, 413623, 424895, 424934, 497961, 424918, 425013, 425014, 424917, 485036, 413602))) AND (e.created_in '1626130800') ORDER BY FIELD(e.entity_id,470527,470539,470575,470566,414123,425333,442263,470572,470569,413603,425004,440553,440559,440562,425003,424896,425332,425334,425330,413622,413623,424895,424934,497961,424918,425013,425014,424917,485036,413602)
  1. 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
  2. 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
  3. 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
  4. ST-R8060 Ultegra Di2, STI for TT / Triathlon

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

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

    Shimano Ultegra ST-R8050 Ultegra Di2 STI for drop bar

    From £147.99
    Out of stock
  6. Best Seller
    EW-JC130 E-tube Y-split cable

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

  7. Best Seller
    EW-SD50 E-tube Di2 electric wire

    Shimano Non-Series Di2 EW-SD50 E-tube Di2 electric wire

    From £23.99
    Out of stock
Page