Länge der Diskussionsseite von Benutzern

SQL

SELECT CONCAT('[[Benutzer Diskussion:', REPLACE(d.page_title, '_', ' '), ']]') AS "User",
       FORMAT(d.page_len, 0, 'de_DE') AS "Länge der Diskussionsseite",
       (SELECT GROUP_CONCAT(CONCAT('[[', IF(a.page_namespace = 2, 'Benutzer:', 'Benutzer Diskussion:'), a.page_title, ']]',
                                   if(pr_page IS NULL, '', CONCAT(' (', pr_level, ')'))
                                  )
                            ORDER BY a.page_title
                            SEPARATOR '<br />')
          FROM page AS a LEFT JOIN page_restrictions
                           ON pr_page = a.page_id
                          AND pr_type = 'edit'
                          AND pr_expiry = 'infinity'
         WHERE a.page_namespace IN (2,3)
           AND a.page_title LIKE CONCAT(d.page_title, '/Archiv%')
        GROUP BY SUBSTRING_INDEX(a.page_title, '/', 1)) AS "Archive",
       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 = REPLACE(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...
