Untitled query #5741

SQL

SELECT
`user`.user_editcount,
`user`.user_name,
revision_userindex.rev_user_text,
COUNT(revision_userindex.rev_id) as total,
Sum(revision_userindex.rev_deleted = 0) as live_edits,
Sum(LENGTH(revision_userindex.rev_deleted) > 0) as deleted_edits
FROM
revision_userindex
INNER JOIN `user` ON revision_userindex.rev_user = `user`.user_id
WHERE
`user`.user_id NOT IN (SELECT user_groups.ug_user from user_groups where user_groups.ug_group = 'bot')
AND 
`user`.user_editcount > 1000
GROUP BY
`user`.user_id
ORDER BY `user`.user_editcount DESC
SQL

Checking query status...
