55 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=19290 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_60797b8875bed6_22262385` 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. Unisex ELITE Thermal Leg Warmer

    PEARL iZUMi Unisex ELITE Thermal Leg Warmer

  2. Unisex PRO Softshell Arm Warmer

    PEARL iZUMi Unisex PRO Softshell Arm Warmer

  3. Unisex ELITE Thermal Knee Warmer

    PEARL iZUMi Unisex ELITE Thermal Knee Warmer

  4. Unisex Transfer Wool Cap

    PEARL iZUMi Unisex Transfer Wool Cap

  5. Unisex Wool Neck Gaiter

    PEARL iZUMi Unisex Wool Neck Gaiter

    £34.99
    Out of stock
  6. Sale
    Unisex Shimano Leg Warmer

    Shimano Clothing Unisex Shimano Leg Warmer

    £44.99 £33.74 (Save 25%)
     
  7. Sale
    Unisex Shimano Knee Warmer

    Shimano Clothing Unisex Shimano Knee Warmer

    £39.99 £29.99 (Save 25%)
     
  8. Sale
    Unisex Shimano Arm Warmer

    Shimano Clothing Unisex Shimano Arm Warmer

    £39.99 £29.99 (Save 25%)
     
  9. Unisex Barrier Balaclava

    PEARL iZUMi Unisex Barrier Balaclava

    £29.99
    Out of stock
  10. Best Seller
    Sportive Thermal leg warmers

    Madison Sportive Thermal leg warmers

  11. Unisex Wool Skullcap

    PEARL iZUMi Unisex Wool Skullcap

    £29.99
    Out of stock
  12. Unisex, Transfer Cycling Cap

    PEARL iZUMi Unisex, Transfer Cycling Cap

  13. Sportive Thermal knee warmers

    Madison Sportive Thermal knee warmers

  14. Women's Knit Beanie Hat

    PEARL iZUMi Women's Knit Beanie Hat

  15. Unisex Knit Beanie Hat

    PEARL iZUMi Unisex Knit Beanie Hat

  16. Best Seller
    RoadRace optimus winter cap

    Madison RoadRace optimus winter cap

  17. Unisex, Transfer Lite Cycling Cap

    PEARL iZUMi Unisex, Transfer Lite Cycling Cap

  18. Best Seller
    Isoler Thermal leg warmers

    Madison Isoler Thermal leg warmers

  19. Best Seller
    Unisex Barrier Lite Cycling Cap

    PEARL iZUMi Unisex Barrier Lite Cycling Cap

  20. Unisex, Transfer Lite Skull Cap

    PEARL iZUMi Unisex, Transfer Lite Skull Cap

  21. Isoler Thermal knee warmers

    Madison Isoler Thermal knee warmers

  22. Best Seller
    Isoler Merino winter cap

    Madison Isoler Merino winter cap

  23. Sportive Thermal arm warmers

    Madison Sportive Thermal arm warmers

  24. Best Seller
    Isoler Merino neck warmer

    Madison Isoler Merino neck warmer

  25. Sale
    RoadRace Optimus Softshell leg warmers

    Madison RoadRace Optimus Softshell leg warmers

    £34.99 £17.49 (Save 50%)
     
  26. Best Seller
    Isoler Balaclava

    Madison Isoler Balaclava

  27. Unisex Barrier Skull Cap

    PEARL iZUMi Unisex Barrier Skull Cap

    £24.99
    Out of stock
  28. Best Seller
    Isoler Thermal arm warmers

    Madison Isoler Thermal arm warmers

  29. Sale
    Women's ELITE Thermal Arm Warmer

    PEARL iZUMi Women's ELITE Thermal Arm Warmer

    Was £29.99 From £14.99 (Save 50%)
     
Page