Untitled query #22345

SQL

USE dewiki_p;
SELECT rc_title, rc_timestamp, pl_title, lkRev.rev_timestamp AS "LK-Timestamp", 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 */
       revision AS lkRev  /* Erstellungsdatum Löschkandidaten */
 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_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
SQL

Checking query status...
