Number of proofread pages by quality level in the French Wikisource

Fork of Number of proofread pages by quality level in the French Wikisource by Tpt

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

SQL

/* USE trwikisource_p;
SELECT pp_value AS level, COUNT(*) FROM page_props WHERE pp_propname = "proofread_page_quality_level" GROUP BY pp_value;
*/

USE trwikisource_p;
SELECT CONCAT('* [[',page_title,']]') AS  "Maddeler"
FROM page 
JOIN page_props ON page_id = pp_page
WHERE pp_value = 3
limit 5000;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...