Top WD users by number of redirects

SQL

USE wikidatawiki_p;
#simplified due to timeout
SELECT user_name, redirects/*user_editcount, total,*/ #, CAST(redirects AS INT) / CAST(total AS INT) as "ratio (redirects / total)"
	FROM user/*
	LEFT JOIN (SELECT *, COUNT(*) AS total FROM revision JOIN page ON page_id = rev_page
               WHERE rev_parent_id = 0 AND page_namespace = 0 GROUP BY rev_user) AS created
		ON created.rev_user = user_id*/
	LEFT JOIN (SELECT *, COUNT(*) AS redirects FROM revision JOIN page ON page_id = rev_page
               WHERE rev_parent_id = 0 AND page_namespace = 0 AND page_is_redirect = 1 GROUP BY rev_user) AS red
		ON red.rev_user = user_id
WHERE redirects > 300
ORDER BY redirects DESC
limit 100;
SQL

Checking query status...
