WITH Kandidaten AS (

  SELECT RDTarget.page_namespace AS ns,

         RDTarget.page_title AS title,

         CONCAT('Verschoben aus ', 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, ts, CONCAT('Wikipedia:', page_title)

  FROM Kandidaten, page AS LK, pagelinks, linktarget

 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

 ORDER BY ts DESC

/* SELECT LK.page_title, WG.page_title

  FROM page AS LK, pagelinks, linktarget, page as WG

 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 = WG.page_title

   AND lt_namespace = WG.page_title

*/