Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Teibit
.
We want a table that for each IAL lists all users that edit on the website and the number of contributions they’ve made in descending order.
Toggle Highlighting
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 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 );
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...