Common & all editors

SQL

USE enwiki_p;

# SELECT actor_name FROM actor WHERE actor_id IN (

# OR:
/*
SELECT DISTINCT rev_actor FROM revision WHERE rev_page IN(328215, 328206)
*/
  
/*
SELECT DISTINCT r1.rev_actor FROM revision r1
INNER JOIN revision r2 ON r2.rev_actor = r1.rev_actor
INNER JOIN revision r3 ON r3.rev_actor = r1.rev_actor
WHERE r1.rev_page = 328215 AND r2.rev_page = 328206 AND r3.rev_page = 4675
*/

# AND:

SELECT DISTINCT actor.actor_name FROM revision
LEFT JOIN actor ON actor.actor_id = revision.rev_actor
WHERE revision.rev_page IN(328215, 328206, 4675);

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;

# )
SQL

Checking query status...
