RHaworth's 2019 edits with summary "unspeedy"

For [[Wikipedia:Arbitration/Requests/Case/RHaworth/Evidence]].

Lists only currently-undeleted edits timestamped in 2019 containing "unspeedy" (case-sensitive), which is what I've observed him to use in the past.

SQL

SELECT CONCAT('[[', CASE page_namespace
                      WHEN 0 THEN ''
                      WHEN 1 THEN 'Talk:'
                      WHEN 2 THEN 'User:'
                      WHEN 3 THEN 'User talk:'
                      WHEN 4 THEN 'Wikipedia:'
                      WHEN 5 THEN 'Wikipedia talk:'
                      WHEN 6 THEN ':File:'
                      WHEN 10 THEN 'Template:'
                      WHEN 14 THEN ':Category:'
                      WHEN 100 THEN 'Portal:'
                      WHEN 118 THEN 'Draft:'
                      WHEN 119 THEN 'Draft talk:'
                      ELSE CONCAT('{{ns:', page_namespace, '}}:')
                    END, page_title, ']]') AS 'page',
       CONCAT('[[Special:Diff/', rev_id, ']]') as 'diff',
       DATE_FORMAT(rev_timestamp, '%Y-%m-%d %H:%i:%s') AS 'timestamp'
FROM revision_userindex
  JOIN actor_revision ON actor_id = rev_actor
  JOIN comment_revision ON comment_id = rev_comment_id
  JOIN page ON rev_page = page_id
WHERE actor_name = 'RHaworth'
  AND rev_timestamp >= '2019'
  AND comment_text='unspeedy'
ORDER BY rev_timestamp ASC;

SQL

Checking query status...