Untitled query #42798

SQL

USE huwiki_p;

SELECT page.page_title, revision.rev_len AS len

    WHERE
    
        revision.rev_id = (SELECT rev_id FROM revision WHERE rev_page = page.page_id ORDER BY rev_timestamp ASC LIMIT 1) AND
        STRCMP(revision.rev_timestamp, '20200101000000') <> -1 AND STRCMP(revision.rev_timestamp, '20210101000000') = -1 AND
        revision.rev_len > 30000
    ORDER BY len DESC;

SELECT page.page_title, new.rev_len AS len, (new.rev_len - old.rev_len) AS diff, ((new.rev_len - old.rev_len) / old.rev_len) AS percentage

    WHERE
    
    
        new.rev_id = (SELECT rev_id FROM revision WHERE rev_page = page.page_id AND STRCMP(rev_timestamp, '20210101000000') = -1 ORDER BY rev_timestamp DESC LIMIT 1) AND
        new.rev_len > old.rev_len AND
        ((new.rev_len - old.rev_len) / old.rev_len) > 0.3 AND new.rev_len > 30000
    ORDER BY percentage DESC;
SQL

Checking query status...
