Creators of Old Irish entries

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.

SQL

set @language = 'Old_Irish';

select actor_name as `user`, count(*) as `entries created` from categorylinks
join revision on rev_page = cl_from
join actor on actor_id = rev_actor
where cl_to in (concat(@language, '_lemmas'), concat(@language, '_non-lemma_forms'))
and cl_type = 'page'
and rev_parent_id = 0
group by actor_id
order by `entries created` desc;

SQL

Checking query status...