Last month's markasduplicate.js usage (Wikidata)

SQL

USE wikidatawiki_p;
SELECT rc_timestamp, actor_name, rc_title#, comment_text
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%"
WHERE rc_comment_id = 512412
AND rc_namespace = 0
ORDER BY rc_timestamp DESC;
/*
SELECT actor_name, COUNT(page_title) AS amount, SUM(page_is_redirect)
FROM revision
JOIN actor ON actor_id = rev_actor
JOIN page ON page_id = rev_page
WHERE rev_comment_id = 512412
AND page_namespace = 0
GROUP BY actor_name
ORDER BY amount DESC, actor_name;
*/

SQL

Checking query status...