SQL
AخA
use jawiki_p;
select left(rev_timestamp, 6) as month, ifnull(ufg_group, ug_group)
from revision_userindex
left outer join user_former_groups on rev_user = ufg_user and ufg_group = "bot"
left outer join user_groups on rev_user = ug_user and ug_group = "bot"
where
(
date( rev_timestamp ) between "2018-01-01" and "2018-05-30"
) and
rev_user != 0
group by left(rev_timestamp, 6), ifnull(ufg_group, ug_group)
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.