Untitled query #24924

SQL

USE wikidatawiki_p;
/*
SELECT page_title, rev.rev_id, (parent.rev_len - rev.rev_len) AS delta, rev.rev_timestamp
FROM revision_userindex AS rev
JOIN page ON page_id = rev.rev_page
JOIN actor_revision ON rev.rev_actor = actor_id
JOIN comment_revision ON rev.rev_comment_id = comment_id
JOIN revision AS parent ON parent.rev_id = rev.rev_parent_id
WHERE actor_name = 'MatSuBot'
AND rev.rev_timestamp BETWEEN '20190216' AND '20200214'
AND parent.rev_len > 500
AND parent.rev_len - 500 > rev.rev_len
AND page_namespace = 0
AND comment_text LIKE '%add missing labels; cleanup';*/
SELECT pl_title, page_namespace, page_title FROM pagelinks JOIN page ON page_id = pl_from
WHERE pl_namespace = 0 AND pl_title IN (
  'Q19890754', 'Q21193653', 'Q28913509', 'Q14325730', 'Q75395027', 'Q75395026', 'Q75381376', 'Q75381363', 'Q71963720',
  'Q71963788', 'Q75381347')
AND page_namespace IN (0, 120, 146);
SQL

Checking query status...
