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 ON actor_id = rc_actor
JOIN page ON page_id = rc_cur_id
#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(*) AS total, SUM(page_is_redirect) AS done
FROM revision_userindex
JOIN actor ON actor_id = rev_actor
JOIN page ON page_id = rev_page
WHERE rev_comment_id = 512412
GROUP BY rev_actor
ORDER BY total DESC, done DESC, actor_name;
#*/

SQL

Checking query status...