Find same edits of same user

SQL

USE wikidatawiki_p;

-- Step 1, make the same edit again, on the sandbox item. Go to the history and get the revision ID of the new edit.

-- Step 2, get the comment ID of that edit (and also your actor ID). Replace the rev_id with the revision ID from step 1.
SELECT rev_comment_id, rev_actor
INTO @comment_id, @actor_id
FROM revision
WHERE rev_id = 1318497099;

-- Step 3, find other edits with the same comment and actor.
SELECT rev_id, rev_timestamp, CONCAT('https://www.wikidata.org/w/index.php?oldid=', rev_id) AS url
FROM revision_userindex
WHERE rev_comment_id = @comment_id
AND rev_actor = @actor_id
LIMIT 10;
SQL

Checking query status...
