Common & all editors

SQL

USE enwiki_p;

SELECT actor.actor_name FROM revision
LEFT JOIN actor ON actor.actor_id = revision.rev_actor
WHERE revision.rev_page IN(328215, 328206, 4675)
GROUP BY revision.rev_actor
HAVING COUNT(DISTINCT revision.rev_page) = 3
ORDER BY actor.actor_name;

SELECT actor.actor_name FROM revision
LEFT JOIN actor ON actor.actor_id = revision.rev_actor
WHERE revision.rev_page IN(328215, 328206, 4675)
AND /* NOT FOR ANON */ actor.actor_user # USERS ONLY
AND revision.rev_timestamp > 20150503000000 # START
AND revision.rev_timestamp < 20190503235959 # END
GROUP BY revision.rev_actor
ORDER BY actor.actor_name;
SQL

Checking query status...
