23 Items

per page
SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `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`, IF(at_price_desc.value_id > 0, at_price_desc.value, at_price_desc_default.value) AS `price_desc` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=18748 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')) INNER JOIN `search_tmp_6077c3cd9a01b3_42440465` AS `search_result` ON e.entity_id = search_result.entity_id 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 LEFT JOIN `catalog_product_entity_decimal` AS `at_price_desc_default` ON (`at_price_desc_default`.`row_id` = `e`.`row_id`) AND (`at_price_desc_default`.`attribute_id` = '887') AND `at_price_desc_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_decimal` AS `at_price_desc` ON (`at_price_desc`.`row_id` = `e`.`row_id`) AND (`at_price_desc`.`attribute_id` = '887') AND (`at_price_desc`.`store_id` = 1) WHERE (e.created_in '1617663541') ORDER BY `price_index`.`min_price` desc, `price_desc` ASC, `price_index`.`min_price` desc LIMIT 30
  1. VIBE Carbon Stem

    PRO VIBE Carbon Stem

    £249.99
     
  2. New
    Tharsis 3FIVE Stem, Alloy

    PRO Tharsis 3FIVE Stem, Alloy

  3. Sale
    Tharsis XC Stem, Alloy, -17deg

    PRO Tharsis XC Stem, Alloy, -17deg

    Was £104.99 From £89.99 (Save 14%)
     
  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. Sale
    Tharsis XC stem, 3d forged aluminium, 1-1/8

    PRO Tharsis XC stem, 3d forged aluminium, 1-1/8

    £99.99 £59.99 (Save 40%)
     
  7. New
    Koryak Stem, Alloy, Di2

    PRO Koryak Stem, Alloy, Di2

  8. PLT Stem, Alloy

    PRO PLT Stem, Alloy

  9. Sale
    Tharsis Trail Stem, Alloy

    PRO Tharsis Trail Stem, Alloy

    £104.99 £45.93 (Save 56%)
     
  10. Sale
    Koryak Stem, Alloy, Di2

    PRO Koryak Stem, Alloy, Di2

    Was £59.99 From £39.99 (Save 33%)
     
  11. Best Seller
    LT Adjustable Stem, Alloy

    PRO LT Adjustable Stem, Alloy

  12. FRS Stem, Alloy

    PRO FRS Stem, Alloy

  13. Best Seller
    LT Stem, Alloy

    PRO LT Stem, Alloy

  14. VIBE Topcap

    PRO VIBE Topcap

    £14.99
    Out of stock
  15. VIBE Top Spacer

    PRO VIBE Top Spacer

  16. VIBE Bottom Spacer

    PRO VIBE Bottom Spacer

    From £3.99