Change Details

SELECT page_id, revision_id, revision_parent_id, page_title, c.comment_text, FROM wmf.mediawiki_history mh LEFT JOIN wmf_raw.mediawiki_logging l ON mh.page_id = l.log_page LEFT JOIN wmf_raw.mediawiki_private_comment c ON l.log_comment_id = c.comment_id WHERE mh.snapshot = '2023-05' AND c.snapshot = '2023-05' AND l.snapshot = '2023-05' AND event_timestamp >= '2022-05-01' AND event_timestamp < '2023-06-01' AND event_entity = 'revision' AND event_type = 'create' AND log_type = 'delete' AND log_action = 'delete' AND page_namespace= 6 AND page_is_redirect IS NULL AND page_is_deleted AND mh.wiki_db = 'commonswiki' AND c.wiki_db = 'commonswiki' AND l.wiki_db = 'commonswiki' AND SIZE(event_user_is_bot_by) <= 0 AND SIZE(event_user_is_bot_by_historical) <= 0