WITH Kandidaten AS (

  SELECT RDTarget.page_namespace AS ns,

         RDTarget.page_title AS title,

         CONCAT('Verschub von ', CASE RD.page_namespace

                                   WHEN 0 THEN ''

                                   WHEN 2 THEN 'Benutzer:'

                                   WHEN 2 THEN 'Benutzer_Diskussion:'

                                   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, 2, 3, 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 CONCAT(CASE ns

                WHEN 0 THEN ''

                WHEN 4 THEN 'Wikipedia:'

                WHEN 10 THEN 'Vorlage:'

                WHEN 14 THEN 'Kategorie:'

                WHEN 100 THEN 'Portal:'

              END, title) AS "Wiedergänger",

       comment,

       REGEXP_REPLACE(ts, '(....)(..)(..)(..)(..)(..)', '\\1-\\2-\\3 \\4:\\5') AS "Zeit",

       GROUP_CONCAT(DISTINCT REGEXP_REPLACE(log_timestamp, '(....)(..)(..)(..)(..)(..)', '\\1-\\2-\\3 \\4:\\5') ORDER BY log_timestamp DESC SEPARATOR "\n") AS "Gelöscht am",

       GROUP_CONCAT(DISTINCT CONCAT('Wikipedia:', page_title) ORDER BY page_title DESC 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

​