Nach Löschung wg. Löschdiskussion 2024 wieder angelegte Seiten

SQL

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;

SQL

Checking query status...