Artikel einer Kategorie inkl. Unterkategorien mit Erstellungsdatum

SQL

SET @StartCat = 'Chemische_Verbindung';
SET @MaxCatTiefe = 99;
WITH RECURSIVE Cat AS (
     SELECT page_title, page_id, 0 AS level
       FROM page
      WHERE page_title = REPLACE(@StartCat, ' ', '_')
        AND page_namespace = 14
      UNION
     SELECT SubCat.page_title, SubCat.page_id, Cat.level + 1
       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'
        AND Cat.level < @MaxCatTiefe
)
SELECT DISTINCT P.page_title, # <-- +DISTINCT
       REGEXP_REPLACE(rev_timestamp, '(....)(..)(..)(..)(..)(..)', '\\1-\\2-\\3 \\4:\\5:\\6') AS "Erstellung",
       actor_name
  FROM page AS P, categorylinks, Cat, revision, actor
 WHERE cl_to = Cat.page_title
   AND cl_from = P.page_id
   AND P.page_namespace = 0
   AND P.page_id = rev_page
   AND rev_parent_id = 0
   AND actor_id = rev_actor
 ORDER by Erstellung
SQL

Checking query status...
