Fork of
Untitled query #13904
by Ата
This query is marked as a draft
This query has been published
by Base.
SQL
AخA
SELECT
`page_title`,
COUNT(*)
FROM `revision_userindex`
JOIN `page`
ON `page_id` = `rev_page`
WHERE `rev_user` = (SELECT `user_id` FROM `user` WHERE `user_name` = 'Ата')
AND `page_namespace` = 0
GROUP BY `page_title`
LIMIT 400;
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.