Fork of
Proofread texts in plwikisorce
by Ankry
This query is marked as a draft
This query has been published
by Ankry.
SQL
x
USE commonswiki_p;
SELECT IF(SUBSTR(page_title,1,1)<='Z',SUBSTR(page_title,1,1),SUBSTR(page_title,1,2)) AS Letter, COUNT(page_title) as Count
FROM page JOIN categorylinks ON cl_from = page_id
WHERE page_namespace = 6 /*AND page_title >= 'A' AND page_title < 'Ł'*/ AND cl_to = 'Uploaded_with_UploadWizard'
GROUP BY 1;
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.