Untitled query #60010

SQL

with
userInfo as (select user_id As uid, user_name As uname, user_registration as uregdate, user_editcount as ueditcount from user),
pageArt as (SELECT actor.actor_id as uid, COUNT(revision.rev_actor) AS acticle FROM revision
			INNER JOIN page ON page.page_id = revision.rev_page
			JOIN actor ON revision.rev_actor = actor.actor_id
			WHERE page.page_is_redirect = 0 AND page.page_namespace = 0 AND revision.rev_parent_id = 0
            GROUP BY revision.rev_actor)
select userInfo.uid, userInfo.uname as UserName, cast(userInfo.uregdate as date) as Registration, userInfo.ueditcount as Editcount from userInfo join pageArt on pageArt.uid = userInfo.uid order by Editcount desc limit 25
SQL

Checking query status...
