Untitled query #89303

SQL

WITH Kandidaten AS (
  SELECT RDTarget.page_namespace AS ns,
         RDTarget.page_title AS title,
         CONCAT('WL von ', CASE RD.page_namespace
                             WHEN 0 THEN ''
                             WHEN 4 THEN 'Wikipedia:'
                             WHEN 10 THEN 'Vorlage:'
                             WHEN 14 THEN 'Kategorie:'
                             WHEN 100 THEN 'Portal:'
                           END, RD.page_title) AS comment,
         rev_timestamp AS ts
    FROM page AS RD, revision, redirect, page AS RDTarget
   WHERE RD.page_is_redirect = 1
     AND RD.page_id = rev_page
     AND RD.page_namespace IN (0, 4, 10, 14, 100)
     AND rev_parent_id = 0
     AND rev_timestamp > REPLACE(DATE_SUB(CURDATE(), INTERVAL 1 WEEK), '-', '')
     AND rd_from = RD.page_id
     AND rd_namespace IN (0, 4, 10, 14, 100)
     AND RDTarget.page_title = rd_title
     AND RDTarget.page_namespace = rd_namespace
  UNION SELECT page_namespace, page_title, '', rev_timestamp
    FROM page, revision
   WHERE page_namespace IN (0, 4, 10, 14, 100)
     AND page_id = rev_page
     AND rev_parent_id = 0
     AND rev_timestamp > REPLACE(DATE_SUB(CURDATE(), INTERVAL 1 WEEK), '-', '')
       )
SELECT ns, title, comment, REGEXP_REPLACE(ts, '(....)(..)(..)(..)(..)(..)', '\1 \2 \3 \4:\5'),
       GROUP_CONCAT(REGEXP_REPLACE(log_timestamp, '(....)(..)(..)(..)(..)(..)', '\1 \2 \3 \4:\5') SEPARATOR "\n") AS "Gelöscht am",
       GROUP_CONCAT(CONCAT('Wikipedia:', page_title) SEPARATOR "\n") AS "Löschdiskussionen"
  FROM Kandidaten, page AS LK, pagelinks, linktarget, logging
 WHERE LK.page_namespace = 4
   AND LK.page_title LIKE "Löschkandidaten%"
   AND pl_from = LK.page_id
   AND pl_target_id = lt_id
   AND lt_namespace = 0
   AND lt_title = title
   AND lt_namespace = ns
   AND log_namespace = ns
   AND log_title = title
   AND log_action = 'delete'
   AND log_type = 'delete'
 GROUP BY ns, title
 ORDER BY ts DESC
SQL

Checking query status...
