Untitled query #77987

SQL

WITH RECURSIVE Cat AS (
      SELECT page_title, page_id
        FROM page
       WHERE page_title = 'Wikipedia:Dateiüberprüfung'
         AND page_namespace = 14
UNION SELECT SubCat.page_title, SubCat.page_id
        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 DISTINCT CONCAT('Datei:', log_title), log_timestamp, pl_from
  FROM (logging, Cat) LEFT JOIN pagelinks
                        ON log_title = pl_title      # Die gelöschte Datei
                       AND pl_namespace = 6          # -- "" --
                       AND Cat.page_id = pl_from     # ist auf einer Seite aus Kat+Unterkat Wikipedia:Dateiüberprüfung
 WHERE log_timestamp > '20231106'
   AND log_action = 'delete'
   AND log_namespace = 6
   #AND pl_from IS NULL
SQL

Checking query status...
