wikidata: anon edits in property namespace

SQL

USE wikidatawiki_p;

SELECT
	SUBSTR(revision.rev_timestamp, 1, 8) AS bucket,
    COUNT(revision.rev_id) AS cnt
FROM
	revision JOIN actor_revision ON actor_revision.actor_id=revision.rev_actor
WHERE
	revision.rev_page IN (SELECT page_id FROM page WHERE page_namespace=120)
    AND actor_revision.actor_user IS NULL
GROUP BY
	bucket;
    
# SELECT
#	revision.rev_page,
#    COUNT(revision.rev_id) AS cnt
#FROM
#	revision JOIN actor_revision ON actor_revision.actor_id=revision.rev_actor
#WHERE
#	revision.rev_page IN (SELECT page_id FROM page WHERE page_namespace=120)
#    AND actor_revision.actor_user IS NULL
#GROUP BY
#	revision.rev_page;

SQL

Checking query status...