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
JOIN actor_revision ON rev_actor = actor_id  -- Grabs the actor information to get the username
GROUP BY actor_name                          -- Squash the table based on the username
WHERE rev_timestamp > 20210126000000
ORDER BY user_registration ASC               -- Order by registration date (latest to oldest)

SQL

Checking query status...