32 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 (470947, 470914, 470911, 470917, 425337, 457317, 475788, 487210, 429135, 470077, 476982, 424870, 424871, 475743, 475059, 424869, 424868, 412549, 412548, 425071, 444111, 433701, 425074, 425072, 425073, 465292, 465295, 445962, 425076, 425077))) AND (e.created_in '1626130800') ORDER BY FIELD(e.entity_id,470947,470914,470911,470917,425337,457317,475788,487210,429135,470077,476982,424870,424871,475743,475059,424869,424868,412549,412548,425071,444111,433701,425074,425072,425073,465292,465295,445962,425076,425077)
  1. Best Seller
    SG-S7001 Alfine 11-speed disc internal hub gear

    Shimano Alfine SG-S7001 Alfine 11-speed disc internal hub gear

    £419.99
     
  2. SG-S7051 Alfine 11-speed Di2 disc internal hub gear

    Shimano Alfine SG-S7051 Alfine 11-speed Di2 disc internal hub gear

    £419.99
     
  3. SG-S7000/7001 Alfine 8-speed disc internal hub gear

    Shimano Alfine SG-S7000/7001 Alfine 8-speed disc internal hub gear

    £239.99
    Out of stock
  4. SG-S7051 Alfine 8-speed Di2 disc internal hub gear

    Shimano Alfine SG-S7051 Alfine 8-speed Di2 disc internal hub gear

    £229.99
     
  5. Best Seller
    FC-S501 Alfine 2-piece chainset with single chain guard

    Shimano Alfine FC-S501 Alfine 2-piece chainset with single chain guard

    £119.99
     
  6. DH-S501 Alfine dynamo front hub

    Shimano Alfine DH-S501 Alfine dynamo front hub

    £104.99
     
  7. Alfine BR-S7000 bled brake lever/post mount calliper

    Shimano Alfine Alfine BR-S7000 bled brake lever/post mount calliper

    £76.99
    Out of stock
  8. Best Seller
    Alfine BL-S7000 complete brake lever

    Shimano Alfine Alfine BL-S7000 complete brake lever

    £35.99
    Out of stock
Page