SQL
AخA
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 */
)
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.