pt-WP project-tagged articles

SQL

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);
SQL

Checking query status...
