SELECT CONCAT('[[ ', REPLACE(gil_page_title, '_', ' '), ' ]]') AS "Artikel",

       GROUP_CONCAT(CONCAT('[[:Datei: ', REPLACE(page_title, '_', ' '), ' ]]<br/>') SEPARATOR ' ') AS "Bilder"

  FROM page, templatelinks, linktarget, globalimagelinks

 WHERE page_namespace = 6

   AND tl_from = page_id

   AND tl_from_namespace = 6

   AND tl_target_id = lt_id

   AND lt_namespace = 10

   AND lt_title = 'PD-US-no_notice'

   AND gil_to = page_title

   AND gil_wiki = 'dewiki'

   AND gil_page_namespace_id = 0 # ANR im Zielwiki

 GROUP BY gil_page_title

 ORDER BY COUNT(*) DESC