Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Ankry
.
Toggle Highlighting
SQL
SELECT 'en' AS 'ws', COUNT(*) AS texts from enwikisource_p.page WHERE enwikisource_p.page.page_namespace = 0 UNION SELECT 'fr' AS 'ws', COUNT(*) AS texts from frwikisource_p.page WHERE frwikisource_p.page.page_namespace = 0 UNION SELECT 'de' AS 'ws', COUNT(*) AS texts from dewikisource_p.page WHERE dewikisource_p.page.page_namespace = 0 UNION SELECT 'pl' AS 'ws', COUNT(*) AS texts from plwikisource_p.page WHERE plwikisource_p.page.page_namespace = 0 UNION SELECT 'ru' AS 'ws', COUNT(*) AS texts from ruwikisource_p.page WHERE ruwikisource_p.page.page_namespace = 0 UNION SELECT 'it' AS 'ws', COUNT(*) AS texts from itwikisource_p.page WHERE itwikisource_p.page.page_namespace = 0 UNION SELECT 'zh' AS 'ws', COUNT(*) AS texts from zhwikisource_p.page WHERE zhwikisource_p.page.page_namespace = 0 UNION SELECT 'ar' AS 'ws', COUNT(*) AS texts from arwikisource_p.page WHERE arwikisource_p.page.page_namespace = 0 UNION SELECT 'he' AS 'ws', COUNT(*) AS texts from hewikisource_p.page WHERE hewikisource_p.page.page_namespace = 0 UNION SELECT 'es' AS 'ws', COUNT(*) AS texts from eswikisource_p.page WHERE eswikisource_p.page.page_namespace = 0 UNION SELECT 'pt' AS 'ws', COUNT(*) AS texts from ptwikisource_p.page WHERE ptwikisource_p.page.page_namespace = 0 UNION SELECT 'bn' AS 'ws', COUNT(*) AS texts from bnwikisource_p.page WHERE bnwikisource_p.page.page_namespace = 0 UNION SELECT 'cs' AS 'ws', COUNT(*) AS texts from cswikisource_p.page WHERE cswikisource_p.page.page_namespace = 0;
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
.
Checking query status...
