Redirect sitelinks in Wikidata items, by project

Fork of wikidata: redirect sitelinks in items, by project by MisterSynergy

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

SQL

USE dewiki_p; 
-- enwiki_p, cebwiki_p, svwiki_p, dewiki_p, nlwiki_p
-- frwiki_p, ruwiki_p, itwiki_p, eswiki_p, warwiki_p
-- plwiki_p, viwiki_p, jawiki_p, ptwiki_p, zhwiki_p
-- ukwiki_p, fawiki_p, cawiki_p, arwiki_p

SELECT COUNT(p.page_id) AS cnt FROM page p JOIN page_props pp ON p.page_id=pp.pp_page WHERE p.page_namespace=0 AND pp.pp_propname='wikibase_item';
SELECT p.page_id, p.page_title, pp.pp_value FROM page p JOIN page_props pp ON p.page_id=pp.pp_page WHERE p.page_is_redirect=1 AND p.page_namespace=0 AND pp.pp_propname='wikibase_item';

SQL

Checking query status...