Untitled query #49151

SQL

use itwiki_p;

select linter_cat, page_namespace, 
count(*) from linter join page on page.page_id = linter.linter_page
group by linter_cat, page_namespace
order by linter_cat asc, page_namespace asc;

select linter_cat, 
count(*), count(distinct page_namespace) from linter join page on page.page_id = linter.linter_page
group by linter_cat
order by linter_cat asc;

select page_namespace, 
count(*), count(distinct linter_cat) from linter join page on page.page_id = linter.linter_page
group by page_namespace
order by page_namespace asc;
SQL

Checking query status...
