ruwiki quality level page transclusions

SQL

USE ruwiki_p;
SELECT count(DISTINCT pd.page_id) AS numarticles_level_1_t
FROM page ps
JOIN templatelinks tl
ON (tl_namespace=page_namespace AND tl_title=page_title)
JOIN page pd
ON tl.tl_from=pd.page_id
WHERE pd.page_namespace IN (0,1) AND ps.page_id=287381;

SELECT count(DISTINCT cl_from) AS numarticles_level_1_c
FROM page p
JOIN categorylinks cl
ON p.page_id=cl.cl_from
WHERE cl_to LIKE 'Статьи_проекта%I_уровня'
AND p.page_namespace IN (0,1);


SELECT count(*) AS numarticles_level_2
FROM page ps
JOIN templatelinks tl
ON (tl_namespace=page_namespace AND tl_title=page_title)
JOIN page pd
ON tl.tl_from=pd.page_id
WHERE pd.page_namespace IN (0,1) AND ps.page_id=287383;
SELECT count(*) AS numarticles_level_3
FROM page ps
JOIN templatelinks tl
ON (tl_namespace=page_namespace AND tl_title=page_title)
JOIN page pd
ON tl.tl_from=pd.page_id
WHERE pd.page_namespace IN (0,1) AND ps.page_id=287384;
SELECT count(*) AS numarticles_level_4
FROM page ps
JOIN templatelinks tl
ON (tl_namespace=page_namespace AND tl_title=page_title)
JOIN page pd
ON tl.tl_from=pd.page_id
WHERE pd.page_namespace IN (0,1) AND ps.page_id=287385;
SQL

Checking query status...
