New and expanded articles on huwiki in 2019

SQL

/*
SELECT
		p.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 p,
		(SELECT rev_page, rev_len FROM revision WHERE rev_page = p.page_id AND STRCMP(rev_timestamp, '20190101000000') = -1 ORDER BY rev_timestamp DESC LIMIT 1) AS old,
		(SELECT rev_page, rev_len FROM revision WHERE rev_page = p.page_id AND STRCMP(rev_timestamp, '20200101000000') = -1 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;
*/

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_id, '20190101000000') <> -1 AND STRCMP(revision.rev_id, '20200101000000') = -1 AND
        new.rev_len > 1024
    ORDER BY len DESC
    LIMIT 10;

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, '20190101000000') = -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
    LIMIT 10;
SQL

Checking query status...
