13 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=18928 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_607be5735194e7_58806424` 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. Men's, S-PHYRE FLASH Short Sleeve Jersey

    Shimano Clothing Men's, S-PHYRE FLASH Short Sleeve Jersey

    £169.99
     
  2. Sale
    Men's, S-PHYRE Short Sleeve Jersey

    Shimano Clothing Men's, S-PHYRE Short Sleeve Jersey

    £189.99 £149.99 (Save 21%)
     
  3. Men's Evolve Jersey

    Shimano Clothing Men's Evolve Jersey

    £149.99
     
  4. Men's Evolve Wind Jersey

    Shimano Clothing Men's Evolve Wind Jersey

    £149.99
     
  5. Men's Wind Jersey

    Shimano Clothing Men's Wind Jersey

    £129.99
     
  6. Women's Kaede Thermal Jersey

    Shimano Clothing Women's Kaede Thermal Jersey

  7. New
    Men's Aerolite Jersey

    Shimano Clothing Men's Aerolite Jersey

  8. Women's Sumire Jersey

    Shimano Clothing Women's Sumire Jersey

  9. Men's Transit Pavement Jersey

    Shimano Clothing Men's Transit Pavement Jersey

  10. Men's Climbers Jersey

    Shimano Clothing Men's Climbers Jersey

  11. Men's Shimano Team Jersey

    Shimano Clothing Men's Shimano Team Jersey

  12. Women's Mizuki Jersey

    Shimano Clothing Women's Mizuki Jersey

  13. Men's Shimano Team Jersey

    Shimano Clothing Men's Shimano Team Jersey

    Was £59.99 From £59.99
    Out of stock