Untitled query #89303

SQL

WITH Kandidaten AS (
  SELECT RDTarget.page_namespace AS ns,
         RDTarget.page_title AS title,
         CONCAT('Verschoben aus ', RD.page_namespace, ':', 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
  FROM Kandidaten
 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
*/
SQL

Checking query status...
