13 Items

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 (497733, 415616, 497751, 470110, 429150, 429151, 429152, 429466, 497781, 429465, 429464, 497796, 470155))) AND (e.created_in '1627772401') ORDER BY FIELD(e.entity_id,497733,415616,497751,470110,429150,429151,429152,429466,497781,429465,429464,497796,470155)
  1. Best Seller
    FH-M6000 / M6010 Deore freehub

    Shimano Deore FH-M6000 / M6010 Deore freehub

    £36.99
    Out of stock
  2. FH-MT400 freehub

    Shimano Deore FH-MT400 freehub

    £33.99
    Out of stock
  3. FH-T610 Deore Freehub - rim brake

    Shimano Deore FH-T610 Deore Freehub - rim brake

    From £30.99
    Out of stock
  4. Best Seller
    FH-M475 Freehub, black

    Shimano Deore FH-M475 Freehub, black

    £27.99
    Out of stock
  5. FH-M475 Freehub, silver

    Shimano Deore FH-M475 Freehub, silver

    £27.99
    Out of stock
  6. Best Seller
    FH-M525 Deore disc 6-bolt Freehub

    Shimano Deore FH-M525 Deore disc 6-bolt Freehub

    £33.99
    Out of stock
  7. HB-M525 Deore disc front hub

    Shimano Deore HB-M525 Deore disc front hub

    £23.99
    Out of stock
  8. HB-M6000 Deore front hub

    Shimano Deore HB-M6000 Deore front hub

    £21.99
    Out of stock
  9. HB-M475 disc front hub 6-bolt silver

    Shimano Deore HB-M475 disc front hub 6-bolt silver

  10. HB-M475 disc front hub 6-bolt black

    Shimano Deore HB-M475 disc front hub 6-bolt black

  11. HB-MT400 front hub

    Shimano Deore HB-MT400 front hub

    £19.99
    Out of stock
  12. HB-T610 Deore front hub - rim brake

    Shimano Deore HB-T610 Deore front hub - rim brake

    From £16.99
    Out of stock