Articles and Articles/Editors ratio in IALs projects

SQL

SELECT 	'IAL', 'Articles', 'Editors per Article Ratio'

UNION ALL

SELECT 	'Simple English', COUNT(DISTINCT p.page_id), COUNT(DISTINCT p.page_id) / COUNT(DISTINCT u.user_id)
FROM 	simplewiki_p.page AS p, simplewiki_p.user AS u

UNION ALL

SELECT 	'Esperanto', COUNT(DISTINCT p.page_id), COUNT(DISTINCT p.page_id) / COUNT(DISTINCT u.user_id)
FROM 	eowiki_p.page AS p, eowiki_p.user AS u

UNION ALL

SELECT 	'Ido', COUNT(DISTINCT p.page_id), COUNT(DISTINCT p.page_id) / COUNT(DISTINCT u.user_id)
FROM 	iowiki_p.page AS p, iowiki_p.user AS u

UNION ALL

SELECT 	'Interlingua', COUNT(DISTINCT p.page_id), COUNT(DISTINCT p.page_id) / COUNT(DISTINCT u.user_id)
FROM 	iawiki_p.page AS p, iawiki_p.user AS u

UNION ALL

SELECT 	'Novial', COUNT(DISTINCT p.page_id), COUNT(DISTINCT p.page_id) / COUNT(DISTINCT u.user_id)
FROM 	novwiki_p.page AS p, novwiki_p.user AS u

UNION ALL

SELECT 	'Interlingue', COUNT(DISTINCT p.page_id), COUNT(DISTINCT p.page_id) / COUNT(DISTINCT u.user_id)
FROM 	iewiki_p.page AS p, iewiki_p.user AS u

UNION ALL

SELECT 	'Volapük', COUNT(DISTINCT p.page_id), COUNT(DISTINCT p.page_id) / COUNT(DISTINCT u.user_id)
FROM 	vowiki_p.page AS p, vowiki_p.user AS u;
SQL

Checking query status...
