INNER JOIN person_region pr ON pr.region_id = n.id INNER JOIN person p ON p.id = pr.person_id INNER JOIN games_competitor gc ON gc.person_id = p.id INNER JOIN ...