wikidata:Deleted trwiki pages by interwiki

SQL

USE wikidatawiki_p;
SELECT /*trwpl.pl_title, */REPLACE(comment_text, "/* clientsitelink-remove:1||trwiki */ ","") AS title, wdentity.page_title, COUNT(DISTINCT wips.ips_site_id) as cnt, 
GROUP_CONCAT(DISTINCT wips.ips_site_id SEPARATOR ", ") AS interwikis#, 
#(CASE WHEN ips_site_id="enwiki" THEN ips_site_page ELSE NULL END) AS enwiki_title,
#(CASE WHEN ips_site_id="enwiki" THEN enp.page_len ELSE NULL END) AS enwiki_len
FROM revision_userindex 
JOIN page wdentity ON rev_page=wdentity.page_id
JOIN comment_revision on rev_comment_id=comment_id AND comment_text LIKE "/* clientsitelink-remove:1||trwiki */ %"
JOIN actor_revision ON actor_id = rev_actor AND actor_name IN (SELECT REPLACE(pl_title,"_"," ") FROM trwiki_p.pagelinks WHERE pl_from=1400 AND pl_namespace=2 AND pl_from_namespace=4)
#JOIN trwiki_p.pagelinks trwpl ON 
#trwpl.pl_title=REPLACE(REPLACE(comment_text, "/* clientsitelink-remove:1||trwiki */ ","")," ","_")
#AND trwpl.pl_from = 2219492 AND trwpl.pl_from_namespace = 4 AND trwpl.pl_namespace = 0
LEFT JOIN wb_items_per_site AS wips ON 
wips.ips_item_id=REPLACE(wdentity.page_title,"Q","") 
AND wips.ips_site_id REGEXP "^[a-z]{2,3}_?(?:[a-z]{2,3})?wiki$"
AND NOT EXISTS (SELECT ips_item_id FROM wb_items_per_site AS wips1 WHERE 
                wips1.ips_item_id=wips.ips_item_id
                AND wips1.ips_site_id="trwiki")
#LEFT JOIN enwiki_p.page AS enp ON enp.page_title=REPLACE(ips_site_page, " ", "_") AND ips_site_id = "enwiki"
WHERE 
NOT EXISTS
(SELECT p1.page_title FROM trwiki_p.page AS p1
WHERE p1.page_title = REPLACE(REPLACE(comment_text, "/* clientsitelink-remove:1||trwiki */ ","")," ","_")
#AND trwpl.pl_namespace = 0
#AND p1.page_namespace = 0
)
#AND rev_timestamp <= (SELECT TIMESTAMP("2020-12-31 23:59:59"))
#AND rev_timestamp >= (SELECT TIMESTAMP("2020-01-01 00:00:00"))
AND comment_text NOT REGEXP("(?:Şablon:|Kategori:|Vikipedi:|Portal:)")
GROUP BY title HAVING cnt>9
ORDER BY cnt DESC;
SQL

Checking query status...
