Twinkle users (simplified)

SQL

USE enwiki_p; -- Use the English Wikipedia database.

SELECT -- Add the following columns...
	actor_name as `Username`,                  -- Editor username
    user_editcount as `Edit Count`,            -- Editor total edit count
    user_registration as `Registration Date`,  -- Editor registration date
    COUNT(*) as `Twinkle Edits`,                  -- Total Twinkle edits
    COUNT(*)/user_editcount * 100 as `Twinkle %`, -- Percentage of Twinkle edits vs. total edits
    ipb_sitewide as `Currently Blocked`        -- If the user is currently blocked (always 1 if true)
FROM revision_userindex -- ... from all Wikipedia revisions

JOIN change_tag ON ct_rev_id = rev_id        -- Combines revision tags with the query
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
JOIN revision_comment_temp ON revcomment_rev = rev_id    -- Grabs the edit summaries as well
JOIN `comment` ON comment_id = revcomment_comment_id    -- Joins the edit summaries with the rows
LEFT JOIN ipblocks ON user_id = ipb_user     -- Adds block information to the list
WHERE ct_tag_id = 583 OR comment_text LIKE '%[[Wikipedia:TW|TW]]%'    -- Only get Twinkle edits
GROUP BY actor_name                          -- Squash the table based on the username
ORDER BY user_registration DESC              -- Order by registration date (latest to oldest)
SQL

Checking query status...
