🏆 ยอดนิยม: query/

Compares edit counts with each of five given tags, for a single day (14 May 2025), for users who registered in 2025, split by whether their username begins with 'Mik' (as a temporary proxy for an explicit list of usernames, to be provided later).

Users on the list are also only counted if they registered in 2025.

For [[WP:RAQ#Net unreverted article contributions]] circa 11 August 2026.

SQL

SET @tag1 = 'mw-reverted';
SET @tag2 = 'visualeditor';
SET @tag3 = 'editcheck-newcontent';
SET @tag4 = 'editcheck-newreference';
SET @tag5 = 'possible unreferenced addition to BLP';

SELECT ctd1.ctd_name AS tag1,
       ctd2.ctd_name AS tag2,
       ctd3.ctd_name AS tag3,
       ctd4.ctd_name AS tag4,
       ctd5.ctd_name AS tag5,
       COUNT(*) AS 'all users (registered in 2025)',
       COUNT(CASE WHEN user_name LIKE 'Mik%' THEN 1 END) AS 'Mik%',
       COUNT(CASE WHEN user_name NOT LIKE 'Mik%' THEN 1 END) AS 'Not Mik%'
FROM revision
JOIN actor_revision ON actor_id = rev_actor
JOIN user ON user_id = actor_user
LEFT JOIN (change_tag AS ct1 JOIN change_tag_def AS ctd1 ON ctd1.ctd_id = ct1.ct_tag_id AND ctd1.ctd_name = @tag1) ON ct1.ct_rev_id = rev_id
LEFT JOIN (change_tag AS ct2 JOIN change_tag_def AS ctd2 ON ctd2.ctd_id = ct2.ct_tag_id AND ctd2.ctd_name = @tag2) ON ct2.ct_rev_id = rev_id
LEFT JOIN (change_tag AS ct3 JOIN change_tag_def AS ctd3 ON ctd3.ctd_id = ct3.ct_tag_id AND ctd3.ctd_name = @tag3) ON ct3.ct_rev_id = rev_id
LEFT JOIN (change_tag AS ct4 JOIN change_tag_def AS ctd4 ON ctd4.ctd_id = ct4.ct_tag_id AND ctd4.ctd_name = @tag4) ON ct4.ct_rev_id = rev_id
LEFT JOIN (change_tag AS ct5 JOIN change_tag_def AS ctd5 ON ctd5.ctd_id = ct5.ct_tag_id AND ctd5.ctd_name = @tag5) ON ct5.ct_rev_id = rev_id
WHERE user_is_temp = 0
  AND user_registration LIKE '2025%'
  AND rev_timestamp LIKE '20250514%'
GROUP BY 1, 2, 3, 4, 5;

SQL

Checking query status...