use pmswiki_p;

select linter_cat, 

count(*) from linter join page on page.page_id = linter.linter_page 

group by linter_cat;