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

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 gil_wiki 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

​x
 
select gil_wiki 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 imagesjoin imageon img_name=gil_towhere gil_page_namespace_id=0group 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.

This query has never yet been executed