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 rev_actor, rev_page FROM revision WHERE rev_page IN(328215, 328206) GROUP BY rev_actor HAVING COUNT(DISTINCT rev_page) = 2

# )
SQL

Checking query status...
