1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22

SELECT 
	p.username, o.organizationname, COALESCE(t.organizationid, t.mockingorganizationid) orgid 
FROM 
	contests c INNER join 
	contestteams ct ON c.contestid = ct.contestid INNER join 
	teams t ON ct.teamid = t.teamid INNER join 
	organizations o ON o.organizationid = COALESCE(t.organizationid, t.mockingorganizationid) INNER join
	organizationpersons op ON o.organizationid = op.organizationid INNER join
	persons p ON op.personid = p.personid
WHERE 
	c.contestid in 
		(
		SELECT 
			 be.contestid
		FROM 
			basketballevents be LEFT join 
			teams t1 ON be.teamid = t1.teamid LEFT join
			players pl ON be.playerid = pl.playerid INNER join
			teams t2 ON t2.teamid = COALESCE(t1.teamid, pl.teamid)
		GROUP BY
			be.contestid HAVING COUNT(DISTINCT t2.teamid) > 2
		)