Last month's markasduplicate.js usage (Wikidata)

SQL

USE wikidatawiki_p;
SELECT * FROM revision JOIN comment ON comment_id = rev_comment_id
WHERE rev_id IN (971693755, 971693759);
/*
SELECT rc_timestamp, actor_name, rc_title, `comment`.*
FROM recentchanges
JOIN comment ON comment_id = rc_comment_id
JOIN actor ON actor_id = rc_actor
WHERE comment_text LIKE "%Property:P642%markasduplicate.js%"
AND rc_namespace = 0
ORDER BY rc_timestamp DESC;
/*
SELECT rc_user_text, COUNT(*) AS items
FROM recentchanges
JOIN comment ON comment_id = rc_comment_id
WHERE comment_text LIKE "%Property:P642%markasduplicate.js%"
AND rc_namespace = 0
GROUP BY rc_user_text
ORDER BY items DESC;*/

SQL

Checking query status...