Articles and Articles/Editors ratio in IALs projects

SQL

set @se_p = (SELECT COUNT(DISTINCT page_id) FROM simplewiki_p.page),
	@se_r = (SELECT COUNT(DISTINCT rev_user) FROM simplewiki_p.revision),
        
	@eo_p = (SELECT COUNT(DISTINCT page_id) FROM eowiki_p.page),
 	@eo_r = (SELECT COUNT(DISTINCT rev_user) FROM eowiki_p.revision),
        
   	@io_p = (SELECT COUNT(DISTINCT page_id) FROM iowiki_p.page),
  	@io_r = (SELECT COUNT(DISTINCT rev_user) FROM iowiki_p.revision),
        
  	@ia_p = (SELECT COUNT(DISTINCT page_id) FROM iawiki_p.page),
	@ia_r = (SELECT COUNT(DISTINCT rev_user) FROM iawiki_p.revision),
        
	@nov_p = (SELECT COUNT(DISTINCT page_id) FROM novwiki_p.page),
	@nov_r = (SELECT COUNT(DISTINCT rev_user) FROM novwiki_p.revision),
        
	@ie_p = (SELECT COUNT(DISTINCT page_id) FROM iewiki_p.page),
	@ie_r = (SELECT COUNT(DISTINCT rev_user) FROM iewiki_p.revision),
        
	@vo_p = (SELECT COUNT(DISTINCT page_id) FROM vowiki_p.page),
	@vo_r = (SELECT COUNT(DISTINCT rev_user) FROM vowiki_p.revision);

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

UNION ALL

SELECT 	'Simple English', @se_p, @se_p / @se_r

UNION ALL

SELECT 	'Esperanto', @eo_p, @eo_p / @eo_r

UNION ALL

SELECT 	'Ido', @io_p, @io_p / @io_pr

UNION ALL

SELECT 	'Interlingua', @ia_p, @ia_p / @ia_r

UNION ALL

SELECT 	'Novial', @nov_p, @nov_p / @nov_r

UNION ALL

SELECT 	'Interlingue', @ie_p, @ie_p / @ie_r

UNION ALL

SELECT 	'Volapük', @vo_p, @vo_p / @vo_r;
SQL

Checking query status...
