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 '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 FROM revision JOIN page ON page_id=rev_page JOIN page_props ON pp_page = page_id AND pp_propname = "proofread_page_quality_level"
    WHERE page_namespace = 104 AND rev_timestamp > '20190510150000' AND pp_value >= 3 ORDER BY rev_timestamp DESC;
SELECT * FROM revision JOIN page ON page_id=rev_page JOIN page_props ON pp_page = page_id AND pp_propname = "proofread_page_quality_level" LIMIT 1;
SHOW tables;
select * from comment limit 2;

SQL

Checking query status...