Untitled query #22345

SQL

USE dewiki_p;
SELECT rc_title, rc_timestamp, pl_title, newRev.rev_timestamp AS "PG-Timestamp"
  FROM recentchanges,
       page AS newPage, /* die neue Seite */
       page as lkPage, /* die Löschkandidaten-Seite */
       pagelinks,
       revision AS newRev /* Erstellungsdatum der neuen Seite */
 WHERE rc_namespace = 0
   AND rc_new = 1
   AND newPage.page_title = rc_title
   AND newPage.page_namespace = rc_namespace
   AND pl_from = newPage.page_id
   AND pl_from_namespace = newPage.page_namespace
   AND pl_title LIKE "Löschkandidaten/%"
   AND pl_title != "Löschkandidaten/Urheberrechtsverletzungen"
   AND pl_namespace = 4
   AND newRev.rev_page = newPage.page_id
   AND newRev.rev_parent_id = 0
   AND lkPage.page_title = pl_title
   AND lkPage.page_namespace = pl_namespace
   AND lkRev.rev_page = lkPage.page_id
   AND lkRev.rev_parent_id = 0
   AND CONCAT(SUBSTRING_INDEX(pl_title, '_', -1),
              CASE WHEN SUBSTRING_INDEX(SUBSTRING_INDEX(pl_title, '_', 2), '_', -1) = "Januar" THEN "01"
                   WHEN SUBSTRING_INDEX(SUBSTRING_INDEX(pl_title, '_', 2), '_', -1) = "Februar" THEN "02"
                   WHEN SUBSTRING_INDEX(SUBSTRING_INDEX(pl_title, '_', 2), '_', -1) = "März" THEN "03"
                   WHEN SUBSTRING_INDEX(SUBSTRING_INDEX(pl_title, '_', 2), '_', -1) = "April" THEN "04"
                   WHEN SUBSTRING_INDEX(SUBSTRING_INDEX(pl_title, '_', 2), '_', -1) = "Mai" THEN "05"
                   WHEN SUBSTRING_INDEX(SUBSTRING_INDEX(pl_title, '_', 2), '_', -1) = "Juni" THEN "06"
                   WHEN SUBSTRING_INDEX(SUBSTRING_INDEX(pl_title, '_', 2), '_', -1) = "Juli" THEN "07"
                   WHEN SUBSTRING_INDEX(SUBSTRING_INDEX(pl_title, '_', 2), '_', -1) = "August" THEN "08"
                   WHEN SUBSTRING_INDEX(SUBSTRING_INDEX(pl_title, '_', 2), '_', -1) = "September" THEN "09"
                   WHEN SUBSTRING_INDEX(SUBSTRING_INDEX(pl_title, '_', 2), '_', -1) = "Oktober" THEN "10"
                   WHEN SUBSTRING_INDEX(SUBSTRING_INDEX(pl_title, '_', 2), '_', -1) = "November" THEN "11"
                   WHEN SUBSTRING_INDEX(SUBSTRING_INDEX(pl_title, '_', 2), '_', -1) = "Dezember" THEN "12"
                   ELSE "99"
              END,
              SUBSTRING_INDEX(pl_title, '.', 1)) < SUBSTR(newRev.rev_timestamp, 1, 8)
SQL

Checking query status...
