SQL
AخA
SELECT COUNT(*)
FROM page, revision_userindex, actor
WHERE page_title = 'Fragen_zur_Wikipedia' # Leerzeichen im Lemma durch Unterstrich ersetzen
AND page_namespace = 4 # Siehe https://de.wikipedia.org/wiki/Hilfe:Namensräume
AND rev_page = page_id
AND rev_timestamp BETWEEN '20210101000000' AND '20220101000000' # Format: YYYYTTMMHHMMSS
AND rev_actor = actor_id
AND actor_name = 'Anselm Rapp' # Hier leerzeichen nicht ersetzen!
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.