Untitled query #42324

SQL

USE huwiki_p;

-- new articles
SELECT page.page_title, revision.rev_len AS len
	FROM page, revision
    WHERE
    	page_namespace = 0 AND
        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;

-- expanded articles
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
	FROM page, revision AS old, revision AS new
    WHERE
    	page_namespace = 0 AND
    	old.rev_id = (SELECT rev_id FROM revision WHERE rev_page = page.page_id AND STRCMP(rev_timestamp, '20200101000000') = -1 ORDER BY rev_timestamp DESC LIMIT 1) AND
        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...
