PU catégorisées avec des articles (juste les pages = sans doublon)

SQL

SELECT DISTINCT page_namespace, page_title, cl_to
FROM categorylinks AS cl1
JOIN page AS pg1
ON cl1.cl_from = pg1.page_id
WHERE page_namespace != 0
AND page_namespace != 6 	#image
AND page_namespace != 10 	#modèle
AND page_namespace != 14 	#catégorie
AND page_namespace != 100 	#projet
AND cl_to NOT LIKE 'Raccourci%'		#les raccourcis (tels que WP: et P:) sont dans l'espace principal
AND NOT (cl_to LIKE 'Article%avancement%' OR cl_to LIKE 'Article%importance%')	#cas des cat d'éval à traiter à part
AND EXISTS (SELECT 1
            FROM page AS pg2
            JOIN categorylinks AS cl2
            ON pg2.page_id = cl2.cl_from
            WHERE pg2.page_namespace = 0
            AND cl1.cl_to = cl2.cl_to)
AND NOT EXISTS(SELECT 1
			FROM page_props
			WHERE pp_page = (SELECT page_id
                             FROM page AS pg3
                             WHERE pg3.page_namespace = 14 AND pg3.page_title = cl1.cl_to)
			AND pp_propname LIKE '%hiddencat%')
ORDER BY page_title
SQL

Checking query status...
