Untitled query #43749

SQL

USE nowiki_p;

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 = 2 AND
    	old.rev_id = (SELECT rev_id FROM revision WHERE rev_page = page.page_id AND STRCMP(rev_timestamp, '20150101000000') = -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, '20200101000000') = -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 > 1024
    ORDER BY percentage DESC;
SQL

Checking query status...
