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=18012 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_607d72c4106a16_22407436` 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 Elevate Knee Pad

    PEARL iZUMi Unisex Elevate Knee Pad

  2. ARG Vertical+ Knee Pad

    Bliss Protection ARG Vertical+ Knee Pad

  3. Best Seller
    Team Knee/Shin Pad

    Bliss Protection Team Knee/Shin Pad

  4. Best Seller
    Team Knee Pad

    Bliss Protection Team Knee Pad

  5. Sale
    ARG Comp Knee Pad

    Bliss Protection ARG Comp Knee Pad

    £109.99 £69.99 (Save 36%)
     
  6. Best Seller
    Unisex Summit Knee Pad

    PEARL iZUMi Unisex Summit Knee Pad

  7. Best Seller
    ARG Minimalist Knee

    Bliss Protection ARG Minimalist Knee

  8. Sale
    ARG Vertical Extended Knee Pad

    Bliss Protection ARG Vertical Extended Knee Pad

    Was £94.99 From £59.99 (Save 37%)
     
  9. Sale
    Vertical Knee Pad

    Bliss Protection Vertical Knee Pad

    £79.99 £37.49 (Save 53%)