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;