Replicas browser and optimizer
This query is marked as a draft
This query has been published
most edited pl.wiktionary articles 2017 based on [[:en:User:EpochFail/Top edits 2017]]
USE plwiktionary_p; SELECT REPLACE(page_title, "_", " ") AS article, edits FROM ( SELECT rev_page, COUNT(*) AS edits FROM revision WHERE rev_timestamp BETWEEN "20170101" AND "20171231" GROUP BY rev_page ORDER BY edits DESC LIMIT 3000 ) AS top_page_edits INNER JOIN page ON rev_page = page_id WHERE page_namespace = 0 ORDER BY edits 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