USE enwiki_p;

SELECT  pagetitle, cnt FROM 

(

    SELECT concat('* [[:File:', i_p.page_title, ']] - ') as pagetitle, count(*) AS cnt

    FROM page i_p

    INNER JOIN imagelinks i ON i.il_to = i_p.page_title

    INNER JOIN page p ON i.il_from = p.page_id AND i.il_from_namespace = 0

    INNER JOIN categorylinks c2 ON i_p.page_id = c2.cl_from AND c2.cl_to = "All_non-free_media"

    GROUP BY i_p.page_title

    HAVING COUNT(*) >= 5

) c2

ORDER BY c2.cnt DESC, c2.pagetitle