dewiki: total size (in bytes) of wikitext (ns0)

SQL

USE dewiki_p;

-- all namespaces
SELECT SUM(page_len) AS totalsize FROM page; # WHERE page_is_redirect!=1 AND page_namespace=0;
SELECT COUNT(page_id) AS numofpages FROM page;

-- articles and disambiguation pages
SELECT SUM(page_len) AS totalsize FROM page WHERE page_is_redirect!=1 AND page_namespace=0;
SELECT COUNT(page_id) AS numofpages FROM page WHERE page_is_redirect!=1 AND page_namespace=0;

-- articles only
SELECT SUM(page_len) AS totalsize FROM page WHERE page_namespace=0 AND page_is_redirect!=1 AND page_id NOT IN (SELECT pp_page FROM page_props WHERE pp_propname='disambiguation');
SELECT COUNT(page_id) AS numofpages FROM page WHERE page_namespace=0 AND page_is_redirect!=1 AND page_id NOT IN (SELECT pp_page FROM page_props WHERE pp_propname='disambiguation');

-- disambiguation pages only
SELECT SUM(page_len) AS totalsize FROM page WHERE page_namespace=0 AND page_is_redirect!=1 AND page_id IN (SELECT pp_page FROM page_props WHERE pp_propname='disambiguation');
SELECT COUNT(page_id) AS numofpages FROM page WHERE page_namespace=0 AND page_is_redirect!=1 AND page_id IN (SELECT pp_page FROM page_props WHERE pp_propname='disambiguation');
SQL

Checking query status...
