newly created pages with deleted revisions

SQL

SELECT page.page_id, page.page_title
FROM page
INNER JOIN revision ON revision.rev_page = page.page_id
INNER JOIN logging ON logging.log_title = page.page_title
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)
AND logging.log_type = 'delete'
AND logging.log_action = 'delete'
AND logging.log_timestamp < revision.rev_timestamp
GROUP BY page.page_id, page.page_title
ORDER BY revision.rev_timestamp DESC;

SQL

Checking query status...