Untitled query #35662

SQL

USE wikidatawiki_p;
SELECT items.page_title, comment_text
FROM revision_userindex
JOIN page AS items ON items.page_id = rev_page
JOIN `comment` ON comment_id = rev_comment_id
CROSS JOIN hywiki_p.page AS hy
WHERE rev_user_text = 'MatSuBot'
AND rev_timestamp > '201905'
AND comment_text LIKE '/* wbsetsitelink-remove:1|hywiki */ %'
AND hy.page_namespace = 0
AND hy.page_title = REPLACE(SUBSTRING_INDEX(REPLACE(comment_text, '/* wbsetsitelink-remove:1|hywiki */ ', ''), ', ', 1), ' ', '_');
/*
SELECT log_title, page_title
FROM logging
JOIN page ON page_id = log_page
LEFT JOIN wikidatawiki_p.wb_items_per_site AS ips1 ON ips_site_id = 'hywwiki' AND ips_site_page = REPLACE(page_title, '_', ' ')
WHERE log_type = 'import' AND log_namespace = 0
AND ips_item_id IS NULL;
#*/
SQL

Checking query status...
