Testi per numero di pagine

SQL

SELECT CONCAT('# [[', page_title, ']] (', COUNT(*), ')')
FROM pagelinks, page
WHERE pl_from = page_id
AND page_namespace = 0
AND page_is_redirect = 0
AND pl_namespace = 108
AND pl_from IN
(SELECT page_id
FROM page, categorylinks
WHERE page_namespace = 0
AND page_id = cl_from
 AND (cl_to LIKE 'Testi_SAL_25%'))
AND pl_from IN
(SELECT page_id
FROM page, categorylinks
WHERE page_namespace = 0
AND page_id = cl_from
 AND (cl_to LIKE 'Testi_con_versione_cartacea_a_fronte'))
GROUP BY page_title
HAVING COUNT(*)=0
ORDER BY COUNT(*) DESC;
SQL

Checking query status...
