33 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=23296 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_60cdb2b57ba1d4_50441646` 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 '1622933940') ORDER BY `price_index`.`min_price` desc, `price_desc` ASC, `price_index`.`min_price` desc LIMIT 30
  1. S-PHYRE XC9 (XC901) SPD Shoes

    Shimano S-PHYRE XC9 (XC901) SPD Shoes

  2. XM9 SPD Shoes

    Shimano XM9 SPD Shoes

  3. MW7 (MW701) GORE-TEX® SPD Shoes

    Shimano MW7 (MW701) GORE-TEX® SPD Shoes

  4. XC7 (XC701) SPD Shoes

    Shimano XC7 (XC701) SPD Shoes

  5. New
    ME5 (ME502) SPD Shoes

    Shimano ME5 (ME502) SPD Shoes

  6. MW5 (MW501) DRYSHIELD® SPD Shoes

    Shimano MW5 (MW501) DRYSHIELD® SPD Shoes

  7. Sale
    MT7 SPD Shoes

    Shimano MT7 SPD Shoes

    £114.99 £57.49 (Save 50%)
    Out of stock
  8. New
    XC3 (XC300) SPD Shoes

    Shimano XC3 (XC300) SPD Shoes

  9. New
    XC3 (XC300W) SPD Women's Shoes

    Shimano XC3 (XC300W) SPD Women's Shoes

  10. Sale
    Women's X-ALP® Elevate

    PEARL iZUMi Women's X-ALP® Elevate

    £149.99 £99.99 (Save 33%)
  11. SD5 (SD501) SPD Shoes

    Shimano SD5 (SD501) SPD Shoes

  12. Sale
    ME4 SPD Shoes

    Shimano ME4 SPD Shoes

    £119.99 £89.99 (Save 25%)
  13. MT5 (MT501 SPD Shoes

    Shimano MT5 (MT501 SPD Shoes

  14. New
    GR5 (GR501) Shoes

    Shimano GR5 (GR501) Shoes

  15. Sale
    Women's X-ALP® Flow

    PEARL iZUMi Women's X-ALP® Flow

    Was £89.99 From £79.99 (Save 11%)
  16. MT3 (MT301) SPD Shoes

    Shimano MT3 (MT301) SPD Shoes

  17. Sale
    Women's X-ALP® Launch SPD

    PEARL iZUMi Women's X-ALP® Launch SPD

    £109.99 £79.99 (Save 27%)
  18. New
    GR5 (GR501W) Women's Shoes

    Shimano GR5 (GR501W) Women's Shoes

  19. New
    XC1 (XC100) SPD Shoes

    Shimano XC1 (XC100) SPD Shoes

  20. Sale
    GR7 Shoes

    Shimano GR7 Shoes

    £99.99 £79.99 (Save 20%)
  21. Sale
    Women's X-ALP® Launch

    PEARL iZUMi Women's X-ALP® Launch

    £109.99 £79.99 (Save 27%)
  22. New
    XC1 (XC100W) SPD Women's Shoes

    Shimano XC1 (XC100W) SPD Women's Shoes

  23. MT3W (MT301W) Women's SPD Shoes

    Shimano MT3W (MT301W) Women's SPD Shoes

  24. AM5 (AM501) SPD Shoes

    Shimano AM5 (AM501) SPD Shoes

  25. Sale
    ME3 (ME301) SPD Shoes

    Shimano ME3 (ME301) SPD Shoes

    Was £99.99 From £69.99 (Save 30%)
  26. Sale
    AM9 (AM901) SPD Shoes

    Shimano AM9 (AM901) SPD Shoes

    £124.99 £62.49 (Save 50%)
  27. Sale
    MT5 SPD Shoes

    Shimano MT5 SPD Shoes

    £89.99 £59.99 (Save 33%)
  28. Sale
    ME1 SPD Shoes

    Shimano ME1 SPD Shoes

    Was £69.99 From £59.99 (Save 14%)
  29. Sale
    GR5W Women's Shoes

    Shimano GR5W Women's Shoes

    Was £79.99 From £59.99 (Save 25%)
  30. Sale
    MT3 SPD Shoes

    Shimano MT3 SPD Shoes

    £74.99 £44.99 (Save 40%)