cross-wikisource stats

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

CREATE TEMPORARY FUNCTION f() RETURNS INT LANGUAGE SQL AS SELECT 1;
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 UNION
SELECT 'fa' AS 'ws', COUNT(*) AS texts from fawikisource_p.page WHERE fawikisource_p.page.page_namespace = 0 UNION
SELECT 'gu' AS 'ws', COUNT(*) AS texts from guwikisource_p.page WHERE guwikisource_p.page.page_namespace = 0 UNION
SELECT 'ko' AS 'ws', COUNT(*) AS texts from kowikisource_p.page WHERE kowikisource_p.page.page_namespace = 0 UNION
SELECT 'hu' AS 'ws', COUNT(*) AS texts from huwikisource_p.page WHERE huwikisource_p.page.page_namespace = 0 UNION
SELECT 'ml' AS 'ws', COUNT(*) AS texts from mlwikisource_p.page WHERE mlwikisource_p.page.page_namespace = 0 UNION
SELECT 'ro' AS 'ws', COUNT(*) AS texts from rowikisource_p.page WHERE rowikisource_p.page.page_namespace = 0 UNION
SELECT 'sa' AS 'ws', COUNT(*) AS texts from sawikisource_p.page WHERE sawikisource_p.page.page_namespace = 0 UNION
SELECT 'sl' AS 'ws', COUNT(*) AS texts from slwikisource_p.page WHERE slwikisource_p.page.page_namespace = 0 UNION
SELECT 'sv' AS 'ws', COUNT(*) AS texts from svwikisource_p.page WHERE svwikisource_p.page.page_namespace = 0 UNION
SELECT 'te' AS 'ws', COUNT(*) AS texts from tewikisource_p.page WHERE tewikisource_p.page.page_namespace = 0 UNION
SELECT 'as' AS 'ws', COUNT(*) AS texts from aswikisource_p.page WHERE aswikisource_p.page.page_namespace = 0 UNION
SELECT 'az' AS 'ws', COUNT(*) AS texts from azwikisource_p.page WHERE azwikisource_p.page.page_namespace = 0 UNION
SELECT 'be' AS 'ws', COUNT(*) AS texts from bewikisource_p.page WHERE bewikisource_p.page.page_namespace = 0 UNION
SELECT 'bg' AS 'ws', COUNT(*) AS texts from bgwikisource_p.page WHERE bgwikisource_p.page.page_namespace = 0 UNION
SELECT 'br' AS 'ws', COUNT(*) AS texts from brwikisource_p.page WHERE brwikisource_p.page.page_namespace = 0 UNION
SELECT 'ca' AS 'ws', COUNT(*) AS texts from cawikisource_p.page WHERE cawikisource_p.page.page_namespace = 0 UNION
SELECT 'da' AS 'ws', COUNT(*) AS texts from dawikisource_p.page WHERE dawikisource_p.page.page_namespace = 0 UNION
SELECT 'el' AS 'ws', COUNT(*) AS texts from elwikisource_p.page WHERE elwikisource_p.page.page_namespace = 0 UNION
SELECT 'eo' AS 'ws', COUNT(*) AS texts from eowikisource_p.page WHERE eowikisource_p.page.page_namespace = 0 UNION
SELECT 'et' AS 'ws', COUNT(*) AS texts from etwikisource_p.page WHERE etwikisource_p.page.page_namespace = 0 UNION
SELECT 'fi' AS 'ws', COUNT(*) AS texts from fiwikisource_p.page WHERE fiwikisource_p.page.page_namespace = 0 UNION
SELECT 'hr' AS 'ws', COUNT(*) AS texts from hrwikisource_p.page WHERE hrwikisource_p.page.page_namespace = 0 UNION
SELECT 'hy' AS 'ws', COUNT(*) AS texts from hywikisource_p.page WHERE hywikisource_p.page.page_namespace = 0
	ORDER BY 2;
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...
