SQL
AخA
USE commonswiki_p;
SELECT
actor_name, count(rev_page)
FROM revision
JOIN page ON page_id = rev_page
JOIN actor ON actor_id = rev_actor
JOIN categorylinks ON cl_from = page_id
WHERE
rev_parent_id=0 /* nově založené, tj. nemělo minulou revizi */
AND
page_namespace = 6 /* namespace 6 jsou File: */
AND
cl_to LIKE 'Mediagrant\_III%'
GROUP BY actor_name;
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.