Untitled query #75759

SQL

SELECT
    actor.actor_name,
    MIN(rev_timestamp) AS first_edit_date,
    SUM(CASE WHEN page.page_namespace = 0 THEN 1 ELSE 0 END) AS namespace_0,
    SUM(CASE WHEN page.page_namespace = 10 THEN 1 ELSE 0 END) AS namespace_10,
    SUM(CASE WHEN page.page_namespace = 12 THEN 1 ELSE 0 END) AS namespace_12,
    SUM(CASE WHEN page.page_namespace = 14 THEN 1 ELSE 0 END) AS namespace_14,
    SUM(CASE WHEN page.page_namespace = 100 THEN 1 ELSE 0 END) AS namespace_100,
    SUM(CASE WHEN page.page_namespace = 1 THEN 1 ELSE 0 END) AS namespace_1
FROM
    actor
INNER JOIN
    revision_userindex ON revision_userindex.rev_actor = actor.actor_id
INNER JOIN
    page ON revision_userindex.rev_page = page.page_id
WHERE
    actor.actor_user IS NOT NULL
    AND page.page_namespace IN (0, 10, 12, 14, 100, 1)
GROUP BY
    actor.actor_name
ORDER BY 
    namespace_0 DESC
LIMIT
    500;
SQL

Checking query status...
