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.