SQL
AخA
USE azwiki_p;
SELECT Concat('#[[User:',img_user,']]') AS 'Username', img_user, COUNT(img_name) AS uploads
FROM image
WHERE img_user NOT IN (
SELECT rev_user
FROM revision
JOIN page
ON rev_page = page_id
AND page_namespace = 0 )
GROUP BY img_user
LIMIT 1;
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.