44 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=17896 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_603c415a468409_83342570` 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. Stealth Superlight Carbon Rail Saddle

    PRO Stealth Superlight Carbon Rail Saddle

    £249.99
     
  2. Aerofuel Saddle

    PRO Aerofuel Saddle

    From £129.99
     
  3. New
    Turnix Team Saddle

    PRO Turnix Team Saddle

    £179.99
     
  4. New
    Falcon Team Saddle

    PRO Falcon Team Saddle

    £179.99
     
  5. Stealth Carbon Rail Saddle

    PRO Stealth Carbon Rail Saddle

    £179.99
     
  6. New
    Griffon Team Saddle

    PRO Griffon Team Saddle

    £179.99
     
  7. Griffon Carbon Rail Saddle, Anatomic Fit

    PRO Griffon Carbon Rail Saddle, Anatomic Fit

    £149.99
     
  8. Turnix Carbon Rail Saddle, Anatomic Fit

    PRO Turnix Carbon Rail Saddle, Anatomic Fit

    £149.99
     
  9. Falcon Carbon Rail Saddle, Anatomic Fit

    PRO Falcon Carbon Rail Saddle, Anatomic Fit

    £149.99
     
  10. Stealth Hollow Rail Saddle

    PRO Stealth Hollow Rail Saddle

    £129.99
     
  11. Stealth Offroad Saddle

    PRO Stealth Offroad Saddle

    £129.99
    Out of stock
  12. Griffon Gel Saddle

    PRO Griffon Gel Saddle

    £99.99
    Out of stock
  13. Falcon Gel Saddle

    PRO Falcon Gel Saddle

  14. Turnix Gel Saddle

    PRO Turnix Gel Saddle

  15. Turnix Hollow Rail Saddle, Anatomic Fit

    PRO Turnix Hollow Rail Saddle, Anatomic Fit

  16. Falcon Hollow Rail Saddle, Anatomic Fit

    PRO Falcon Hollow Rail Saddle, Anatomic Fit

  17. Volture E MTB Saddle

    PRO Volture E MTB Saddle

  18. Griffon Offroad Saddle, Hollow Rail

    PRO Griffon Offroad Saddle, Hollow Rail

  19. Turnix Offroad Saddle, Hollow Rail

    PRO Turnix Offroad Saddle, Hollow Rail

  20. New
    Stealth Sport Saddle

    PRO Stealth Sport Saddle

  21. Sale
    Women's Turnix Saddle

    PRO Women's Turnix Saddle

    £149.99 £79.99 (Save 47%)
     
  22. Sale
    Turnix Carbon Rail Saddle, Regular Fit

    PRO Turnix Carbon Rail Saddle, Regular Fit

    £149.99 £65.62 (Save 56%)
     
  23. Griffon CRMO Saddle

    PRO Griffon CRMO Saddle

  24. Sale
    Falcon Women's Saddle

    PRO Falcon Women's Saddle

    Was £99.99 From £49.99 (Save 50%)
     
  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. Sale
    Griffon Hollow Rail Saddle, Regular Fit

    PRO Griffon Hollow Rail Saddle, Regular Fit

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

    PRO Falcon Hollow Rail Saddle, Regular Fit

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

    PRO Turnix Hollow Rail Saddle, Regular Fit

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

    Madison L300 Women's saddle, suspension gel, black

    £39.99
    Out of stock
  32. Best Seller
    L200 Women's saddle, Dual-Density gel, black

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

  33. Flux Men's saddle, Cro-mo rails

    Madison Flux Men's saddle, Cro-mo rails

    £34.99
    Out of stock
  34. Leia Women's Saddle, Cro-mo Rails

    Madison Leia Women's Saddle, Cro-mo Rails

Page