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 log_title, log_timestamp
  FROM (logging, Cat) LEFT JOIN (pagelinks, page AS DUP, imagelinks, categorylinks)
                        ON log_title = pl_title
                       AND pl_namespace = 6
                       AND DUP.page_id = pl_from
                       AND DUP.page_namespace = 4
                       AND il_to = log_title
                       AND il_from = cl_from
                       AND cl_to = Cat.page_title
 WHERE log_timestamp > '20231106'
   AND log_action = 'delete'
   AND log_namespace = 6
   AND cl_from IS NULL
SQL

Checking query status...
