Test Queries - Quarry

SQL

SELECT user_id
                     FROM (SELECT user_id,
                           SUM(userspace) AS userspace_total,
                           SUM(usertalk) AS usertalk_total,
                           SUM(other) AS other_total,
                           COUNT(rev_id) AS total
                           FROM (SELECT user.user_id,
                                 revision_userindex.rev_id,
                                 CASE
                                 WHEN page.page_namespace = 2 THEN 1
                                 ELSE 0
                                 END AS userspace,
                                 CASE
                                 WHEN page.page_namespace = 3 THEN 1
                                 ELSE 0
                                 END AS usertalk,
                                 CASE
                                 WHEN page.page_namespace NOT IN (2,3) THEN 1
                                 ELSE 0
                                 END AS other
                                 FROM user
                                 JOIN actor On user.user_id = actor.actor_user
                                 JOIN revision_userindex ON revision_userindex.rev_actor = actor.actor_id
                                 JOIN page ON revision_userindex.rev_page = page.page_id) AS user_revs
                           GROUP BY user_id
                           HAVING total < 500 AND (userspace_total + usertalk_total) / total > 0.9) AS user_stats
                		LIMIT 1
SQL

Checking query status...
