Wikidata - Redirects in sitelinks (for a specific wiki)

Fork of Wikidata - Redirects in sitelinks (for a specific wiki) by Jura1

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

SQL

# Redirects in sitelinks to a specific wiki (here "enwiki")
# see also https://upload.wikimedia.org/wikipedia/commons/f/f7/MediaWiki_1.24.1_database_schema.svg

# NB some of the data is stale

use enwiki_p;  #change from "enwiki" to another if needed, change the edit summary text for page moves as well
SELECT page_title, rev_comment As editsummary_lastedit, rev_timestamp As edit_timestamp, pp_value AS QID
FROM  page, revision, page_props
WHERE page_is_redirect = 1 
AND rev_page = pp_page
AND pp_propname="wikibase_item"
AND page_latest = rev_id
AND pp_page=page_id 
AND page_namespace=0 #focus on articles
AND rev_comment LIKE '% moved page [%'  #change to the edit summary text in use at the wiki

SQL

Checking query status...