Neue User - Quarry

SQL

SET @MINAGE=2;
SET @MAXAGE=6;
SET @ACTIVE=1;
SET @MINEDIT=80;
SET @MAXEDIT=250;

SELECT CONCAT('[[Benutzer:', user_name, ']]') AS Benutzer,
       REGEXP_REPLACE(user_registration, '^\(....\)\(..\)\(..\).*$', '\\1-\\2-\\3') AS "Angemeldet",
       REGEXP_REPLACE(MAX(rev_timestamp), '^\(....\)\(..\)\(..\).*$', '\\1-\\2-\\3') AS "letzter Edit",
       COUNT(rev_page) AS "Anzahl Edits",
       COUNT(DISTINCT rev_page) AS "geänderte Artikel",
       SUM(rev_parent_id = 0) AS "Neuanlagen"
       SUM(rev_parent_id = 0 AND page_namespace = 0) AS "Neuanlagen im ANR"
  FROM user, actor, revision_userindex, page
 WHERE actor_user = user_id
   AND rev_actor = actor_id
   AND page_id = rev_page
   AND user_registration BETWEEN REPLACE(CURDATE() - INTERVAL @MAXAGE MONTH, '-', '') # Angemeldet vor @MAXAGE Monaten
                             AND REPLACE(CURDATE() - INTERVAL @MINAGE MONTH, '-', '') # Angemeldet bis @MINAGE Moanten
   AND user_editcount BETWEEN @MINEDIT # Minimale Anzahl Edits
                          AND @MAXEDIT # Maximale Anzahl Edits
 GROUP BY user_id
HAVING MAX(rev_timestamp) > REPLACE(CURDATE() - INTERVAL @ACTIVE MONTH, '-', '') # Nur aktive in den letzten @ACTIVE Monaten
SQL

Checking query status...
