SELECT CONCAT('[[Special:Diff/', r1.rev_id, ']]') AS diff,

       r1.rev_len-r2.rev_len AS delta,

       r1.rev_timestamp,

       CONCAT('[[{{ns:', page_namespace, '}}:', page_title, ']]') AS pagename,

       comment_text

FROM revision_userindex r1

    JOIN actor_revision ON actor_id = r1.rev_actor

    LEFT JOIN page ON page_id = r1.rev_page

    LEFT JOIN comment_revision ON comment_id = r1.rev_comment_id

    LEFT JOIN revision r2 ON r1.rev_parent_id = r2.rev_id

WHERE actor_name='GreenC bot'

    AND comment_text LIKE '%Cleanup bare URLs%'

    AND r1.rev_timestamp >= '201905'

ORDER BY r1.rev_timestamp DESC;