Untitled query #10407

SQL

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(page_id) from page where page_namespace = 0 and page_is_redirect = 0 and page_len < 6144;
SQL

Checking query status...
