2021 Pacific typhoon season analysis: Common edit summaries

SQL

USE enwiki_p; -- Use the English Wikipedia database.

SELECT -- Add the following columns...
	actor_name as `Username`,                  -- Editor username
    user_registration as `Registration Date`,  -- Editor registration date
    MAX(`rev_timestamp`) as `Last edit`
FROM revision_userindex  -- ... from all Wikipedia revisions
WHERE `rev_timestamp` > 20210126000000
JOIN actor_revision ON rev_actor = actor_id  -- Grabs the actor information to get the username
JOIN `user` ON actor_user = user_id          -- Grabs the user information
GROUP BY actor_name                          -- Squash the table based on the username
ORDER BY user_registration ASC               -- Order by registration date (latest to oldest)

SQL

Checking query status...