A magyar Wikipédia mérete

SQL

USE huwiki_p;
SELECT NOW() AS date, SUM(page_len)/(1024*1024) AS 'total (MiB)', COUNT(page_id) AS articles, AVG(page_len) AS 'average (B)'
	FROM page
    WHERE page_namespace = 0 AND page_is_redirect = 0;

SELECT NOW() AS date, SUM(page_len)/(1024*1024) AS 'total (MiB)', COUNT(page_id) AS articles, AVG(page_len) AS 'average (B)'
	FROM page
    WHERE page_namespace = 0;

SELECT NOW() AS date, SUM(page_len)/(1024*1024) AS 'total (MiB)', COUNT(page_id) AS articles, AVG(page_len) AS 'average (B)'
	FROM page;

SQL

Checking query status...