11 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=18936 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_607be70bdfcc64_02229917` 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 Insulated Shoe Cover

    Shimano Clothing Men's S-PHYRE Insulated Shoe Cover

  2. Unisex S3100R NPU+ Shoe Cover

    Shimano Clothing Unisex S3100R NPU+ Shoe Cover

  3. Unisex S3100X NPU+ Shoe Cover

    Shimano Clothing Unisex S3100X NPU+ Shoe Cover

  4. Unisex S1100X H2O Shoe Cover

    Shimano Clothing Unisex S1100X H2O Shoe Cover

  5. Unisex S1100R H2O Shoe Cover

    Shimano Clothing Unisex S1100R H2O Shoe Cover

  6. Sale
    S3000R NPU+ 3 mm Neoprene overshoe, with BCF and PU coating

    Shimano Clothing S3000R NPU+ 3 mm Neoprene overshoe, with BCF and PU coating

    £44.99 £29.99 (Save 33%)
    Out of stock
  7. Unisex S2100D Shoe Cover

    Shimano Clothing Unisex S2100D Shoe Cover

  8. Unisex Waterproof Shoe Cover

    Shimano Clothing Unisex Waterproof Shoe Cover

  9. Unisex Shimano Shoe Cover

    Shimano Clothing Unisex Shimano Shoe Cover

  10. Best Seller
    Men's S-PHYRE Toe Cover

    Shimano Clothing Men's S-PHYRE Toe Cover

  11. Best Seller
    Unisex T1100R Toe Cover

    Shimano Clothing Unisex T1100R Toe Cover