Replicas browser and optimizer
This query is marked as a draft
This query has been published
most active editors in main without bots pl.wikipedia 2017
use plwiki_p; select CONCAT("# [[:pl:Wikipedysta:", user_name, "|", user_name, "]]") as wikipedysta, count(*) c from revision as edycje join user on rev_user=user_id join page on rev_page=page_id where page_namespace = 0 and rev_timestamp BETWEEN "20170101" AND "20171231" and rev_user in (select ug_user from user_groups where ug_group != "bot") # join user_groups on user_id=ug_user group by rev_user order by c desc LIMIT 5000
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