Untitled query #31572

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

SELECT * FROM
( 
  	SELECT 		user_id AS User_ID
  	FROM 		user
  	LIMIT		31000000,1000000
) AS Users
LEFT OUTER JOIN
( 
  	SELECT 		simple_usr.user_id AS User_ID, simple_usr.user_editcount AS Contributions_in_Simple_English
  	FROM 		simplewiki_p.user AS simple_usr
  	LIMIT		31000000,1000000
) AS Simple_English USING (User_ID)
LEFT OUTER JOIN
( 
	SELECT 		eo_usr.user_id AS User_ID, eo_usr.user_editcount AS Contributions_in_Esperanto
	FROM 		eowiki_p.user AS eo_usr
  	LIMIT		31000000,1000000
) AS Esperanto USING (User_ID)
LEFT OUTER JOIN
( 
  	SELECT 		io_usr.user_id AS User_ID, io_usr.user_editcount AS Contributions_in_Ido
  	FROM 		iowiki_p.user AS io_usr
  	LIMIT		31000000,1000000
) AS Ido USING (User_ID)
LEFT OUTER JOIN
( 
  	SELECT 		ia_usr.user_id AS User_ID, ia_usr.user_editcount AS Contributions_in_Interlingua
  	FROM 		iawiki_p.user AS ia_usr
  	LIMIT		31000000,1000000
) AS Interlingua USING (User_ID)
LEFT OUTER JOIN
( 
  	SELECT 		nov_usr.user_id AS User_ID, nov_usr.user_editcount AS Contributions_in_Novial
  	FROM 		novwiki_p.user AS nov_usr
  	LIMIT		31000000,1000000
) AS Novial USING (User_ID)
LEFT OUTER JOIN
( 
  	SELECT 		ie_usr.user_id AS User_ID, ie_usr.user_editcount AS Contributions_in_Interlingue
  	FROM 		iewiki_p.user AS ie_usr
  	LIMIT		31000000,1000000
) AS Interlingue USING (User_ID)
LEFT OUTER JOIN
( 
  	SELECT 		vo_usr.user_id AS User_ID, vo_usr.user_editcount AS Contributions_in_Volapük
  	FROM 		vowiki_p.user AS vo_usr
  	LIMIT		31000000,1000000
) AS Volapük USING (User_ID)
LEFT OUTER JOIN
( 
  	SELECT 		en_user.user_id AS User_ID, en_user.user_editcount AS Contributions_in_English
  	FROM 		enwiki_p.user AS en_user
  	LIMIT		31000000,1000000
) AS English USING (User_ID)
LEFT OUTER JOIN
( 
  	SELECT 		ceb_user.user_id AS User_ID, ceb_user.user_editcount AS Contributions_in_Cebuano
  	FROM 		cebwiki_p.user AS ceb_user
  	LIMIT		31000000,1000000
) AS Cebuano USING (User_ID)
LEFT OUTER JOIN
( 
  	SELECT 		sv_user.user_id AS User_ID, sv_user.user_editcount AS Contributions_in_Swedish
  	FROM 		svwiki_p.user AS sv_user
  	LIMIT		31000000,1000000
) AS Swedish USING (User_ID)
LEFT OUTER JOIN
( 
  	SELECT 		de_user.user_id AS User_ID, de_user.user_editcount AS Contributions_in_German
  	FROM 		dewiki_p.user AS de_user
  	LIMIT		31000000,1000000
) AS German USING (User_ID)
LEFT OUTER JOIN
( 
  	SELECT 		fr_user.user_id AS User_ID, fr_user.user_editcount AS Contributions_in_French
  	FROM 		frwiki_p.user AS fr_user
  	LIMIT		31000000,1000000
) AS French USING (User_ID)
LEFT OUTER JOIN
( 
  	SELECT 		nl_user.user_id AS User_ID, nl_user.user_editcount AS Contributions_in_Dutch
  	FROM 		nlwiki_p.user AS nl_user
  	LIMIT		31000000,1000000
) AS Dutch USING (User_ID)
LEFT OUTER JOIN
( 
  	SELECT 		ru_user.user_id AS User_ID, ru_user.user_editcount AS Contributions_in_Russian
  	FROM 		ruwiki_p.user AS ru_user
  	LIMIT		31000000,1000000
) AS Russian USING (User_ID)
LEFT OUTER JOIN
( 
  	SELECT 		es_user.user_id AS User_ID, es_user.user_editcount AS Contributions_in_Spanish
  	FROM 		eswiki_p.user AS es_user
  	LIMIT		31000000,1000000
) AS Spanish USING (User_ID)
LEFT OUTER JOIN
( 
  	SELECT 		it_user.user_id AS User_ID, it_user.user_editcount AS Contributions_in_Italian
  	FROM 		itwiki_p.user AS it_user
  	LIMIT		31000000,1000000
) AS Italian USING (User_ID)
LEFT OUTER JOIN
( 
  	SELECT 		pl_user.user_id AS User_ID, pl_user.user_editcount AS Contributions_in_Polish
  	FROM 		plwiki_p.user AS pl_user
  	LIMIT		31000000,1000000
) AS Polish USING (User_ID)
LEFT OUTER JOIN
( 
  	SELECT 		war_user.user_id AS User_ID, war_user.user_editcount AS Contributions_in_Waray
  	FROM 		warwiki_p.user AS war_user
  	LIMIT		31000000,1000000
) AS Waray USING (User_ID)
LEFT OUTER JOIN
( 
  	SELECT 		vi_user.user_id AS User_ID, vi_user.user_editcount AS Contributions_in_Vietnamese
  	FROM 		viwiki_p.user AS vi_user
  	LIMIT		31000000,1000000
) AS Vietnamese USING (User_ID)
LEFT OUTER JOIN
( 
  	SELECT 		ja_user.user_id AS User_ID, ja_user.user_editcount AS Contributions_in_Japanese
  	FROM 		jawiki_p.user AS ja_user
  	LIMIT		31000000,1000000
) AS Japanese USING (User_ID)
LEFT OUTER JOIN
( 
  	SELECT 		zh_user.user_id AS User_ID, zh_user.user_editcount AS Contributions_in_Chinese
  	FROM 		zhwiki_p.user AS zh_user
  	LIMIT		31000000,1000000
) AS Chinese USING (User_ID)
LEFT OUTER JOIN
( 
  	SELECT 		pt_user.user_id AS User_ID, pt_user.user_editcount AS Contributions_in_Portuguese
  	FROM 		ptwiki_p.user AS pt_user
  	LIMIT		31000000,1000000
) AS Portuguese USING (User_ID);
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...
