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

SQL

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

Checking query status...
