Contributions search by user, edit summary, date

Fork of Contributions search by user, edit summary, date by Cryptic

This query is marked as a draft This query has been published by YFdyh000.

SQL

SELECT CONCAT('[[Special:Diff/', r2.rev_id, ']]') AS diff,
       r1.rev_len,r2.rev_len,
       r1.rev_timestamp,
       page_title
       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 IN ('Jimmy-bot')
    AND r1.rev_timestamp >= '202001'
    #AND r1.rev_timestamp > '20220100000000'
    AND comment_text LIKE '%小作品%'
ORDER BY r2.rev_len DESC;

SQL

Checking query status...