USE zhwiki_p;

SELECT 

rev_timestamp, rev_id, rev_actor, actor_name, user_registration, user_editcount, ug_group

FROM revision

LEFT JOIN actor ON rev_actor = actor_id

LEFT JOIN user ON actor_user = user_id

LEFT JOIn user_groups ON user_id = ug_user AND ug_group IN ('patroller', 'sysop', 'bot', 'autoreviewer')

WHERE revision.rev_timestamp > '20200301000000'

    AND revision.rev_timestamp < '20200308000000'

ORDER BY revision.rev_timestamp DESC

LIMIT 100;