🏆 ยอดนิยม: query/

Edits in January through June 2026 to pages in the main namespace (with talk pages currently transcluding {{WikiProject Mathematics}}) that are tagged "newcomer task add link", split by whether they're also tagged "mw-reverted".

For [[WP:RAQ#Newcomer reversions in math articles]], and presumably  [[WP:VPR#Can the "link suggestions" newcomer task be disabled for mathematical articles?]], circa 2 September 2026.

SQL

SELECT SUM(ctrev.ct_id IS NOT NULL) AS 'reverted',
       SUM(ctrev.ct_id IS NULL) AS 'unreverted'
FROM linktarget
JOIN templatelinks ON tl_target_id = lt_id
JOIN page AS talk ON talk.page_id = tl_from AND talk.page_namespace = 1
JOIN page AS article ON article.page_namespace = 0 AND article.page_title = talk.page_title
JOIN revision ON rev_page = article.page_id
JOIN change_tag_def AS ctdnew ON ctdnew.ctd_name = 'newcomer task add link'
JOIN change_tag AS ctnew ON ctnew.ct_tag_id = ctdnew.ctd_id AND ctnew.ct_rev_id = rev_id
JOIN change_tag_def AS ctdrev ON ctdrev.ctd_name = 'mw-reverted'
LEFT JOIN change_tag AS ctrev ON ctrev.ct_tag_id = ctdrev.ctd_id AND ctrev.ct_rev_id = rev_id
WHERE lt_namespace = 10
  AND lt_title = 'WikiProject_Mathematics'
  AND rev_timestamp BETWEEN '2026' AND '202607';

SQL

Checking query status...