Neue User - Quarry

SQL

SET @MINAGE=2;
SET @MAXAGE=6;
SET @ACTIVE=1;
SET @MINPOSTS=80;
SET @MAXPOST=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"
  FROM user, actor, revision_userindex
 WHERE actor_user = user_id
   AND rev_actor = actor_id
   AND user_registration BETWEEN REPLACE(CURDATE() - INTERVAL @MINAGE MONTH, '-', '') AND REPLACE(CURDATE() - INTERVAL @MAXAGE MONTH, '-', '')
   AND user_editcount BETWEEN @MINPOSTS AND @MAXPOSTS
 GROUP BY user_id
HAVING MAX(rev_timestamp) > REPLACE(CURDATE() - INTERVAL @AKTIVE MONTH, '-', '')
SQL

Checking query status...
