use orwiki_p;

SELECT LEFT(log_timestamp, 6) as month,  COUNT(*) FROM logging WHERE log_type="thanks" GROUP BY month;

SELECT count(page_title) FROM page LEFT JOIN categorylinks ON cl_from=page_id WHERE page_namespace=0 AND page_is_redirect=0 AND cl_from IS NULL;

SELECT count(page_title) FROM page LEFT JOIN pagelinks ON pl_from=page_id WHERE page_namespace=0 AND page_is_redirect=0 AND pl_from IS NULL;

SELECT count(page_title) FROM page LEFT JOIN imagelinks ON il_from=page_id WHERE page_namespace=0 AND page_is_redirect=0 AND page_len > 4000 AND il_from IS NULL;

select count(page_id) from page where page_namespace = 0 and page_is_redirect = 0 and page_len < 2048;

select count(page_id) from page where page_namespace = 0 and page_is_redirect = 0;

select count(article_id) from article where article_namespace = 0 and article_is_redirect = 0 and article_len < 6144;

​

​