cross-wikisource stats

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

SELECT * FROM page LIMIT 1;
SELECT 'ar' AS 'ws', COUNT(*) AS texts from arwikisource_p.page WHERE arwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect 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 'bn' AS 'ws', COUNT(*) AS texts from bnwikisource_p.page WHERE bnwikisource_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 'bs' AS 'ws', COUNT(*) AS texts from bswikisource_p.page WHERE bswikisource_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 'cs' AS 'ws', COUNT(*) AS texts from cswikisource_p.page WHERE cswikisource_p.page.page_namespace = 0 UNION
SELECT 'cy' AS 'ws', COUNT(*) AS texts from cywikisource_p.page WHERE cywikisource_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 'de' AS 'ws', COUNT(*) AS texts from dewikisource_p.page WHERE dewikisource_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 'en' AS 'ws', COUNT(*) AS texts from enwikisource_p.page WHERE enwikisource_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 'es' AS 'ws', COUNT(*) AS texts from eswikisource_p.page WHERE eswikisource_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 'fa' AS 'ws', COUNT(*) AS texts from fawikisource_p.page WHERE fawikisource_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 'fo' AS 'ws', COUNT(*) AS texts from fowikisource_p.page WHERE fowikisource_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 'gl' AS 'ws', COUNT(*) AS texts from glwikisource_p.page WHERE glwikisource_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 'he' AS 'ws', COUNT(*) AS texts from hewikisource_p.page WHERE hewikisource_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 'hu' AS 'ws', COUNT(*) AS texts from huwikisource_p.page WHERE huwikisource_p.page.page_namespace = 0 UNION
SELECT 'hy' AS 'ws', COUNT(*) AS texts from hywikisource_p.page WHERE hywikisource_p.page.page_namespace = 0 UNION
SELECT 'id' AS 'ws', COUNT(*) AS texts from idwikisource_p.page WHERE idwikisource_p.page.page_namespace = 0 UNION
SELECT 'is' AS 'ws', COUNT(*) AS texts from iswikisource_p.page WHERE iswikisource_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 'ja' AS 'ws', COUNT(*) AS texts from jawikisource_p.page WHERE jawikisource_p.page.page_namespace = 0 UNION
SELECT 'kn' AS 'ws', COUNT(*) AS texts from knwikisource_p.page WHERE knwikisource_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 'la' AS 'ws', COUNT(*) AS texts from lawikisource_p.page WHERE lawikisource_p.page.page_namespace = 0 UNION
SELECT 'li' AS 'ws', COUNT(*) AS texts from liwikisource_p.page WHERE liwikisource_p.page.page_namespace = 0 UNION
SELECT 'lt' AS 'ws', COUNT(*) AS texts from ltwikisource_p.page WHERE ltwikisource_p.page.page_namespace = 0 UNION
SELECT 'mk' AS 'ws', COUNT(*) AS texts from mkwikisource_p.page WHERE mkwikisource_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 'mr' AS 'ws', COUNT(*) AS texts from mrwikisource_p.page WHERE mrwikisource_p.page.page_namespace = 0 UNION
SELECT 'nl' AS 'ws', COUNT(*) AS texts from nlwikisource_p.page WHERE nlwikisource_p.page.page_namespace = 0 UNION
SELECT 'no' AS 'ws', COUNT(*) AS texts from nowikisource_p.page WHERE nowikisource_p.page.page_namespace = 0 UNION
SELECT 'or' AS 'ws', COUNT(*) AS texts from orwikisource_p.page WHERE orwikisource_p.page.page_namespace = 0 UNION
SELECT 'pa' AS 'ws', COUNT(*) AS texts from pawikisource_p.page WHERE pawikisource_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 'pt' AS 'ws', COUNT(*) AS texts from ptwikisource_p.page WHERE ptwikisource_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 'ru' AS 'ws', COUNT(*) AS texts from ruwikisource_p.page WHERE ruwikisource_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 'sah' AS 'ws', COUNT(*) AS texts from sahwikisource_p.page WHERE sahwikisource_p.page.page_namespace = 0 UNION
SELECT 'sk' AS 'ws', COUNT(*) AS texts from fowikisource_p.page WHERE fowikisource_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 'sr' AS 'ws', COUNT(*) AS texts from srwikisource_p.page WHERE srwikisource_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 'ta' AS 'ws', COUNT(*) AS texts from tawikisource_p.page WHERE tawikisource_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 'th' AS 'ws', COUNT(*) AS texts from thwikisource_p.page WHERE thwikisource_p.page.page_namespace = 0 UNION
SELECT 'tr' AS 'ws', COUNT(*) AS texts from trwikisource_p.page WHERE trwikisource_p.page.page_namespace = 0 UNION
SELECT 'uk' AS 'ws', COUNT(*) AS texts from ukwikisource_p.page WHERE ukwikisource_p.page.page_namespace = 0 UNION
SELECT 'vec' AS 'ws', COUNT(*) AS texts from vecwikisource_p.page WHERE vecwikisource_p.page.page_namespace = 0 UNION
SELECT 'vi' AS 'ws', COUNT(*) AS texts from viwikisource_p.page WHERE viwikisource_p.page.page_namespace = 0 UNION
SELECT 'yi' AS 'ws', COUNT(*) AS texts from yiwikisource_p.page WHERE yiwikisource_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 'zh-min-nan' AS 'ws', COUNT(*) AS texts from zh_min_nanwikisource_p.page WHERE zh_min_nanwikisource_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...
