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, 4675)
*/
  
/*
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 rev_actor FROM revision WHERE rev_page IN(328215, 328206, 4675) GROUP BY rev_actor HAVING COUNT(3)

)
SQL

Checking query status...
