Autoren nach Land, Geschlecht und Geb.Jahrzehnt

SQL

WITH RECURSIVE Cat AS (SELECT page_title, page_id, 'ES' AS CatGroup
                        FROM page
                       WHERE page_title = 'Inselgruppe_(Spanien)'
                         AND page_namespace = 14
                       UNION
                      SELECT page_title, page_id, 'MM' AS CatGroup
                        FROM page
                       WHERE page_title = 'Inselgruppe_(Mittelmeer)'
                         AND page_namespace = 14
                       UNION
                      SELECT SubCat.page_title, SubCat.page_id, Cat.CatGroup
                        FROM page AS SubCat, categorylinks, Cat
                       WHERE SubCat.page_namespace = 14
                         AND cl_from = SubCat.page_id
                         AND cl_to = Cat.page_title
                         AND cl_type = "subcat"
                     )
SELECT page.page_title
  FROM page
 WHERE EXISTS (SELECT 1
                     FROM categorylinks, Cat
                    WHERE cl_from = page_id
                      AND cl_to = Cat.page_title
                      AND Cat.CatGroup = 'MM'
                   )
SQL

Checking query status...
