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;

​