New and expanded articles on huwiki in 2019

This query gets the longest new articles in huwiki in 2019, as well as the most significantly expanded articles. In order to avoid cases like article expanded by 100% (two bytes instead of one), there is a 1 kiB lower bound in both categories (referring to the new size in case of expanded articles).

SQL

SELECT
		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,
		(SELECT rev_page, rev_len FROM revision WHERE rev_timestamp < '2019-01-01T00:00:00Z' ORDER BY rev_timestamp DESC LIMIT 1) AS old,
		(SELECT rev_page, rev_len FROM revision WHERE rev_timestamp < '2019-01-01T00:00:00Z' ORDER BY rev_timestamp DESC LIMIT 1) AS new
	WHERE
    	page_id = old.rev_page AND page_id = new.rev_page AND
        ((new.rev_len - old.rev_len) / old.rev_len) > 0.3 AND new.rev_len > 1024
	ORDER BY percentage DESC
    LIMIT 10;

SQL

Checking query status...