Users by number of created articles on frwiki

Fork of Users by number of created articles on skwiki by Teslaton

This query is marked as a draft This query has been published by Pyb en résidence.

SQL

-- USE skwiki_p;

SELECT
    a.actor_name, COUNT(*) as count_total
  FROM
    page p, revision rf, actor_user a
  WHERE
    rf.rev_page = p.page_id AND rf.rev_parent_id = 0 AND
    a.actor_id = rf.rev_actor AND
    p.page_namespace = 0 AND
    p.page_is_redirect = 0
  GROUP BY
    a.actor_name
  ORDER BY
    count_total desc
  ;
  
SELECT
    a.actor_name, COUNT(*) as count_12m
  FROM
    page p, revision rf, actor_user a
  WHERE
    rf.rev_timestamp >= DATE_SUB(now(), INTERVAL 12 MONTH) AND
    rf.rev_page = p.page_id AND rf.rev_parent_id = 0 AND
    a.actor_id = rf.rev_actor AND
    p.page_namespace = 0 AND
    p.page_is_redirect = 0
  GROUP BY
    a.actor_name
  ORDER BY
    count_12m desc
  ;

SQL

Checking query status...