he.wikipedia.org active users by gender

Fork of pt.wikipedia.org active users by gender by CalliandraDysantha

This query is marked as a draft This query has been published by מקף.

SQL

select count(rc_id) as כמות_עריכות_שביצעו, count(distinct u.user_id) as כמות_משתמשים, up.up_value AS מגדר
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 != 5
GROUP BY up.up_value
ORDER BY
    user_editcount desc;

SQL

Checking query status...