eowiki_p editors that edit in top 3 projects

SQL

SELECT * FROM
( 
  	SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Esperanto
  	FROM 		eowiki_p.revision
    GROUP BY	rev_user
) AS Users
LEFT OUTER JOIN
( 
  	SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_English
  	FROM 		enwiki_p.revision
    GROUP BY	rev_user
) AS English USING (User)
LEFT OUTER JOIN
( 
  	SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Swedish
  	FROM 		svwiki_p.revision
    GROUP BY	rev_user
) AS Swedish USING (User)
LEFT OUTER JOIN
( 
  	SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_German
  	FROM 		dewiki_p.revision
    GROUP BY	rev_user
) AS German USING (User)
LEFT OUTER JOIN
( 
  	SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_French
  	FROM 		frwiki_p.revision
    GROUP BY	rev_user
) AS French USING (User)
LEFT OUTER JOIN
( 
  	SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Dutch
  	FROM 		nlwiki_p.revision
    GROUP BY	rev_user
) AS Dutch USING (User)
SQL

Checking query status...
