9 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=18189 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_60795763947d83_82714480` 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. Best Seller
    Sportive Thermal leg warmers

    Madison Sportive Thermal leg warmers

  2. Sportive Thermal knee warmers

    Madison Sportive Thermal knee warmers

  3. Best Seller
    Isoler Thermal leg warmers

    Madison Isoler Thermal leg warmers

  4. Sportive Thermal arm warmers

    Madison Sportive Thermal arm warmers

  5. Isoler Thermal knee warmers

    Madison Isoler Thermal knee warmers

  6. Sale
    RoadRace Optimus Softshell leg warmers

    Madison RoadRace Optimus Softshell leg warmers

    £34.99 £17.49 (Save 50%)
     
  7. Best Seller
    Isoler Thermal arm warmers

    Madison Isoler Thermal arm warmers

  8. Sale
    RoadRace Optimus Softshell knee warmers

    Madison RoadRace Optimus Softshell knee warmers

    £24.99 £12.49 (Save 50%)
     
  9. Sale
    RoadRace Optimus Softshell arm warmers

    Madison RoadRace Optimus Softshell arm warmers

    £24.99 £12.49 (Save 50%)