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
Akeron
.
Toggle Highlighting
SQL
SELECT "fr", count(*) articles, sum(`page_len`) taille, avg(`page_len`) moyenne FROM frwiki_p.`page` where `page_namespace`=0 and `page_is_redirect`=0 union SELECT "de", count(*) articles, sum(`page_len`) taille, avg(`page_len`) moyenne FROM dewiki_p.`page` where `page_namespace`=0 and `page_is_redirect`=0 union SELECT "en", count(*) articles, sum(`page_len`) taille, avg(`page_len`) moyenne FROM enwiki_p.`page` where `page_namespace`=0 and `page_is_redirect`=0 union SELECT "it", count(*) articles, sum(`page_len`) taille, avg(`page_len`) moyenne FROM itwiki_p.`page` where `page_namespace`=0 and `page_is_redirect`=0 union SELECT "nl", count(*) articles, sum(`page_len`) taille, avg(`page_len`) moyenne FROM nlwiki_p.`page` where `page_namespace`=0 and `page_is_redirect`=0 union SELECT "sv", count(*) articles, sum(`page_len`) taille, avg(`page_len`) moyenne FROM svwiki_p.`page` where `page_namespace`=0 and `page_is_redirect`=0 union SELECT "ceb", count(*) articles, sum(`page_len`) taille, avg(`page_len`) moyenne FROM cebwiki_p.`page` where `page_namespace`=0 and `page_is_redirect`=0 union SELECT "ru", count(*) articles, sum(`page_len`) taille, avg(`page_len`) moyenne FROM ruwiki_p.`page` where `page_namespace`=0 and `page_is_redirect`=0 union SELECT "war", count(*) articles, sum(`page_len`) taille, avg(`page_len`) moyenne FROM warwiki_p.`page` where `page_namespace`=0 and `page_is_redirect`=0 union SELECT "es", count(*) articles, sum(`page_len`) taille, avg(`page_len`) moyenne FROM eswiki_p.`page` where `page_namespace`=0 and `page_is_redirect`=0 union SELECT "pl", count(*) articles, sum(`page_len`) taille, avg(`page_len`) moyenne FROM plwiki_p.`page` where `page_namespace`=0 and `page_is_redirect`=0 union SELECT "vi", count(*) articles, sum(`page_len`) taille, avg(`page_len`) moyenne FROM viwiki_p.`page` where `page_namespace`=0 and `page_is_redirect`=0 order by moyenne 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
.
Checking query status...
