USER 1 hat erstellt, USER 2 hat geändert

SQL

SET @user1 = 'Leyo';
SET @user2 = 'Itti';
SELECT #REPLACE(page_title, '_', ' ') AS "Artikel",
       actCreated.actor_name AS "erstellt von",
       actEdited.actor_name AS "geändert von",
       REGEXP_REPLACE(revEdited.rev_timestamp, '^(....)(..).*$', '\\1-\\2') AS "geändert am",
       COUNT(*) AS "Anzahl"
  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
 GROUP BY actCreated.actor_name, REGEXP_REPLACE(revEdited.rev_timestamp, '^(....)(..).*$', '\\1-\\2')
 ORDER BY actCreated.actor_name, "geändert am", page_title
SQL

Checking query status...
