Components

Components

Browse the extensive range of cycling components available at clearance prices in the sale.

44 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 (421433, 460311, 427138, 447174, 467536, 429839, 454113, 420920, 424959, 486044, 420913, 427641, 427630, 427631, 425097, 430446, 427709, 427561, 427727, 420832, 427554, 427750, 414037, 427703, 427723, 427724, 425096, 470503, 424916, 499109))) AND (e.created_in '1626130800') ORDER BY FIELD(e.entity_id,421433,460311,427138,447174,467536,429839,454113,420920,424959,486044,420913,427641,427630,427631,425097,430446,427709,427561,427727,420832,427554,427750,414037,427703,427723,427724,425096,470503,424916,499109)
  1. Sale
    Tharsis XC Stem, Alloy, -17deg

    PRO Tharsis XC Stem, Alloy, -17deg

    Was £104.99 From £89.99 (Save 14%)
     
  2. Sale
    Tharsis XC Stem, Alloy, -6°

    PRO Tharsis XC Stem, Alloy, -6°

    Was £104.99 From £89.99 (Save 14%)
     
  3. Sale
    Falcon Women's Saddle

    PRO Falcon Women's Saddle

    Was £149.99 From £74.99 (Save 50%)
     
  4. Sale
    Tharsis 9.8 Seatpost, Alloy

    PRO Tharsis 9.8 Seatpost, Alloy

    Was £69.99 From £39.99 (Save 43%)
     
  5. Sale
    Zena Women's saddle, Cro-mo rails, white

    Madison Zena Women's saddle, Cro-mo rails, white

    £39.99 £19.99 (Save 50%)
     
  6. Sale
    Camera Mount, Top Cap

    PRO Camera Mount, Top Cap

    Was £16.99 From £11.99 (Save 29%)
     
Page