-- all namespaces

-- SELECT SUM(page_len) AS totalsize FROM page;

-- SELECT COUNT(page_id) AS numofpages FROM page;

​

-- articles and disambiguation pages

-- SELECT SUM(page_len) AS totalsize FROM page WHERE page_namespace=0 AND page_is_redirect!=1;

-- SELECT COUNT(page_id) AS numofpages FROM page WHERE page_namespace=0 AND page_is_redirect!=1;

​

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

-- SELECT AVG(page_len) AS meansize 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 page_len 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');