Untitled query #13615

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

SELECT 'huwiki' AS wiki, '100+' as editor_group, count(distinct(rc_user_text)) as users, sum(c) as total_edits, round(avg(c)) AS avg_edits FROM (SELECT sum(1) as c,rc_user_text FROM huwiki_p.recentchanges_userindex WHERE rc_user>0 AND rc_bot=0 AND rc_namespace =0 AND rc_source ="mw.edit" group by rc_user_text) AS t WHERE c > 100
UNION
SELECT 'hewiki' AS wiki, '100+' as editor_group, count(distinct(rc_user_text)) as users, sum(c) as total_edits, round(avg(c)) AS avg_edits FROM (SELECT sum(1) as c,rc_user_text FROM hewiki_p.recentchanges_userindex WHERE rc_user>0 AND rc_bot=0 AND rc_namespace =0 AND rc_source ="mw.edit" group by rc_user_text) AS t WHERE c > 100
UNION
SELECT 'dawiki' AS wiki, '100+' as editor_group, count(distinct(rc_user_text)) as users, sum(c) as total_edits, round(avg(c)) AS avg_edits FROM (SELECT sum(1) as c,rc_user_text FROM dawiki_p.recentchanges_userindex WHERE rc_user>0 AND rc_bot=0 AND rc_namespace =0 AND rc_source ="mw.edit" group by rc_user_text) AS t WHERE c > 100
UNION
SELECT 'nowiki' AS wiki, '100+' as editor_group, count(distinct(rc_user_text)) as users, sum(c) as total_edits, round(avg(c)) AS avg_edits FROM (SELECT sum(1) as c,rc_user_text FROM nowiki_p.recentchanges_userindex WHERE rc_user>0 AND rc_bot=0 AND rc_namespace =0 AND rc_source ="mw.edit" group by rc_user_text) AS t WHERE c > 100
UNION
SELECT 'svwiki' AS wiki, '100+' as editor_group, count(distinct(rc_user_text)) as users, sum(c) as total_edits, round(avg(c)) AS avg_edits FROM (SELECT sum(1) as c,rc_user_text FROM svwiki_p.recentchanges_userindex WHERE rc_user>0 AND rc_bot=0 AND rc_namespace =0 AND rc_source ="mw.edit" group by rc_user_text) AS t WHERE c > 100
UNION
SELECT 'fiwiki' AS wiki, '100+' as editor_group, count(distinct(rc_user_text)) as users, sum(c) as total_edits, round(avg(c)) AS avg_edits FROM (SELECT sum(1) as c,rc_user_text FROM fiwiki_p.recentchanges_userindex WHERE rc_user>0 AND rc_bot=0 AND rc_namespace =0 AND rc_source ="mw.edit" group by rc_user_text) AS t WHERE c > 100
UNION
SELECT 'huwiki' AS wiki, '5+' as editor_group, count(distinct(rc_user_text)) as users, sum(c) as total_edits, round(avg(c)) AS avg_edits FROM (SELECT sum(1) as c,rc_user_text FROM huwiki_p.recentchanges_userindex WHERE rc_user>0 AND rc_bot=0 AND rc_namespace =0 AND rc_source ="mw.edit" group by rc_user_text) AS t WHERE c > 5
UNION
SELECT 'hewiki' AS wiki, '5+' as editor_group, count(distinct(rc_user_text)) as users, sum(c) as total_edits, round(avg(c)) AS avg_edits FROM (SELECT sum(1) as c,rc_user_text FROM hewiki_p.recentchanges_userindex WHERE rc_user>0 AND rc_bot=0 AND rc_namespace =0 AND rc_source ="mw.edit" group by rc_user_text) AS t WHERE c > 5
UNION
SELECT 'dawiki' AS wiki, '5+' as editor_group, count(distinct(rc_user_text)) as users, sum(c) as total_edits, round(avg(c)) AS avg_edits FROM (SELECT sum(1) as c,rc_user_text FROM dawiki_p.recentchanges_userindex WHERE rc_user>0 AND rc_bot=0 AND rc_namespace =0 AND rc_source ="mw.edit" group by rc_user_text) AS t WHERE c > 5
UNION
SELECT 'nowiki' AS wiki, '5+' as editor_group, count(distinct(rc_user_text)) as users, sum(c) as total_edits, round(avg(c)) AS avg_edits FROM (SELECT sum(1) as c,rc_user_text FROM nowiki_p.recentchanges_userindex WHERE rc_user>0 AND rc_bot=0 AND rc_namespace =0 AND rc_source ="mw.edit" group by rc_user_text) AS t WHERE c > 5
UNION
SELECT 'svwiki' AS wiki, '5+' as editor_group, count(distinct(rc_user_text)) as users, sum(c) as total_edits, round(avg(c)) AS avg_edits FROM (SELECT sum(1) as c,rc_user_text FROM svwiki_p.recentchanges_userindex WHERE rc_user>0 AND rc_bot=0 AND rc_namespace =0 AND rc_source ="mw.edit" group by rc_user_text) AS t WHERE c > 5
UNION
SELECT 'fiwiki' AS wiki, '5+' as editor_group, count(distinct(rc_user_text)) as users, sum(c) as total_edits, round(avg(c)) AS avg_edits FROM (SELECT sum(1) as c,rc_user_text FROM fiwiki_p.recentchanges_userindex WHERE rc_user>0 AND rc_bot=0 AND rc_namespace =0 AND rc_source ="mw.edit" group by rc_user_text) AS t WHERE c > 5
UNION
SELECT 'huwiki' AS wiki, '1+' as editor_group, count(distinct(rc_user_text)) as users, sum(c) as total_edits, round(avg(c)) AS avg_edits FROM (SELECT sum(1) as c,rc_user_text FROM huwiki_p.recentchanges_userindex WHERE rc_user>0 AND rc_bot=0 AND rc_namespace =0 AND rc_source ="mw.edit" group by rc_user_text) AS t WHERE c > 1
UNION
SELECT 'hewiki' AS wiki, '1+' as editor_group, count(distinct(rc_user_text)) as users, sum(c) as total_edits, round(avg(c)) AS avg_edits FROM (SELECT sum(1) as c,rc_user_text FROM hewiki_p.recentchanges_userindex WHERE rc_user>0 AND rc_bot=0 AND rc_namespace =0 AND rc_source ="mw.edit" group by rc_user_text) AS t WHERE c > 1
UNION
SELECT 'dawiki' AS wiki, '1+' as editor_group, count(distinct(rc_user_text)) as users, sum(c) as total_edits, round(avg(c)) AS avg_edits FROM (SELECT sum(1) as c,rc_user_text FROM dawiki_p.recentchanges_userindex WHERE rc_user>0 AND rc_bot=0 AND rc_namespace =0 AND rc_source ="mw.edit" group by rc_user_text) AS t WHERE c > 1
UNION
SELECT 'nowiki' AS wiki, '1+' as editor_group, count(distinct(rc_user_text)) as users, sum(c) as total_edits, round(avg(c)) AS avg_edits FROM (SELECT sum(1) as c,rc_user_text FROM nowiki_p.recentchanges_userindex WHERE rc_user>0 AND rc_bot=0 AND rc_namespace =0 AND rc_source ="mw.edit" group by rc_user_text) AS t WHERE c > 1
UNION
SELECT 'svwiki' AS wiki, '1+' as editor_group, count(distinct(rc_user_text)) as users, sum(c) as total_edits, round(avg(c)) AS avg_edits FROM (SELECT sum(1) as c,rc_user_text FROM svwiki_p.recentchanges_userindex WHERE rc_user>0 AND rc_bot=0 AND rc_namespace =0 AND rc_source ="mw.edit" group by rc_user_text) AS t WHERE c > 1
UNION
SELECT 'fiwiki' AS wiki, '1+' as editor_group, count(distinct(rc_user_text)) as users, sum(c) as total_edits, round(avg(c)) AS avg_edits FROM (SELECT sum(1) as c,rc_user_text FROM fiwiki_p.recentchanges_userindex WHERE rc_user>0 AND rc_bot=0 AND rc_namespace =0 AND rc_source ="mw.edit" group by rc_user_text) AS t WHERE c > 1
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...
