Untitled query #22345

SQL

USE dewiki_p;
SELECT rc_title, rc_title AS "Neue Seite", pl_title AS "Ähnl. Seite", rc_timestamp AS "RC-Timestamp", pl_title as "LK-Seite"
  FROM recentchanges,
       /*page AS newPage, /* die neue Seite */
       page AS lkPage, /* 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 lkPage.page_title LIKE "Löschkandidaten/%"
   AND lkPage.page_title != "Löschkandidaten/Urheberrechtsverletzungen"
   AND lkPage.page_namespace = 4
   AND pl_from = lkPage.page_id
   AND pl_from_namespace = lkPage.page_namespace
   AND pl_namespace = 0

   AND pl_title SOUNDS LIKE rc_title

   /*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(rc_timestamp, 1, 8)
   LIMIT 20
SQL

Checking query status...
