Untitled query #88461

SQL

-- Set the database to Tamil Wikipedia
USE tawiki_p;

-- Set the database to Tamil Wikipedia
USE tawiki_p;

SELECT 
    actor.actor_name AS user_name, 
    COUNT(DISTINCT page.page_id) AS unique_pages_created
FROM page
JOIN revision ON page.page_id = revision.rev_page
JOIN actor ON revision.rev_actor = actor.actor_id
LEFT JOIN user_groups ON actor.actor_user = user_groups.ug_user
WHERE page_namespace = 0 
  AND page_is_redirect = 0
  AND revision.rev_id = ( -- Get the first revision for each page
      SELECT MIN(rev_id) 
      FROM revision 
      WHERE revision.rev_page = page.page_id
  )
  AND (user_groups.ug_group IS NULL OR user_groups.ug_group != 'bot') -- Exclude bot accounts
GROUP BY actor.actor_name
ORDER BY unique_pages_created DESC
LIMIT 100;
SQL

Checking query status...
