wikidata: redirects as sitelinks in items

SQL

USE ruwiki_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

-- redirects that are connected to an item at Wikidata
SELECT
    p.page_id,
    p.page_namespace,
    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 pp.pp_propname='wikibase_item';

-- redirects with "Template:Wikidata-Weiterleitung" that are connected to an item at Wikidata
SELECT
	p.page_id,
    p.page_namespace,
    p.page_title,
    pp.pp_value
FROM
	templatelinks tl JOIN page p ON p.page_id=tl.tl_from JOIN page_props pp ON p.page_id=pp.pp_page
WHERE
    tl.tl_title='Wikidata-redirect'
    AND tl.tl_namespace=10
    AND p.page_is_redirect=1
    AND pp.pp_propname='wikibase_item';
SQL

Checking query status...
