Count fixes by editor in Wikipedia:Correct typos in one click

SQL

SELECT actor_name AS contributor, COUNT(*) AS fixes
FROM revision
LEFT JOIN comment ON rev_comment_id=comment_id
LEFT JOIN actor ON rev_actor=actor_id 
WHERE rev_page IN (60533818,62053073,61925999,61926002,61926007,61926012,61926014,62002342,62002343,62002345,62002348,62002349,61925967,62057349,61925968,61925974,61925980,61925985,61925989,61925991,61925997)
AND comment_text LIKE "% fixed!"
GROUP BY rev_actor
ORDER BY fixes DESC;

AخA
 
SELECT actor_name AS contributor, COUNT(*) AS fixesFROM revisionLEFT JOIN comment ON rev_comment_id=comment_idLEFT JOIN actor ON rev_actor=actor_id WHERE rev_page IN (60533818,62053073,61925999,61926002,61926007,61926012,61926014,62002342,62002343,62002345,62002348,62002349,61925967,62057349,61925968,61925974,61925980,61925985,61925989,61925991,61925997)AND comment_text LIKE "% fixed!"GROUP BY rev_actorORDER BY fixes DESC;

SQL

Checking query status...