Replicas browser and optimizer
Bengali Wikipedia editors sorted by number of edits registered in 2019-10
This query is marked as a draft
This query has been published
use bnwiki_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 20191000000000 and 20191100000000 and rev_timestamp > 20190300000000 and rev_actor = actor_id and user_properties.up_value is not null group by rev_actor having count(rev_id) between 1 and 40000 order by edit_count desc;
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in