Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
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
.
Toggle Highlighting
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
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
.
Checking query status...