Untitled query #3552

SQL

USE enwiki_p;
SELECT p.page_title, COUNT(pl.pl_from) FROM page p
INNER JOIN categorylinks c ON c.cl_from = p.page_id AND c.cl_to = 'All_non-free_media'
INNER JOIN imagelinks il ON p.page_title = il.il_to AND il.il_from_namespace = 0
INNER JOIN page p2 ON p2.page_id = il.il_from
LEFT JOIN redirect r ON p2.page_title = r.rd_title AND p2.page_namespace = r.rd_namespace
LEFT JOIN page p3 ON r.rd_from = p3.page_id
LEFT JOIN pagelinks pl ON pl.pl_from = p.page_id AND
     ((pl.pl_namespace = p2.page_namespace AND pl.pl_title = p2.page_title) OR
      (pl.pl_namespace = p3.page_namespace AND pl.pl_title = p3.page_title))
WHERE p.page_namespace = 6
AND pl.pl_from IS NULL
GROUP BY p.page_id
SQL

Checking query status...
