Untitled query #37567

SQL

use euwiki_p;
-- articles and disambiguation pages
-- SELECT SUM(page_len) AS totalsize 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');

-- 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');
SQL

Checking query status...
