Untitled query #35198

This query is marked as a draft This query has been published by Teibit.
SQL

SELECT * FROM 
( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Simple_English FROM simplewiki_p.revision GROUP BY rev_user ) AS Users 
LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_English FROM enwiki_p.revision GROUP BY rev_user ) AS English USING (User) 
LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Swedish FROM svwiki_p.revision GROUP BY rev_user ) AS Swedish USING (User) 
LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_German FROM dewiki_p.revision GROUP BY rev_user ) AS German USING (User) 
LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_French FROM frwiki_p.revision GROUP BY rev_user ) AS French USING (User) 
LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Dutch FROM nlwiki_p.revision GROUP BY rev_user ) AS Dutch USING (User) 
LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Russian FROM ruwiki_p.revision GROUP BY rev_user ) AS Russian USING (User) 
LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Italian FROM itwiki_p.revision GROUP BY rev_user ) AS Italian USING (User) 
LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Spanish FROM eswiki_p.revision GROUP BY rev_user ) AS Spanish USING (User) 
LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Polish FROM plwiki_p.revision GROUP BY rev_user ) AS Polish USING (User) 
LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Waray FROM warwiki_p.revision GROUP BY rev_user ) AS Waray USING (User) 
LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Vietnamese FROM viwiki_p.revision GROUP BY rev_user ) AS Vietnamese USING (User) 
LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Japanese FROM jawiki_p.revision GROUP BY rev_user ) AS Japanese USING (User) 
LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Chinese FROM zhwiki_p.revision GROUP BY rev_user ) AS Chinese USING (User) 
LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Portuguese FROM ptwiki_p.revision GROUP BY rev_user ) AS Portuguese USING (User) 
LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Ukrainian FROM ukwiki_p.revision GROUP BY rev_user ) AS Ukrainian USING (User) 
LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Arabic FROM arwiki_p.revision GROUP BY rev_user ) AS Arabic USING (User) 
LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Persian FROM fawiki_p.revision GROUP BY rev_user ) AS Persian USING (User) 
LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Serbian FROM srwiki_p.revision GROUP BY rev_user ) AS Serbian USING (User) LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Catalan FROM cawiki_p.revision GROUP BY rev_user ) AS Catalan USING (User) LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Norwegian_Bokmål FROM nowiki_p.revision GROUP BY rev_user ) AS Norwegian_(Bokmål) USING (User) LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Indonesian FROM idwiki_p.revision GROUP BY rev_user ) AS Indonesian USING (User) LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Finnish FROM fiwiki_p.revision GROUP BY rev_user ) AS Finnish USING (User) LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Korean FROM kowiki_p.revision GROUP BY rev_user ) AS Korean USING (User) LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Serbo_Croatian FROM shwiki_p.revision GROUP BY rev_user ) AS Serbo_Croatian USING (User) LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Hungarian FROM huwiki_p.revision GROUP BY rev_user ) AS Hungarian USING (User) LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Czech FROM cswiki_p.revision GROUP BY rev_user ) AS Czech USING (User) LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Romanian FROM rowiki_p.revision GROUP BY rev_user ) AS Romanian USING (User) LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Basque FROM euwiki_p.revision GROUP BY rev_user ) AS Basque USING (User) LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Malay FROM mswiki_p.revision GROUP BY rev_user ) AS Malay USING (User) LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Turkish FROM trwiki_p.revision GROUP BY rev_user ) AS Turkish USING (User) LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Armenian FROM hywiki_p.revision GROUP BY rev_user ) AS Armenian USING (User) LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Bulgarian FROM bgwiki_p.revision GROUP BY rev_user ) AS Bulgarian USING (User) LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Danish FROM dawiki_p.revision GROUP BY rev_user ) AS Danish USING (User) LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Hebrew FROM hewiki_p.revision GROUP BY rev_user ) AS Hebrew USING (User) LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Slovak FROM skwiki_p.revision GROUP BY rev_user ) AS Slovak USING (User) LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Min_Nan FROM zh_min_nanwiki_p.revision GROUP BY rev_user ) AS Min_Nan USING (User) LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Kazakh FROM kkwiki_p.revision GROUP BY rev_user ) AS Kazakh USING (User) LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Minangkabau FROM minwiki_p.revision GROUP BY rev_user ) AS Minangkabau USING (User) LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Chechen FROM cewiki_p.revision GROUP BY rev_user ) AS Chechen USING (User) LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Croatian FROM hrwiki_p.revision GROUP BY rev_user ) AS Croatian USING (User) LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Lithuanian FROM ltwiki_p.revision GROUP BY rev_user ) AS Lithuanian USING (User) LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Estonian FROM etwiki_p.revision GROUP BY rev_user ) AS Estonian USING (User) LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Belarusian FROM bewiki_p.revision GROUP BY rev_user ) AS Belarusian USING (User) LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Slovenian FROM slwiki_p.revision GROUP BY rev_user ) AS Slovenian USING (User) LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Greek FROM elwiki_p.revision GROUP BY rev_user ) AS Greek USING (User) LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Galician FROM glwiki_p.revision GROUP BY rev_user ) AS Galician USING (User) LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Azerbaijani FROM azwiki_p.revision GROUP BY rev_user ) AS Azerbaijani USING (User) LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Urdu FROM urwiki_p.revision GROUP BY rev_user ) AS Urdu USING (User) LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Norwegian_Nynorsk FROM nnwiki_p.revision GROUP BY rev_user ) AS Norwegian_(Nynorsk) USING (User) LEFT OUTER JOIN ( SELECT DISTINCT rev_user AS User, count(*) AS Contributions_in_Southern_Azerbaijani FROM azbwiki_p.revision GROUP BY rev_user ) AS Southern_Azerbaijani USING (User)
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.
SQL

Checking query status...
