Last month's markasduplicate.js usage (Wikidata)

SQL

USE wikidatawiki_p;
#/*
SELECT rc_timestamp, actor_name, rc_title, page_is_redirect#, comment_text
FROM recentchanges
JOIN comment ON comment_id = rc_comment_id
JOIN actor_recentchanges ON actor_id = rc_actor
JOIN page ON page_id = rc_cur_id
WHERE comment_text LIKE "%duplicate%"
AND rc_namespace = 0
ORDER BY rc_timestamp DESC;
/*/
SELECT actor_name, COUNT(*) AS total, SUM(page_is_redirect) AS done
FROM revision_userindex
JOIN actor_revision ON actor_id = rev_actor
JOIN page ON page_id = rev_page
WHERE rev_comment_id = 512412
AND actor_user > 0
AND page_namespace = 0
GROUP BY rev_actor
#ORDER BY total DESC, done DESC, actor_name;
#*/

SQL

Checking query status...