trwiki:Likely Article of the Year 2020 size criteria satisfaction for Vikiproje Bilim tarihi

SQL

USE trwiki_p;
SELECT page_latest, MAX(prev.rev_id), page_title, prev.rev_len, page_len, IFNULL(((CAST(page_len AS SIGNED)-CAST(prev.rev_len AS SIGNED))/CAST(prev.rev_len AS SIGNED)),1) as delta
FROM page
INNER JOIN trwiki_p.page_assessments ON pa_page_id=page_id AND pa_project_id=78
JOIN revision AS cur ON cur.rev_page = page_id
LEFT JOIN revision AS prev ON prev.rev_page = cur.rev_page
    AND prev.rev_deleted = 0
    AND prev.rev_timestamp < (SELECT TIMESTAMP("2020-01-01 00:00:00"))
    #AND prev.rev_timestamp >= (SELECT TIMESTAMP("2008-03-09 10:38:47"))
    #AND prev.rev_len>399
    AND prev.rev_len<page_len
    AND prev.rev_id != cur.rev_id
WHERE
	cur.rev_parent_id = 0
    AND page_namespace = 0
    AND page_is_redirect=0
    AND cur.rev_deleted=0
    AND cur.rev_timestamp <= (SELECT TIMESTAMP("2020-12-31 23:59:59"))
    AND cur.rev_timestamp >= (SELECT TIMESTAMP("2020-01-01 00:00:00"))
    AND page_len>=15000
GROUP BY page_title, prev.rev_page HAVING delta>=0.3
ORDER BY page_len DESC, delta DESC, page_title ASC;

SQL

Checking query status...