Fork of
Untitled query #27891
by Ankry
This query is marked as a draft
This query has been published
by Tpt.
SQL
AخA
USE enwikisource_p;
SELECT COUNT(page_id) AS en_count from page LEFT JOIN page_props ON pp_page = page_id AND pp_propname = "proofread_page_quality_level" WHERE pp_propname IS NULL AND page_namespace = 104;
USE frwikisource_p;
SELECT COUNT(page_id) AS fr_count from page LEFT JOIN page_props ON pp_page = page_id AND pp_propname = "proofread_page_quality_level" WHERE pp_propname IS NULL AND page_namespace = 104;
USE plwikisource_p;
SELECT COUNT(page_id) AS pl_count from page LEFT JOIN page_props ON pp_page = page_id AND pp_propname = "proofread_page_quality_level" WHERE pp_propname IS NULL AND page_namespace = 100;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.