20 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 (421351, 485867, 467536, 477117, 429839, 487225, 421373, 477123, 499793, 429861, 452040, 429855, 467545, 504940, 477120, 421327, 421326, 421430, 470167, 470509))) AND (e.created_in '1626130800') ORDER BY FIELD(e.entity_id,421351,485867,467536,477117,429839,487225,421373,477123,499793,429861,452040,429855,467545,504940,477120,421327,421326,421430,470167,470509)
  1. VIBE Carbon Stem

    PRO VIBE Carbon Stem

    £249.99
     
  2. Sale
    Tharsis XC Stem, Alloy, -17deg

    PRO Tharsis XC Stem, Alloy, -17deg

    Was £104.99 From £89.99 (Save 14%)
     
  3. New
    Tharsis 3FIVE Stem, Alloy

    PRO Tharsis 3FIVE Stem, Alloy

  4. Sale
    Tharsis XC Stem, Alloy, -6°

    PRO Tharsis XC Stem, Alloy, -6°

    Was £104.99 From £89.99 (Save 14%)
     
  5. Discover Stem, Alloy

    PRO Discover Stem, Alloy

  6. New
    Koryak Stem, Alloy, Di2

    PRO Koryak Stem, Alloy, Di2

  7. PLT Stem, Alloy

    PRO PLT Stem, Alloy

  8. Best Seller
    LT Adjustable Stem, Alloy

    PRO LT Adjustable Stem, Alloy

    £39.99
    Out of stock
  9. Best Seller
    LT Stem, Alloy

    PRO LT Stem, Alloy

    £34.99
    Out of stock
  10. FRS Stem, Alloy

    PRO FRS Stem, Alloy

  11. VIBE Topcap

    PRO VIBE Topcap

  12. VIBE Top Spacer

    PRO VIBE Top Spacer

  13. VIBE Bottom Spacer

    PRO VIBE Bottom Spacer

    From £3.99