SQL
x
use commonswiki_p;
SELECT COUNT(DISTINCT page_title) AS FilesUsed, COUNT(gil_wiki) AS Uses, COUNT(DISTINCT gil_wiki) AS NbWikis
FROM page
JOIN categorylinks
JOIN globalimagelinks
JOIN image ON image.img_name = page.page_title
WHERE page.page_id=categorylinks.cl_from
AND gil_to = page_title
AND categorylinks.cl_to = "Media_supported_by_Wikimedia_France"
AND img_timestamp BETWEEN 20150701000000 AND 20160101000000;
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.