SELECT page.page_title AS 'Seitenname', revision.rev_timestamp AS 'Zeitpunkt der Neuerstellung', logging.log_timestamp AS 'Zeitpunkt der Löschung', comment.comment_text AS 'Löschbegründung'

FROM page

INNER JOIN revision ON revision.rev_page = page.page_id

INNER JOIN logging ON logging.log_title = page.page_title

INNER JOIN comment ON logging.log_comment_id = comment.comment_id

WHERE page.page_namespace = 0

AND page.page_is_redirect = 0

AND revision.rev_parent_id = 0

AND revision.rev_timestamp >= DATE_SUB(NOW(), INTERVAL 364 DAY)

AND logging.log_type = 'delete'

AND logging.log_action = 'delete'

AND logging.log_timestamp < revision.rev_timestamp

AND comment.comment_text like '%[[WP:LK|Löschdiskussion]]%'

GROUP BY page.page_id, page.page_title

ORDER BY revision.rev_timestamp DESC;

​