dewiki: Wikiprojekt_Österreich subpages with Wikidata item

Fork of dewiki: Artikelwerkstatt pages with Wikidata item by MisterSynergy

This query is marked as a draft This query has been published by MisterSynergy.

SQL

#USE dewiki_p; # <-- change wiki here!

#SELECT
#    p.page_title,
#    pp.pp_value
#FROM
#    page p JOIN page_props pp ON p.page_id=pp.pp_page
#WHERE
#    p.page_namespace=4
#    AND p.page_title LIKE 'WikiProjekt_Österreich/%'
#    AND pp.pp_propname='wikibase_item';

USE wikidatawiki_p;

SELECT
	actor_name,
	COUNT(rev_id) AS creations
FROM
	revision JOIN actor ON rev_actor=actor_id JOIN page ON rev_page=page_id
WHERE
	rev_parent_id=0
	AND rev_page IN (
        SELECT
      		page_id
      	FROM
      		page
      	WHERE
      		page_namespace=0
      		AND page_title IN (
              	'Q78050878', 'Q81307290', 'Q81411033', 'Q79255582', 'Q79030903', 'Q80361518'
            )
    )
GROUP BY actor_name;

SQL

Checking query status...