select rev_id, rev_timestamp, user_name, page_namespace, page_title, comment_text 

from revision inner join comment on rev_comment_id = comment_id inner join page on rev_page = page_id

    inner join actor on rev_actor = actor_id left join user on actor_user = user_id

    left join user_groups on user_id = ug_user and ug_group = 'bot'

where page_namespace not in (2,3) -- skip user/user talk

and coalesce(user_name, '') not in ('WikiBayer', 'Мегадятел') -- skip a wave of page move vandalism from May 2024

and case when user_name is null then true else ug_group is null end

order by rev_timestamp desc;