Telugu Wiki User Reg Date and Edit Count

SQL

use tewiki_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 400000
order by
    edit_count desc;

SQL

Checking query status...