Untitled query #13702

SQL

USE ar.wiki_p;
SELECT creations_ns0.user, first_edit.timestamp as first_edit,
creations_ns0.count as article_creations,

FROM (SELECT COUNT(*) as count, creator.user as user
FROM (SELECT revision.rev_user_text as user
FROM (SELECT rev_page, MAX(rev_timestamp) as first_edit FROM page
INNER JOIN revision ON page.page_id = revision.rev_page
WHERE page.page_namespace = 0 AND page.page_is_redirect = 0 GROUP BY revision.rev_page)
as first_edit INNER JOIN revision ON first_edit.rev_page = revision.rev_page AND first_edit.first_edit = rev_timestamp)
as creator GROUP BY creator.user) as creations_ns0
  DESC LIMIT 10;
SQL

Checking query status...
