Fork of
Untitled query #63247
by MdsShakil
This query is marked as a draft
This query has been published
by MS Sakib.
SQL
AخA
SELECTSELECT actor.actor_name as Username,
COUNT(actor.actor_name) AS cnt
FROM page
JOIN revision ON page.page_id=revision.rev_page
JOIN actor ON revision.rev_actor=actor.actor_id
WHERE page.page_namespace=4666
GROUP BY actor.actor_name
ORDER BY cnt DESC
#LIMIT 20;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.