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',

       comment_text

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 rev_timestamp < '2020'

  AND comment_text LIKE '%unspeedy%'

ORDER BY rev_timestamp ASC;