Untitled query #38554

SQL

use arwiki_p;
SELECT creations_ns0.user

FROM 
(SELECT actor_name as user

FROM
 (SELECT rev_page, MIN(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

LEFT JOIN
(SELECT COUNT(*) as count,
 creator.user as user

WHERE creations_ns0.user NOT IN (SELECT user_name FROM user_groups INNER JOIN user ON user_id = ug_user WHERE ug_group = 'bot')
GROUP BY creations_ns0.user ORDER BY article_creations DESC LIMIT 500;
SQL

Checking query status...
