SQL
AخA
use huwiki_p;
select rev_user_text, sum(cnt)
from
(
select rev_user_text, count(rev_id) as cnt
from revision join tag_summary on rev_id=ts_rev_id
where ts_tags='mw-rollback' and rev_timestamp > '20180401000000' and rev_timestamp<'20180415000000'
group by rev_user_text
union
SELECT
log_user_text user,
count(*) as cnt
FROM
logging
WHERE
log_type = 'review'
AND log_action IN ('approve', 'approve2', 'approve-i', 'approve2-i')
AND log_timestamp > '20180401000000' and log_timestamp<'20180415000000'
GROUP BY log_user
) as T
group by rev_user_text
order by sum(cnt) desc
;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.