select

    page_namespace,

    count(page_id)

from

    page

where

    page_namespace in ( 10, 828 ) and -- Template, Module

    page_title not like '%/doc' and

    page_is_redirect <> 1 -- Don't count redirects

group by

    page_namespace;