SELECT gil_to, gil_page_namespace, gil_page_title

FROM globalimagelinks

WHERE gil_wiki = 'enwiki'

  AND gil_to IN

    (SELECT DISTINCT lt_title

     FROM pagelinks

     JOIN page ON page_id = pl_from

     JOIN linktarget ON lt_id = pl_target_id

     WHERE page_namespace = 4

       AND page_title = 'Deletion_requests/Files_uploaded_by_Diliff'

       AND lt_namespace = 6)

ORDER BY gil_to, gil_page_namespace, gil_page_title;