SQL
AخA
USE commonswiki_p;
#SELECT COUNT(*), MIN(img_size), MAX(img_size), AVG(img_size), STDDEV_POP(img_size) FROM image WHERE img_minor_mime='webp';
# 1198 –> "Translations" namespace
SELECT page_title AS 'Page title', COUNT(*) AS 'Count' FROM page
INNER JOIN revision ON page_id=rev_page
INNER JOIN ip_changes ON rev_id=ipc_rev_id
WHERE page_namespace=1198 AND page_title REGEXP 'Commons:Wiki_Loves_Folklore/(?:[0-1]+|Page_display_title)/(?:id)'
GROUP BY page_id
ORDER BY 2 DESC, 1 ASC;
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.