50 items found

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=19187 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_60393ced88d6a6_96767902` 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 '1614297600') ORDER BY `price_index`.`min_price` desc, `price_desc` ASC, `price_index`.`min_price` desc LIMIT 36
  1. Koryak Dropper Seatpost, 170mm

    PRO Koryak Dropper Seatpost, 170mm

    £249.99
    Out of stock
  2. Koryak Dropper Seatpost, 150mm

    PRO Koryak Dropper Seatpost, 150mm

    £229.99
    Out of stock
  3. VIBE Seatpost, Carbon

    PRO VIBE Seatpost, Carbon

    £199.99
     
  4. Tharsis XC Seatpost, Carbon

    PRO Tharsis XC Seatpost, Carbon

    £189.99
     
  5. Stealth Carbon Rail Saddle

    PRO Stealth Carbon Rail Saddle

    £179.99
     
  6. Aerofuel Saddle

    PRO Aerofuel Saddle

    From £129.99
     
  7. Turnix Carbon Rail Saddle, Anatomic Fit

    PRO Turnix Carbon Rail Saddle, Anatomic Fit

    £149.99
     
  8. Falcon Carbon Rail Saddle, Anatomic Fit

    PRO Falcon Carbon Rail Saddle, Anatomic Fit

    £149.99
     
  9. Griffon Carbon Rail Saddle, Anatomic Fit

    PRO Griffon Carbon Rail Saddle, Anatomic Fit

    £149.99
     
  10. Stealth Hollow Rail Saddle

    PRO Stealth Hollow Rail Saddle

    £129.99
     
  11. Griffon Gel Saddle

    PRO Griffon Gel Saddle

    £99.99
    Out of stock
  12. Falcon Gel Saddle

    PRO Falcon Gel Saddle

  13. Turnix Gel Saddle

    PRO Turnix Gel Saddle

  14. Turnix Hollow Rail Saddle, Anatomic Fit

    PRO Turnix Hollow Rail Saddle, Anatomic Fit

  15. Falcon Hollow Rail Saddle, Anatomic Fit

    PRO Falcon Hollow Rail Saddle, Anatomic Fit

  16. Turnix Offroad Saddle, Hollow Rail

    PRO Turnix Offroad Saddle, Hollow Rail

  17. Volture E MTB Saddle

    PRO Volture E MTB Saddle

  18. Sale
    Fast Forward seat post

    Profile Design Fast Forward seat post

    Was £89.99 From £89.99
     
  19. Griffon Offroad Saddle, Hollow Rail

    PRO Griffon Offroad Saddle, Hollow Rail

  20. Sale
    Women's Turnix Saddle

    PRO Women's Turnix Saddle

    £149.99 £79.99 (Save 47%)
     
  21. VIBE Seatpost, Alloy

    PRO VIBE Seatpost, Alloy

  22. Sale
    Turnix Carbon Rail Saddle, Regular Fit

    PRO Turnix Carbon Rail Saddle, Regular Fit

    £149.99 £65.62 (Save 56%)
     
  23. PLT Seatpost, Allloy

    PRO PLT Seatpost, Allloy

  24. Koryak Seatpost, Alloy

    PRO Koryak Seatpost, Alloy

  25. Volture E MTB CRMO Saddle

    PRO Volture E MTB CRMO Saddle

    £49.99
    Out of stock
  26. Falcon CRMO Saddle

    PRO Falcon CRMO Saddle

  27. Turnix CRMO Saddle

    PRO Turnix CRMO Saddle

  28. Griffon CRMO Saddle

    PRO Griffon CRMO Saddle

  29. Sale
    Falcon Women's Saddle

    PRO Falcon Women's Saddle

    Was £99.99 From £49.99 (Save 50%)
     
  30. Sale
    Falcon Hollow Rail Saddle, Regular Fit

    PRO Falcon Hollow Rail Saddle, Regular Fit

    £99.99 £43.75 (Save 56%)
     
  31. Sale
    Turnix Hollow Rail Saddle, Regular Fit

    PRO Turnix Hollow Rail Saddle, Regular Fit

    £99.99 £43.75 (Save 56%)
     
  32. Sale
    Griffon Hollow Rail Saddle, Regular Fit

    PRO Griffon Hollow Rail Saddle, Regular Fit

    £99.99 £43.75 (Save 56%)
     
  33. Best Seller
    L300 Women's saddle, suspension gel, black

    Madison L300 Women's saddle, suspension gel, black

    £39.99
    Out of stock
  34. Best Seller
    LT Seatpost, Alloy

    PRO LT Seatpost, Alloy

  35. Best Seller
    L200 Women's saddle, Dual-Density gel, black

    Madison L200 Women's saddle, Dual-Density gel, black

Page