Untitled query #62399

SQL

select
	rev_timestamp, comment_text, actor_name, ct_id, ctd_name
from revision
	inner join page on page_id = rev_page
	inner join actor on actor_id = rev_actor
	inner join user on user_id = actor_user
	left join comment on comment_id = rev_comment_id
    left join change_tag on ct_rev_id = rev_id
    left join change_tag_def on ctd_id = ct_tag_id and ctd_name in ("mw-manual-revert", "mw-undo", "mw-rollback")
where
    page_title = "Warszawa" and page_namespace = 0 and ctd_id is null
order by
	rev_timestamp desc;
SQL

Checking query status...
