Find all revisions of a page that match given revision

SQL

SELECT CONCAT("Special:Diff/", rev_id) AS diff, actor_name AS editor, DATE_FORMAT(rev_timestamp, '%Y-%m-%d %H:%i:%s') AS timestamp
FROM revision
JOIN page ON rev_page = page_id
JOIN actor_revision ON actor_id = rev_actor
WHERE page_title = 'MusikAnimal/sandbox' /* Title of page, without namespace, underscores instead of spaces */
AND page_namespace = 2 /* Namespace ID */
AND rev_sha1 = (
	SELECT rev_sha1
    FROM revision
    WHERE rev_id = 944834000 /* Revision ID of the version of the page that you're searching for */
)

SQL

Checking query status...