use hiwiki_p;

​

select

    rev_actor,

    actor_name,

    user_editcount, 

    user_registration, 

    rev_timestamp AS 'Last edit',

    count(rev_id) as edit_count,

    user_properties.up_value as gender

from

    revision,

    actor,

    user

left join

  user_properties on (

    user.user_id = user_properties.up_user and

    user_properties.up_property = 'gender'

  )

where

    actor_user = user_id and

    rev_timestamp > 20000300000000 and

    rev_actor = actor_id and

    user_properties.up_value is not null

group by

    rev_actor

having

    count(rev_id) between 1 and 4000000

order by

    edit_count desc;