USE ptwiki_p;

SELECT count(DISTINCT p.page_title) AS num_pages

FROM templatelinks tl

JOIN page p

ON tl.tl_from=p.page_id

WHERE p.page_namespace IN (0,1)

AND tl_namespace=10

AND tl_title = 'Marca_de_projeto';

​

SELECT count(DISTINCT page_title) AS num_level4_articles

FROM categorylinks

JOIN page

ON page_id=cl_from

WHERE cl_to LIKE '!Artigos\_de\_qualidade\_4%'

AND page_namespace IN (0,1);

​

SELECT count(DISTINCT page_title) AS num_level3_articles

FROM categorylinks

JOIN page

ON page_id=cl_from

WHERE cl_to LIKE '!Artigos\_de\_qualidade\_3%'

AND page_namespace IN (0,1);

​

SELECT count(DISTINCT page_title) AS num_level2_articles

FROM categorylinks

JOIN page

ON page_id=cl_from

WHERE cl_to LIKE '!Artigos\_de\_qualidade\_2%'

AND page_namespace IN (0,1);

​

SELECT count(DISTINCT page_title) AS num_level1_articles

FROM categorylinks

JOIN page

ON page_id=cl_from

WHERE cl_to LIKE '!Artigos\_de\_qualidade\_1%'

AND page_namespace IN (0,1);

​