Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Erutuon
.
Naive version of a count of how many Old Irish entries were created by each editor on English Wiktionary. In more precise terms, editors of first revisions of pages in the Old Irish lemma and non-lemma forms category with the number of pages they had the first revision of. This is naive because many pages that have an Old Irish entry have entries for other languages, and the correct definition of "creators of Old Irish entries" would be the editors of the first revision that had the Old Irish language header in it. That is harder and cannot be done using Quarry. It requires retrieving revisions of current Old Irish entries from the MediaWiki API.
Toggle Highlighting
SQL
use enwiktionary_p; select * from categorylinks join page on page_id = cl_from where cl_to in ('Old_Irish_lemmas', 'Old_Irish_non-lemma_forms') and cl_type = 'page' limit 10;
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...