Correlated subqueries A correlated subquery references a column from the outer query, so it re-executes once for every row the outer query processes. The example below uses a correlated subquery ...
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 ...