use dewiki_p;

SELECT page_title AS "Weiterleitungsseite", comment_text AS "Änderungskommentar"

  FROM page LEFT JOIN revision ON rev_page = page_id AND rev_id = page_latest LEFT JOIN comment on rev_comment_id = comment_id

 WHERE NOT EXISTS ( SELECT 1

                      FROM pagelinks

                     WHERE pl_namespace = page_namespace

                       AND pl_title = page_title

                       AND pl_from_namespace IN (0, 10, 100)

                  )

   AND page_is_redirect = 1

   AND page_namespace = 0

   AND page_title LIKE "Liste%\_(%"

   AND comment_text LIKE "%verschob%"