USER 1 hat erstellt, USER 2 hat geändert

SQL

SET @user1 = 'Leyo';
SET @user2 = 'Itti';
SELECT page_title, actCreated.actor_name AS "Ersteller", actEdited.actor_name AS "Änderer"
  FROM page, revision AS revCreated, actor AS actCreated, revision AS revEdited, actor AS actEdited
 WHERE page_namespace = 0
   AND revCreated.rev_page = page_id
   AND revCreated.rev_parent_id = 0
   AND revCreated.rev_actor = actCreated.actor_id
   AND actCreated.actor_name IN (@user1, @user2)
   AND revEdited.rev_page = page_id
   AND revEdited.rev_actor = actEdited.actor_id
   AND actEdited.actor_name IN (@user1, @user2)
   AND revCreated.rev_actor != revEdited.rev_actor

SQL

Checking query status...