IALs editors that also edit in other IALs.

For each wiki user we want to see how many edits they've done in an IAL and in any of the top Wikipedia languages.

SQL

SELECT * FROM
( 
  	SELECT 		simple_rev.rev_user AS User_ID, COUNT(simple_rev.rev_user) AS Contributions_in_Simple_English
  	FROM 		simplewiki_p.revision AS simple_rev
  	GROUP BY 	User_ID
  	LIMIT		3
)
LEFT OUTER JOIN
( 
  	SELECT 		vo_rev.rev_user AS User_ID, COUNT(vo_rev.rev_user) AS Contributions_in_Volapük
  	FROM 		vowiki_p.revision AS vo_rev
  	GROUP BY 	User_ID
  	LIMIT		3
)
LEFT OUTER JOIN
( 
  	SELECT 		ie_rev.rev_user AS User_ID, COUNT(ie_rev.rev_user) AS Contributions_in_Interlingue
  	FROM 		iewiki_p.revision AS ie_rev
  	GROUP BY 	User_ID
  	LIMIT		3
)
USING (User_ID);

SQL

Checking query status...