WITH RECURSIVE Cat AS (SELECT page_title

                         FROM page

                        WHERE page_title = 'License_tags'

                          AND page_namespace = 14

                        UNION

                       SELECT SubCat.page_title

                         FROM page AS SubCat, categorylinks, Cat

                        WHERE SubCat.page_namespace = 14

                          AND SubCat.page_title != 'Translated_license_tags'

                          AND cl_from = SubCat.page_id

                          AND cl_to = Cat.page_title

                          AND cl_type = "subcat"

                      )

SELECT CONCAT('[[Datei:', gil_to, '|rahmenlos|70px|', gil_to, ']]') AS Datei,

       GROUP_CONCAT(CONCAT('https://de.wikipedia.org/w/index.php?curid=', gil_page) SEPARATOR '<br />') As Einbindungen

  FROM globalimagelinks, page AS P, templatelinks AS PD_LICENSE

 WHERE gil_wiki = 'dewiki'

   AND gil_to = P.page_title

   AND P.page_namespace = 6

   AND PD_LICENSE.tl_from = P.page_id

   AND PD_LICENSE.tl_title = 'PD-US-no_notice'

   AND PD_LICENSE.tl_namespace = 10

   AND NOT EXISTS (SELECT 1

                     FROM templatelinks AS OTHER_LICENSES, page AS OTHER_LICENCE_PAGE, categorylinks, Cat

                    WHERE OTHER_LICENSES.tl_from = P.page_id

                      AND OTHER_LICENSES.tl_namespace = 10

                      AND OTHER_LICENSES.tl_title = OTHER_LICENCE_PAGE.page_title

                      AND tl_title != 'PD-US-no_notice'

                      AND OTHER_LICENCE_PAGE.page_namespace = 10

                      AND OTHER_LICENCE_PAGE.page_id = cl_from

                      AND cl_to = Cat.page_title

                  )

 GROUP BY gil_to

 LIMIT 100