🏆 ยอดนิยม: query/

Users who have exactly one live non-reverted edit, which was to a page currently in the main namespace and [[Category:All articles lacking sources]], and is the earliest in its history.

There are many, many false positives *and* negatives here:
* Most of 2001's and early 2002's page history has been lost.  The earliest known edit to very many early pages wasn't actually the creating one, and a given user may have other edits that don't show up in their contributions.
* Edits only started getting tagged as reverted in MediaWiki 1.36.0 from 27 May 2021, so reverts earlier than that won't have been tagged.  (Edits made before then but reverted after do get tagged.)

SQL

SET @mw_reverted = (SELECT ctd_id FROM change_tag_def WHERE ctd_name = 'mw-reverted');

SELECT actor_name, user_editcount, page_title, TO_CHAR(rev_timestamp) AS `creation timestamp`
FROM actor_revision
JOIN revision AS rev1 ON rev_id =
  -- any one non-reverted edit by user
  (SELECT rev_id
   FROM revision_userindex
   LEFT JOIN change_tag
      ON ct_rev_id = rev_id
     AND ct_tag_id = @mw_reverted
   WHERE rev_actor = actor_id
     AND ct_id IS NULL
   LIMIT 1)
JOIN categorylinks ON cl_from = rev_page
JOIN linktarget ON lt_id = cl_target_id AND lt_namespace = 14 AND lt_title = 'All_articles_lacking_sources'
JOIN page ON page_id = rev_page AND page_namespace = 0
JOIN user ON user_id = actor_user AND user_is_temp = 0
WHERE
  -- no other non-reverted edits
  NOT EXISTS
    (SELECT 1
     FROM revision_userindex AS rev2
     LEFT JOIN change_tag
        ON ct_rev_id = rev2.rev_id
       AND ct_tag_id = @mw_reverted
     WHERE rev2.rev_actor = actor_id
       AND rev2.rev_id != rev1.rev_id
       AND ct_id IS NULL
     LIMIT 1)
  -- the non-reverted edit is the earliest in that page's history
  AND NOT EXISTS
    (SELECT 1
     FROM revision AS rev3
     WHERE rev3.rev_page = rev1.rev_page
       AND (rev3.rev_timestamp < rev1.rev_timestamp
            OR (rev3.rev_timestamp = rev1.rev_timestamp
                AND rev3.rev_id < rev1.rev_id))
     LIMIT 1)
ORDER BY rev_timestamp ASC;

SQL

Checking query status...