Most continents visited
PersonOne COUNT(DISTINCT continent_id) does it; cutoff is 4 — over half of the 7 continents. WCA has no Antarctica comps, so the theoretical max is 6.
Excludes _Multiple Continents (the continental-FMC virtual continent) to keep counts to real continents.
By the numbers
6
Theoretical max
7 continents − Antarctica = 6
≥ 4
Cutoff
Majority of continents
COUNT(DISTINCT)
Aggregate
Distinct `continent_id`
Data source
results joined to competitions for venue country, then countries for continent id; WHERE continent_id != "_Multiple Continents" drops the virtual continent. GROUP BY person_id + COUNT DISTINCT continent_id.
sql
SELECT person_id, COUNT(DISTINCT continent_id) visited_continents FROM results JOIN competitions ON competitions.id = competition_id JOIN countries ON countries.id = competition.country_id WHERE continent_id != "_Multiple Continents" GROUP BY person_id HAVING visited_continents >= 4 ORDER BY visited_continents DESC
Algorithm / pipeline
1
Comp country → continent
countries.continent_id gives the continent of each venue; continental-FMC belongs to _Multiple Continents, filtered out.2
COUNT DISTINCT
50 European comps vs 1 European comp both count as 1 continent for this metric — breadth not depth.
3
Cutoff + sort desc
HAVING >= 4 trims regulars; sort by distinct continent count desc.Caveats & edges
- No Antarctica comps, so 6 is the real ceiling; almost nobody pulls all 6.
- Multiple countries on the same continent don't add — we count
continent_id, notcountry_id. - With
_Multiple Continentsexcluded, continental-FMC mail-ins contribute nothing here.