NS0 - Quarry

SQL

SELECT Y.user_id AS user_id, Y.user_name AS user_name, Y.total AS total, Y.main AS main
FROM
(SELECT X.user_id, X.user_name, X.user_editcount AS total, COUNT(*) AS main
FROM revision_userindex
JOIN actor_revision ON rev_actor = actor_id
JOIN (SELECT * FROM user WHERE user_editcount >= 1500) AS X ON X.user_id = actor_user
JOIN page ON rev_page = page_id AND page_namespace = 0
GROUP BY X.user_id) AS Y
WHERE total >= 3000 OR main >= 1500
ORDER BY total DESC;

AخA
 
SELECT Y.user_id AS user_id, Y.user_name AS user_name, Y.total AS total, Y.main AS mainFROM(SELECT X.user_id, X.user_name, X.user_editcount AS total, COUNT(*) AS mainFROM revision_userindexJOIN actor_revision ON rev_actor = actor_idJOIN (SELECT * FROM user WHERE user_editcount >= 1500) AS X ON X.user_id = actor_userJOIN page ON rev_page = page_id AND page_namespace = 0GROUP BY X.user_id) AS YWHERE total >= 3000 OR main >= 1500ORDER BY total DESC;

SQL

Checking query status...