Untitled query #5397

SQL

use itwiki_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 '% ha spostato la pagina [%'  #change to the edit summary text in use at the wiki
SQL

Checking query status...
