use dewiki_p;

SELECT page_title, rev_timestamp, comment_text, CONCAT('https://de.wikipedia.org/w/index.php?title=', page_title, '&diff=prev&oldid=', rev_id)

  FROM page, revision, actor_revision, comment_revision

 WHERE page_title LIKE "Löschkandidaten/%"

   AND page_namespace = 4

   AND page_id = rev_page

   AND rev_actor = actor_id

   AND actor_name = "Lutheraner"

   AND comment_id = rev_comment_id

   AND (comment_text like "Neuer Abschnitt%" OR comment_text like "[[%]]")

 ORDER BY rev_timestamp DESC;