How many files of different types do we have across Wikis?

Fork of How many files of different types do we have across Wikis? by Miriam (WMF)

This query is marked as a draft This query has been published by Kasyap.

SQL

select tewiki_p as wiki,img_media_type,count(distinct(gil_to)) as distinct_file_count,count(gil_to) as tot_image_file_pairs  from globalimagelinks #imagelinks contains the links from pages to images
join image
on img_name=gil_to
where gil_page_namespace_id=0
group by gil_wiki,img_media_type
#limit 100

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...