Untitled query #70057

SQL

select DISTINCT p.page_title, c.comment_text, a.actor_name, r.rev_timestamp, p.page_namespace, r.rev_parent_id
from change_tag t
INNER JOIN change_tag_def ctd on ctd.ctd_id = t.ct_tag_id
INNER JOIN revision r on r.rev_id = t.ct_rev_id
INNER JOIN actor a ON r.rev_actor = a.actor_id
inner join comment c on c.comment_id = r.rev_comment_id
INNER JOIN page p on r.rev_page=p.page_id

#where r.rev_parent_id = 0
#AND r.rev_timestamp > 20210101000000
where comment_text like "%User:Mr. Ibrahem/%"
#and p.page_namespace = 0
;
SQL

Checking query status...
