Untitled query #72526

SQL

  SELECT
            comment.comment_text AS "deleted_page",
            revision.rev_timestamp AS "date_of_delete",
            wb_items_per_site.ips_site_page AS "name_of_page"
        FROM
            revision
            JOIN page ON page.page_id = revision.rev_page
            JOIN comment ON comment.comment_id = revision.rev_comment_id
            JOIN wb_items_per_site ON wb_items_per_site.ips_item_id = REPLACE(page.page_title, "Q", "")
        WHERE
            comment.comment_text LIKE "%clientsitelink-remove%" AND
            comment.comment_text LIKE "%enwiki%" AND
            YEAR(rev_timestamp) in (2019,2018,2017,2016) and 
            wb_items_per_site.ips_site_id LIKE "arwiki"
SQL

Checking query status...
