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...
