Telugu Wiki User Reg Date and Edit Count

SQL

use tewiki_p;

select
	rev_actor,
    actor_name,
	count(rev_id) as edit_count,
    substr(user_registration, 1, 8) as registration_date,
    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
    user_registration between 20001000000000 and 20201100000000 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...
