Untitled query #85331

SQL

SELECT
        DISTINCT p.page_title AS title,
        #SUBSTRING_INDEX(SUBSTRING_INDEX(
          c.comment_text,
          #, 'Ibrahem/', -1), ']]', 1) AS 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
        ctd.ctd_name in (
            "contenttranslation",
            "contenttranslation-v2"
        ) #id = 3 # id = 120
        # AND r.rev_parent_id = 0
        # AND r.rev_timestamp > 20210101000000
        AND r.rev_timestamp > 20240101000000
        AND comment_text like "%User:Mr. Ibrahem/%" #AND p.page_namespace = 0
    GROUP BY
        p.page_title,
        a.actor_name,
        c.comment_text
SQL

Checking query status...
