Medium · UFC · Tables: fights
Find the 15 fighter names with the most wins in this snapshot. For winner = 'Red' use r_fighter; for 'Blue' use b_fighter. Exclude other outcomes and NULL or blank winning names. Do not use the pre-bout r_wins or b_wins columns. Names are treated as exact identifiers within this snapshot. Return columns fighter, wins, in that order. Order by wins descending, then fighter ascending; return fifteen rows. All source columns have TEXT affinity: cast numeric inputs before numeric comparisons or calculations. Counts and calculated numeric outputs must be numbers, not text. Use only the historical fights table (2010–March 2026); this is not complete UFC history or a live schedule.