Editors of wiki using IALs ranked by number of contributions.

SQL

SELECT p.page_lang AS 'IAL', l.log_user AS 'User ID', COUNT(l.log_page) AS 'Number of Contributions'
FROM page AS p, logging AS l
WHERE 	( l.log_page IN ( SELECT page_id FROM page WHERE page_lang = 'simple' ) AND p.page_lang = 'simple' ) OR
		( l.log_page IN ( SELECT page_id FROM page WHERE page_lang = 'eo' ) AND p.page_lang = 'eo' ) OR
        ( l.log_page IN ( SELECT page_id FROM page WHERE page_lang = 'io' ) AND p.page_lang = 'io' ) OR
        ( l.log_page IN ( SELECT page_id FROM page WHERE page_lang = 'ia' ) AND p.page_lang = 'ia' ) OR
        ( l.log_page IN ( SELECT page_id FROM page WHERE page_lang = 'nov' ) AND p.page_lang = 'nov' ) OR
        ( l.log_page IN ( SELECT page_id FROM page WHERE page_lang = 'ie' ) AND p.page_lang = 'ie' ) OR
        ( l.log_page IN ( SELECT page_id FROM page WHERE page_lang = 'vo' ) AND p.page_lang = 'vo' )
ORDER BY p.page_lang, COUNT(l.log_page) DESC;
SQL

Checking query status...
