Untitled query #55774

SQL

WITH RecentPages AS (
    SELECT page.page_id, page.page_title
    FROM page
    INNER JOIN revision ON revision.rev_page = page.page_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 24 HOUR)
)
SELECT RecentPages.page_id, RecentPages.page_title
FROM RecentPages
INNER JOIN logging ON logging.log_title = RecentPages.page_title
WHERE logging.log_type = 'delete'
AND logging.log_action = 'delete'
AND logging.log_timestamp < (SELECT MIN(revision.rev_timestamp) FROM revision WHERE revision.rev_page = RecentPages.page_id)
ORDER BY (SELECT MIN(revision.rev_timestamp) FROM revision WHERE revision.rev_page = RecentPages.page_id) DESC;
SQL

Checking query status...
