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 rev.rev_timestamp BETWEEN '20200301' AND '20200326'
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';
*/
DESCRIBE wb_items_per_site;
SELECT MAX(ips_row_id) FROM wb_items_per_site;
SELECT * FROM wb_items_per_site WHERE ips_row_id IN (SELECT MAX(ips_row_id) FROM wb_items_per_site);
/*/
SELECT rc_title, COUNT(*) AS cnt FROM recentchanges_userindex
LEFT JOIN change_tag ON rc_id = ct_rc_id
WHERE ct_tag_id IS NULL
AND rc_source="mw.edit"
AND rc_bot = 0 AND rc_namespace = 0 AND rc_patrolled != 0
AND rc_timestamp BETWEEN 20200405000000 AND 20200407000000 AND rc_old_len<rc_new_len
AND rc_title NOT IN (SELECT pl_title FROM pagelinks WHERE pl_from = 26001882 AND pl_namespace = 0)
GROUP BY rc_title HAVING COUNT(DISTINCT rc_actor) >= 3 ORDER BY cnt DESC;
#*/
SQL

Checking query status...
