SELECT page.page_id, page.page_title, logging.log_timestamp, comment.comment_text

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 48 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;

​