[2021] Wikidata for authorities, SHM and Nationalmuseum users

SQL

SELECT actor.actor_name as Username,
       COUNT(distinct page.page_id) AS cnt
FROM page
JOIN revision ON page.page_id=revision.rev_page
JOIN actor ON revision.rev_actor=actor.actor_id
WHERE actor.actor_name in (
'Azad Karimi',
'Elinor Rajka',
'Eva L Vedin',
'Karin Glasemann, Nationalmuseum',
'LinneaKarlberg',
'Elinmeriksson',
'Vallgren S'
)
AND revision.rev_timestamp > '20210101000000'
AND revision.rev_timestamp < '20211231235900'
AND page.page_namespace=0 # item namespace
GROUP BY actor.actor_name
ORDER BY actor.actor_name

SQL

Checking query status...