42 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_609eac416475a5_48090880` 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. Stealth Superlight Carbon Rail Saddle

    PRO Stealth Superlight Carbon Rail Saddle

    £249.99
    Out of stock
  2. New
    Falcon Team Saddle

    PRO Falcon Team Saddle

    £179.99
     
  3. Stealth Carbon Rail Saddle

    PRO Stealth Carbon Rail Saddle

    £179.99
     
  4. New
    Griffon Team Saddle

    PRO Griffon Team Saddle

    £179.99
     
  5. New
    Turnix Team Saddle

    PRO Turnix Team Saddle

    £179.99
    Out of stock
  6. Sale
    Women's Turnix Saddle

    PRO Women's Turnix Saddle

    £149.99 £79.99 (Save 47%)
    Out of stock
  7. Sale
    Turnix Carbon Rail Saddle, Regular Fit

    PRO Turnix Carbon Rail Saddle, Regular Fit

    £149.99 £65.62 (Save 56%)
    Out of stock
  8. Stealth Offroad Saddle

    PRO Stealth Offroad Saddle

    £129.99
    Out of stock
  9. Aerofuel Saddle

    PRO Aerofuel Saddle

    From £129.99
    Out of stock
  10. Stealth Hollow Rail Saddle

    PRO Stealth Hollow Rail Saddle

    £129.99
     
  11. Sale
    Griffon Carbon Rail Saddle, Anatomic Fit

    PRO Griffon Carbon Rail Saddle, Anatomic Fit

    Was £149.99 From £109.99 (Save 27%)
     
  12. Sale
    Falcon Carbon Rail Saddle, Anatomic Fit

    PRO Falcon Carbon Rail Saddle, Anatomic Fit

    Was £149.99 From £109.99 (Save 27%)
     
  13. Griffon Gel Saddle

    PRO Griffon Gel Saddle

    £99.99
    Out of stock
  14. Sale
    Turnix Hollow Rail Saddle, Anatomic Fit

    PRO Turnix Hollow Rail Saddle, Anatomic Fit

    Was £99.99 From £69.99 (Save 30%)
    Out of stock
  15. Turnix Gel Saddle

    PRO Turnix Gel Saddle

    £99.99
    Out of stock
  16. Falcon Gel Saddle

    PRO Falcon Gel Saddle

  17. Turnix Offroad Saddle, Hollow Rail

    PRO Turnix Offroad Saddle, Hollow Rail

  18. Griffon Offroad Saddle, Hollow Rail

    PRO Griffon Offroad Saddle, Hollow Rail

  19. New
    Stealth Sport Saddle

    PRO Stealth Sport Saddle

  20. Sale
    Falcon Women's Saddle

    PRO Falcon Women's Saddle

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

    PRO Falcon Hollow Rail Saddle, Anatomic Fit

    Was £99.99 From £69.99 (Save 30%)
     
  22. Sale
    Volture E MTB Saddle

    PRO Volture E MTB Saddle

    £89.99 £59.99 (Save 33%)
     
  23. Griffon CRMO Saddle

    PRO Griffon CRMO Saddle

    £49.99
    Out of stock
  24. Falcon CRMO Saddle

    PRO Falcon CRMO Saddle

    £49.99
    Out of stock
  25. Volture E MTB CRMO Saddle

    PRO Volture E MTB CRMO Saddle

  26. Turnix CRMO Saddle

    PRO Turnix CRMO Saddle

    £49.99
    Out of stock
  27. Sale
    Turnix Hollow Rail Saddle, Regular Fit

    PRO Turnix Hollow Rail Saddle, Regular Fit

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

    Madison L300 Women's saddle, suspension gel, black

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

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

    £34.99
    Out of stock
Page