Fantastique Autumn 2019 on UkWP [Improved]

SQL

USE ukwiki_p;
SET SESSION group_concat_max_len = 10000;

SELECT  @rownum := @rownum + 1 AS rank,
  IFNULL(actor_name, 'Всього'),
  created,
  total_len,
  articles
FROM
  (
    SELECT
      CONCAT('[[', REPLACE(page_title, '_', ' '), ']]') as article,
      COUNT(1) AS user_number,
      SUM(user_size_increase) as size_increase,
      GROUP_CONCAT(
          DISTINCT
          REPLACE(
            CONCAT(
              '[[Користувач:', rev_user_text, '|', ']]', 
              ' (', user_size_increase ,')')
            , '_', ' ')
          ORDER BY user_size_increase DESC, rev_user_text
          SEPARATOR ' · '
      ) AS users
    FROM
      (SELECT
         rev.rev_user_text,
         article.page_title,
         SUM(rev.rev_len) - SUM(parent_rev.rev_len) AS user_size_increase
       FROM page article
         -- отримати версії статей
         JOIN revision rev
           ON rev.rev_page = article.page_id AND
    		201909241000000 <= rev_timestamp AND 
    		rev_timestamp < 20019121610000000
         -- разом із попередніми версіями
         JOIN revision parent_rev
           ON parent_rev.rev_id = rev.rev_parent_id

         -- і на сторінці обговорення чи у статі
         JOIN page talk
           ON talk.page_title = article.page_title AND
              talk.page_namespace IN (0, 1)
         -- має бути шаблон
      JOIN templatelinks ON
                           tl_from = talk.page_id AND
                           tl_title = 'Поліпшені_статті_фантастичної_осені_2019' AND
                           tl_namespace = 10
      join actor on revision.rev_actor = actor_id and actor_user is not null
    WHERE
      article.page_namespace = 0 AND
      article.page_is_redirect = 0
    GROUP BY rev_actor WITH ROLLUP) t,
  (SELECT @rownum := -1) r
ORDER BY created DESC, total_len DESC
SQL

Checking query status...
