Länge der Diskussionsseite von Benutzern

SQL

SELECT CONCAT('[[Benutzer Diskussion:', d.page_title, ']]') AS "User",
       FORMAT(d.page_len, 0, 'de_DE') AS "Länge der Diskussionsseite",
       (SELECT CONCAT('[[', IF(a.page_namespace = 2, 'Benutzer:', 'Benutzer Diskussion:'), a.page_title, ']]')
          FROM page AS a
         WHERE a.page_namespace IN (2,3)
           AND a.page_title LIKE CONCAT(d.page_title, '/Archiv%') LIMIT 1) AS "Hat Archiv?",
       REGEXP_REPLACE(MAX(rev_timestamp), '(....)(..)(..)(..)(..)(..)', '\\1-\\2-\\3 \\4:\\5:\\6') AS "letzter Edit des Users"
  FROM page AS d LEFT JOIN (revision_userindex, actor)
                   ON actor_name = d.page_title
                  AND rev_actor = actor_id
 WHERE d.page_namespace = 3
   AND d.page_title NOT LIKE "%/%"
   AND d.page_len > 0.5*1024*1024
 GROUP BY d.page_title
 ORDER BY d.page_len
SQL

Checking query status...
