cross-wikisource stats

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

SELECT A.ws, all_texts, texts_without_subpages FROM
(SELECT 'ar' AS 'ws', COUNT(*) AS 'all_texts' from arwikisource_p.page WHERE arwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
#SELECT 'as', COUNT(*) from aswikisource_p.page WHERE aswikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
#SELECT 'az', COUNT(*) from azwikisource_p.page WHERE azwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
#SELECT 'be', COUNT(*) from bewikisource_p.page WHERE bewikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
#SELECT 'bg', COUNT(*) from bgwikisource_p.page WHERE bgwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
#SELECT 'bn', COUNT(*) from bnwikisource_p.page WHERE bnwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
#SELECT 'br', COUNT(*) from brwikisource_p.page WHERE brwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
#SELECT 'bs', COUNT(*) from bswikisource_p.page WHERE bswikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
#SELECT 'ca', COUNT(*) from cawikisource_p.page WHERE cawikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
#SELECT 'cs', COUNT(*) from cswikisource_p.page WHERE cswikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
#SELECT 'cy', COUNT(*) from cywikisource_p.page WHERE cywikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
#SELECT 'da', COUNT(*) from dawikisource_p.page WHERE dawikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
#SELECT 'de', COUNT(*) from dewikisource_p.page WHERE dewikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
#SELECT 'el', COUNT(*) from elwikisource_p.page WHERE elwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
#SELECT 'en', COUNT(*) from enwikisource_p.page WHERE enwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
#SELECT 'eo', COUNT(*) from eowikisource_p.page WHERE eowikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
#SELECT 'es', COUNT(*) from eswikisource_p.page WHERE eswikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
#SELECT 'et', COUNT(*) from etwikisource_p.page WHERE etwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
#SELECT 'fa', COUNT(*) from fawikisource_p.page WHERE fawikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
#SELECT 'fi', COUNT(*) from fiwikisource_p.page WHERE fiwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
#SELECT 'fo', COUNT(*) from fowikisource_p.page WHERE fowikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
#SELECT 'fr', COUNT(*) from frwikisource_p.page WHERE frwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
#SELECT 'gl', COUNT(*) from glwikisource_p.page WHERE glwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
#SELECT 'gu', COUNT(*) from guwikisource_p.page WHERE guwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'he', COUNT(*) from hewikisource_p.page WHERE hewikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'hr', COUNT(*) from hrwikisource_p.page WHERE hrwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'hu', COUNT(*) from huwikisource_p.page WHERE huwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'hy', COUNT(*) from hywikisource_p.page WHERE hywikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'id', COUNT(*) from idwikisource_p.page WHERE idwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'is', COUNT(*) from iswikisource_p.page WHERE iswikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'it', COUNT(*) from itwikisource_p.page WHERE itwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'ja', COUNT(*) from jawikisource_p.page WHERE jawikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'kn', COUNT(*) from knwikisource_p.page WHERE knwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'ko', COUNT(*) from kowikisource_p.page WHERE kowikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'la', COUNT(*) from lawikisource_p.page WHERE lawikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'li', COUNT(*) from liwikisource_p.page WHERE liwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'lt', COUNT(*) from ltwikisource_p.page WHERE ltwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'mk', COUNT(*) from mkwikisource_p.page WHERE mkwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'ml', COUNT(*) from mlwikisource_p.page WHERE mlwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'mr', COUNT(*) from mrwikisource_p.page WHERE mrwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'nl', COUNT(*) from nlwikisource_p.page WHERE nlwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'no', COUNT(*) from nowikisource_p.page WHERE nowikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'or', COUNT(*) from orwikisource_p.page WHERE orwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
#SELECT 'pa', COUNT(*) from pawikisource_p.page WHERE pawikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'pl', COUNT(*) from plwikisource_p.page WHERE plwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'pt', COUNT(*) from ptwikisource_p.page WHERE ptwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'ro', COUNT(*) from rowikisource_p.page WHERE rowikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'ru', COUNT(*) from ruwikisource_p.page WHERE ruwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'sa', COUNT(*) from sawikisource_p.page WHERE sawikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'sah', COUNT(*) from sahwikisource_p.page WHERE sahwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'sk', COUNT(*) from fowikisource_p.page WHERE fowikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'sl', COUNT(*) from slwikisource_p.page WHERE slwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'sr', COUNT(*) from srwikisource_p.page WHERE srwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'sv', COUNT(*) from svwikisource_p.page WHERE svwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'ta', COUNT(*) from tawikisource_p.page WHERE tawikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'te', COUNT(*) from tewikisource_p.page WHERE tewikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'th', COUNT(*) from thwikisource_p.page WHERE thwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'tr', COUNT(*) from trwikisource_p.page WHERE trwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'uk', COUNT(*) from ukwikisource_p.page WHERE ukwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'vec', COUNT(*) from vecwikisource_p.page WHERE vecwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'vi', COUNT(*) from viwikisource_p.page WHERE viwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'yi', COUNT(*) from yiwikisource_p.page WHERE yiwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'zh', COUNT(*) from zhwikisource_p.page WHERE zhwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect UNION
SELECT 'zh-min-nan', COUNT(*) from zh_min_nanwikisource_p.page WHERE zh_min_nanwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect)
	AS A
