# - Quarry

SQL

#use arwiki_p;
select DISTINCT p.page_title, c.comment_text , a.actor_name , r.rev_timestamp
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 ctd.ctd_name in (
  	"contenttranslation", #id = 3
  "contenttranslation-v2" # id = 120
)
#AND a.actor_name in ('Mr. Ibrahem')
AND r.rev_timestamp > 20210101000000 #BETWEEN 20201201000000 AND 20210101000000
#and comment_text like "%[[:en:Special:Redirect/revision/%|User:Mr. Ibrahem/%]]%"
and comment_text like "%User:Mr. Ibrahem/%"
#limit 10
;
SQL

Checking query status...
