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=18650 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_60794131a4bf67_14865560` 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
    L300 Women's saddle, suspension gel, black

    Madison L300 Women's saddle, suspension gel, black

    £39.99
    Out of stock
  2. Best Seller
    L200 Women's saddle, Dual-Density gel, black

    Madison L200 Women's saddle, Dual-Density gel, black

  3. Flux Men's saddle, Cro-mo rails

    Madison Flux Men's saddle, Cro-mo rails

    £34.99
    Out of stock
  4. Leia Women's Saddle, Cro-mo Rails

    Madison Leia Women's Saddle, Cro-mo Rails

  5. G100 Men's Comfort saddle, black

    Madison G100 Men's Comfort saddle, black

  6. L100 Women's Comfort saddle, black

    Madison L100 Women's Comfort saddle, black

  7. Sale
    Zena Women's saddle, Cro-mo rails, white

    Madison Zena Women's saddle, Cro-mo rails, white

    £39.99 £19.99 (Save 50%)
     
  8. Sprint youth saddle

    Madison Sprint youth saddle

    £17.99
    Out of stock
  9. Trail Youth saddle, black

    Madison Trail Youth saddle, black

    £17.99
    Out of stock
  10. Track Kid's saddle

    Madison Track Kid's saddle

    £14.99
    Out of stock