Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Reguyla
.
This report shows a list of images by type and display resolution. Todo: Link to categorylinks to eliminate those already categorized into the Video display resolution categories.
Toggle Highlighting
SQL
SELECT CONCAT('# [[File:',img_name,']]') as img_name, CONCAT('Category:',img_width,' x ',img_height) as VDR_cat, img_width, img_height from commonswiki_p.image WHERE img_name LIKE "%.webm" # OR img_name LIKE "%.ogg" # OR img_name LIKE "%.ogv") AND img_width BETWEEN 11 AND 30 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...