Number of "Proofread" and "Validated" pages in en.ws

Fork of Number of "Proofread" and "Validated" pages in fr.ws by Ankry

This query is marked as a draft This query has been published by Ankry.

SQL

USE enwikisource_p;
SELECT NOW();
SELECT 'en' AS 'lang',COUNT(page_id) AS 'count' FROM page
    JOIN page_props ON pp_page = page_id AND pp_propname = "proofread_page_quality_level"
	WHERE /*page_namespace = 104 AND*/ pp_value >= 3;
SELECT rev_id,page_title,rev_timestamp,comment_text,rev_user_text FROM revision
    JOIN page ON page_id=rev_page JOIN page_props ON pp_page = page_id AND pp_propname = "proofread_page_quality_level"
    JOIN comment ON comment_id = rev_comment_id
    WHERE page_namespace = 104 AND rev_timestamp > '20190511050000' AND pp_value >= 3 ORDER BY rev_timestamp DESC;

SQL

Checking query status...