Edit summary - Quarry

SQL

USE elwiki_p; SELECT rev_user_text, total_count, summary_count, minor_count FROM
(SELECT rev_user_text, rev_user, COUNT(rev_id) AS total_count FROM decrevs GROUP BY rev_user) AS totrev,
(SELECT rev_user, SUM(rev_summary) AS summary_count FROM decrevs GROUP BY rev_user) AS summaryrev,
(SELECT rev_user, SUM(rev_minor_edit) AS minor_count FROM decrevs GROUP BY rev_user) AS minorrev
WHERE totrev.rev_user = summaryrev.rev_user AND totrev.rev_user = minorrev.rev_user
AND totrev.rev_user <> 0 ORDER BY total_count DESC;
SQL

Checking query status...
