31 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 (476979, 485855, 488506, 485852, 476976, 471353, 470092, 486601, 470089, 497736, 474798, 475953, 467356, 475374, 422830, 474975, 428878, 424826, 424828, 424829, 424825, 424827, 424830, 472124, 472121, 475371, 478463, 477744, 470179, 470950))) AND (e.created_in '1626130800') ORDER BY FIELD(e.entity_id,476979,485855,488506,485852,476976,471353,470092,486601,470089,497736,474798,475953,467356,475374,422830,474975,428878,424826,424828,424829,424825,424827,424830,472124,472121,475371,478463,477744,470179,470950)
  1. SLX BR-M7120/BL-M7100 4 pot bled brake lever/post mount calliper

    Shimano SLX SLX BR-M7120/BL-M7100 4 pot bled brake lever/post mount calliper

    £159.99
    Out of stock
  2. FC-M7120 SLX chainset, double 36 / 26, 12-speed, 51.8 mm chainline

    Shimano SLX FC-M7120 SLX chainset, double 36 / 26, 12-speed, 51.8 mm chainline

    £129.99
    Out of stock
  3. FC-M7100 SLX chainset, double 36 / 26, 12-speed, 48.8 mm chainline

    Shimano SLX FC-M7100 SLX chainset, double 36 / 26, 12-speed, 48.8 mm chainline

    £129.99
     
  4. Best Seller
    SLX BR-M7100/BL-M7100 bled brake lever/post mount calliper

    Shimano SLX SLX BR-M7100/BL-M7100 bled brake lever/post mount calliper

    £109.99
    Out of stock
  5. CS-M7100 SLX 12-speed cassette

    Shimano SLX CS-M7100 SLX 12-speed cassette

    £104.99
    Out of stock
  6. FC-M7130 SLX Crank set without ring, 12-speed, 56.5 mm chainline

    Shimano SLX FC-M7130 SLX Crank set without ring, 12-speed, 56.5 mm chainline

    £104.99
     
  7. FC-M7120 SLX Crank set without ring, 12-speed, 55 mm chainline

    Shimano SLX FC-M7120 SLX Crank set without ring, 12-speed, 55 mm chainline

    £104.99
     
  8. FC-M7100 XT Crank set without ring, 12-speed, 52 mm chainline

    Shimano SLX FC-M7100 XT Crank set without ring, 12-speed, 52 mm chainline

    £104.99
     
  9. FH-M7110/7130 12-speed freehub

    Shimano SLX FH-M7110/7130 12-speed freehub

    From £81.99
     
  10. Best Seller
    CS-M7000 SLX 11-speed cassette

    Shimano SLX CS-M7000 SLX 11-speed cassette

    From £76.99
    Out of stock
  11. Best Seller
    SLX BL-M7100 complete brake lever

    Shimano SLX SLX BL-M7100 complete brake lever

    £41.99
    Out of stock
  12. Best Seller
    CS-HG81 10-speed cassette

    Shimano SLX CS-HG81 10-speed cassette

    £54.99
    Out of stock
  13. SLX FC-M7100/7130 SM-CRM75 12-speed chainring

    Shimano SLX SLX FC-M7100/7130 SM-CRM75 12-speed chainring

  14. Best Seller
    SLX FC-M7000 SM-CRM70 11-speed chainring

    Shimano SLX SLX FC-M7000 SM-CRM70 11-speed chainring

  15. Best Seller
    SM-RT70 Ice Tech Center Lock disc rotor

    Shimano SLX SM-RT70 Ice Tech Center Lock disc rotor

    From £28.99
    Out of stock
  16. New
    SM-RT66 ZEE / SLX rotor, 6-Bolt

    Shimano SLX SM-RT66 ZEE / SLX rotor, 6-Bolt

    From £21.99
    Out of stock
Page