JOIN
(SELECT 'ar' AS 'ws', COUNT(*) AS 'texts_without_subpages' from arwikisource_p.page WHERE arwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
#SELECT 'as', COUNT(*) from aswikisource_p.page WHERE aswikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
#SELECT 'az', COUNT(*) from azwikisource_p.page WHERE azwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
#SELECT 'be', COUNT(*) from bewikisource_p.page WHERE bewikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
#SELECT 'bg', COUNT(*) from bgwikisource_p.page WHERE bgwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
#SELECT 'bn', COUNT(*) from bnwikisource_p.page WHERE bnwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
#SELECT 'br', COUNT(*) from brwikisource_p.page WHERE brwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
#SELECT 'bs', COUNT(*) from bswikisource_p.page WHERE bswikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
#SELECT 'ca', COUNT(*) from cawikisource_p.page WHERE cawikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
#SELECT 'cs', COUNT(*) from cswikisource_p.page WHERE cswikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
#SELECT 'cy', COUNT(*) from cywikisource_p.page WHERE cywikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
#SELECT 'da', COUNT(*) from dawikisource_p.page WHERE dawikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
#SELECT 'de', COUNT(*) from dewikisource_p.page WHERE dewikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
#SELECT 'el', COUNT(*) from elwikisource_p.page WHERE elwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
#SELECT 'en', COUNT(*) from enwikisource_p.page WHERE enwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
#SELECT 'eo', COUNT(*) from eowikisource_p.page WHERE eowikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
#SELECT 'es', COUNT(*) from eswikisource_p.page WHERE eswikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
#SELECT 'et', COUNT(*) from etwikisource_p.page WHERE etwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
#SELECT 'fa', COUNT(*) from fawikisource_p.page WHERE fawikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
#SELECT 'fi', COUNT(*) from fiwikisource_p.page WHERE fiwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
#SELECT 'fo', COUNT(*) from fowikisource_p.page WHERE fowikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
#SELECT 'fr', COUNT(*) from frwikisource_p.page WHERE frwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
#SELECT 'gl', COUNT(*) from glwikisource_p.page WHERE glwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
#SELECT 'gu', COUNT(*) from guwikisource_p.page WHERE guwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'he', COUNT(*) from hewikisource_p.page WHERE hewikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'hr', COUNT(*) from hrwikisource_p.page WHERE hrwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'hu', COUNT(*) from huwikisource_p.page WHERE huwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'hy', COUNT(*) from hywikisource_p.page WHERE hywikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'id', COUNT(*) from idwikisource_p.page WHERE idwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'is', COUNT(*) from iswikisource_p.page WHERE iswikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'it', COUNT(*) from itwikisource_p.page WHERE itwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'ja', COUNT(*) from jawikisource_p.page WHERE jawikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'kn', COUNT(*) from knwikisource_p.page WHERE knwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'ko', COUNT(*) from kowikisource_p.page WHERE kowikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'la', COUNT(*) from lawikisource_p.page WHERE lawikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'li', COUNT(*) from liwikisource_p.page WHERE liwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'lt', COUNT(*) from ltwikisource_p.page WHERE ltwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'mk', COUNT(*) from mkwikisource_p.page WHERE mkwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'ml', COUNT(*) from mlwikisource_p.page WHERE mlwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'mr', COUNT(*) from mrwikisource_p.page WHERE mrwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'nl', COUNT(*) from nlwikisource_p.page WHERE nlwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'no', COUNT(*) from nowikisource_p.page WHERE nowikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'or', COUNT(*) from orwikisource_p.page WHERE orwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
#SELECT 'pa', COUNT(*) from pawikisource_p.page WHERE pawikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'pl', COUNT(*) from plwikisource_p.page WHERE plwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'pt', COUNT(*) from ptwikisource_p.page WHERE ptwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'ro', COUNT(*) from rowikisource_p.page WHERE rowikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'ru', COUNT(*) from ruwikisource_p.page WHERE ruwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'sa', COUNT(*) from sawikisource_p.page WHERE sawikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'sah', COUNT(*) from sahwikisource_p.page WHERE sahwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'sk', COUNT(*) from fowikisource_p.page WHERE fowikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'sl', COUNT(*) from slwikisource_p.page WHERE slwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'sr', COUNT(*) from srwikisource_p.page WHERE srwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'sv', COUNT(*) from svwikisource_p.page WHERE svwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'ta', COUNT(*) from tawikisource_p.page WHERE tawikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'te', COUNT(*) from tewikisource_p.page WHERE tewikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'th', COUNT(*) from thwikisource_p.page WHERE thwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'tr', COUNT(*) from trwikisource_p.page WHERE trwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'uk', COUNT(*) from ukwikisource_p.page WHERE ukwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'vec', COUNT(*) from vecwikisource_p.page WHERE vecwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'vi', COUNT(*) from viwikisource_p.page WHERE viwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'yi', COUNT(*) from yiwikisource_p.page WHERE yiwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'zh', COUNT(*) from zhwikisource_p.page WHERE zhwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%' UNION
SELECT 'zh-min-nan', COUNT(*) from zh_min_nanwikisource_p.page WHERE zh_min_nanwikisource_p.page.page_namespace = 0 AND NOT page_is_redirect AND NOT page_title LIKE '%/%')
	AS B
ON A.ws = B.ws
ORDER BY 2 DESC;
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...
