(Commons) Videos by type and display resolution

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.

SQL

SELECT CONCAT('# [[File:',img_name,']]') as img_name, 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 = 480
      AND img_height = 360
LIMIT 1000
;

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