azwiki article creators

SQL

USE enwiki_p;

SELECT
  @rownum := @rownum + 1 AS rank,
  user_name,
  created,
  percents
FROM (
  SELECT 
    CONCAT('[[User:', rev_user_text, '|]]') AS user_name,
    COUNT(*) AS created,
    CONCAT(
      ROUND(
        COUNT(*) / (
          SELECT COUNT(*) 
          FROM page 
          JOIN (SELECT DISTINCT pl_from FROM pagelinks) pl 
            ON pl.pl_from = page.page_id
          WHERE page_namespace = 0 AND page_is_redirect = 0
        ) * 100, 2
      ), '%'
    ) AS percents
  FROM page
  JOIN revision
    ON revision.rev_page = page.page_id
   AND revision.rev_parent_id = 0
  JOIN (SELECT DISTINCT pl_from FROM pagelinks) pl
    ON pl.pl_from = page.page_id
  WHERE
    page_namespace = 0
    AND page_is_redirect = 0
    AND NOT EXISTS (
      SELECT 1
      FROM user_groups
      WHERE ug_user = revision.rev_user
        AND ug_group = 'bot'
    )
  GROUP BY rev_user_text
  HAVING created >= 30
  ORDER BY created DESC
) AS t
JOIN (SELECT @rownum := 0) AS r
ORDER BY created DESC;
SQL

Checking query status...
