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 != 10 AND page_namespace != 14 AND page_namespace != 100
AND cl_to NOT LIKE 'Raccourci%'
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
LIMIT 100

SQL

Checking query status...