USE zhwiki_p;

SELECT COUNT(*)

FROM revision

LEFT JOIN actor ON rev_actor = actor_id

LEFT JOIN user ON actor_user = user_id

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

WHERE revision.rev_timestamp > '20200301000000'

    AND revision.rev_timestamp < '20200308000000'

    AND ug_group IS NULL

    AND user_registration < '20200201000000'

    AND user_editcount >= 500

​