Editors of wiki using IALs ranked by number of contributions.

SQL

( 
  	SELECT 		'Simple English' AS IAL, SIMPLE_L.log_user AS 'User ID', COUNT(SIMPLE_L.log_user) AS 'Contributions in Simple English', SIMPLE_U.user_editcount / COUNT(SIMPLE_L.log_user) AS 'Ratio of global by Simple English contributions'
  	FROM 		simplewiki_p.logging AS SIMPLE_L, simplewiki_p.user AS SIMPLE_U
  	GROUP BY 	SIMPLE_L.log_user
  	ORDER BY 	COUNT(SIMPLE_U.user_editcount / COUNT(SIMPLE_L.log_user)) DESC
  	LIMIT		3
)
UNION
( 
	SELECT 		'Esperanto' AS IAL, EO_L.log_user AS 'User ID', COUNT(EO_L.log_user) AS 'Contributions in Esperanto'
	FROM 		eowiki_p.logging AS EO_L
  	GROUP BY 	EO_L.log_user
  	ORDER BY 	COUNT(EO_L.log_user) DESC
  	LIMIT		3
)
UNION
( 
  	SELECT 		'Ido' AS IAL, IO_L.log_user AS 'User ID', COUNT(IO_L.log_user) AS 'Contributions in Ido'
  	FROM 		iowiki_p.logging AS IO_L
  	GROUP BY 	IO_L.log_user
  	ORDER BY 	COUNT(IO_L.log_user) DESC
  	LIMIT		3
)
UNION
( 
  	SELECT 		'Interlingua' AS IAL, IA_L.log_user AS 'User ID', COUNT(IA_L.log_user) AS 'Contributions in Interlingua'
  	FROM 		iawiki_p.logging AS IA_L
  	GROUP BY 	IA_L.log_user
  	ORDER BY 	COUNT(IA_L.log_user) DESC
  	LIMIT		3
)
UNION
( 
  	SELECT 		'Novial' AS IAL, NOV_L.log_user AS 'User ID', COUNT(NOV_L.log_user) AS 'Contributions in Novial'
  	FROM 		novwiki_p.logging AS NOV_L
  	GROUP BY 	NOV_L.log_user
  	ORDER BY 	COUNT(NOV_L.log_user) DESC
  	LIMIT		3
)
UNION
( 
  	SELECT 		'Interlingue' AS IAL, IE_L.log_user AS 'User ID', COUNT(IE_L.log_user) AS 'Contributions in Interlingue'
  	FROM 		iewiki_p.logging AS IE_L
  	GROUP BY 	IE_L.log_user
  	ORDER BY 	COUNT(IE_L.log_user) DESC
  	LIMIT		3
)
UNION
( 
  	SELECT 		'Volapük' AS IAL, VO_L.log_user AS 'User ID', COUNT(VO_L.log_user) AS 'Contributions in Volapük'
  	FROM 		vowiki_p.logging AS VO_L
  	GROUP BY 	VO_L.log_user
  	ORDER BY 	COUNT(VO_L.log_user) DESC
  	LIMIT		3
);
SQL

Checking query status...
