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

SQL

AخA
 
select count(rc_id) as user_editcount, u.user_name, up.up_value, recentchanges.rc_type
from recentchanges
left join
    actor
        ON (
            recentchanges.rc_actor=actor.actor_id
            )
left join
    user u
        ON (
            actor.actor_user=u.user_id
            )
left join
    user_properties up
        ON (
            u.user_id=up.up_user
            and up_property = "gender"
        )
left join
        user_groups ug
            on (
                u.user_id=ug.ug_user
                and ug_group = "bot"
            )
    left join
        user_former_groups ufg
            on (
              u.user_id=ufg.ufg_user
              and ufg_group = "bot"
            )
    WHERE
        ug_group is null and ufg_group is null
    AND
    recentchanges.rc_type < 3
GROUP BY recentchanges.rc_actor
ORDER BY
    user_editcount desc
limit 10000
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.

Checking query status...