[2023] 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',
'LinneaKarlberg',
'Elinmeriksson',
'Vallgren S',
'IdaNordlandershm'
)
AND revision.rev_timestamp > '20230101000000'
AND revision.rev_timestamp < '20231231235900'
AND page.page_namespace=0 # item namespace
GROUP BY actor.actor_name
ORDER BY actor.actor_name

SQL

Checking query status...