12 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=18931 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_6082cc2321f9f1_63897409` 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 Bib Shorts

    Shimano Clothing Men's, S-PHYRE FLASH Bib Shorts

    £179.99
     
  2. Sale
    Men's, S-PHYRE Bib Shorts

    Shimano Clothing Men's, S-PHYRE Bib Shorts

    £219.99 £169.99 (Save 23%)
     
  3. Men's Evolve Bib Shorts

    Shimano Clothing Men's Evolve Bib Shorts

    £159.99
     
  4. Men's Advanced Bib Shorts

    Shimano Clothing Men's Advanced Bib Shorts

    Was £109.99 From £109.99
     
  5. Men's Thermal Bib Shorts

    Shimano Clothing Men's Thermal Bib Shorts

  6. Women's Sumire Bib Shorts

    Shimano Clothing Women's Sumire Bib Shorts

  7. Men's Shimano Aspire Bib Shorts

    Shimano Clothing Men's Shimano Aspire Bib Shorts

  8. New
    Men's Kodama Bib Shorts

    Shimano Clothing Men's Kodama Bib Shorts

  9. Women's Sumire Shorts

    Shimano Clothing Women's Sumire Shorts

  10. Men's Transit Path Shorts

    Shimano Clothing Men's Transit Path Shorts

  11. New
    Men's Inizio Shorts

    Shimano Clothing Men's Inizio Shorts

  12. New
    Women's Inizio Shorts

    Shimano Clothing Women's Inizio Shorts