Replicas browser and optimizer
This query is marked as a draft
This query has been published
use enwiki_p; #change from "enwiki" to another if needed, change the edit summary text for page moves as well SELECT page_namespace, 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
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in