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 */
       pagelinks,
       revision AS newRev /* Erstellungsdatum der neuen Seite */
 WHERE rc_namespace = 0
   AND rc_new = 1
   AND newPage.page_title SOUNDS LIKE 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 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,
              CASE WHEN LENGTH(SUBSTRING_INDEX(SUBSTRING_INDEX(pl_title, '.', 1), '/', -1)) = 1 THEN CONCAT('0', SUBSTRING_INDEX(SUBSTRING_INDEX(pl_title, '.', 1), '/', -1))
                   ELSE SUBSTRING_INDEX(SUBSTRING_INDEX(pl_title, '.', 1), '/', -1)
              END) < SUBSTR(newRev.rev_timestamp, 1, 8)
SQL

Checking query status...
