Tewiki: F e m a l e e d i t o r s

SQL

select user_name,concat(substr(max(rev_timestamp),1,4),"-",substr(max(rev_timestamp),5,2)"-",substr(max(rev_timestamp),7,2)) last_edit_date,concat(substr(max(rev_timestamp),1,4),"-",substr(user_registration,5,2),"-",substr(user_registration,7,2)) Registration_date,user_editcount Total_edits,count(rev_actor) Articles_created from revision,page,actor,user,user_properties
where 
rev_parent_id=0
and page_namespace=0
and page_id=rev_page
and page_is_redirect=0
and page_id not in (select pp_page from page_props where pp_propname="disambiguation") 
and actor_id=rev_actor
and user_id=actor_user
and up_user=user_id
and up_property="gender"
and up_value="female"
group by rev_actor
order by user_editcount desc
SQL

Checking query status...
