itwiki_p editors that edit in IALs

SQL

SELECT * FROM
( 
  	SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Italian
  	FROM itwiki_p.revision
  	GROUP BY rev_user
) AS Users
LEFT OUTER JOIN
( 
  	SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Simple_English
  	FROM 		simplewiki_p.revision
    GROUP BY	rev_user
) AS Simple_English USING (User)
LEFT OUTER JOIN
( 
  	SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Esperanto
    FROM		eowiki_p.revision 
    GROUP BY	rev_user
) AS Esperanto USING (User)
LEFT OUTER JOIN
( 
  	SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Ido
    FROM		iowiki_p.revision 
    GROUP BY	rev_user
) AS Ido USING (User)
LEFT OUTER JOIN
( 
  	SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Interlingua
    FROM		iawiki_p.revision 
    GROUP BY	rev_user
) AS Interlingua USING (User)
LEFT OUTER JOIN
( 
  	SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Novial
    FROM		novwiki_p.revision 
    GROUP BY	rev_user
) AS Novial USING (User)
LEFT OUTER JOIN
( 
  	SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Interlingue
    FROM		iewiki_p.revision 
    GROUP BY	rev_user
) AS Interlingue USING (User)
LEFT OUTER JOIN
( 
  	SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Volapük
    FROM		vowiki_p.revision 
    GROUP BY	rev_user
) AS Volapük USING (User);
SQL

Checking query status...
