(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 img_name, img_width, img_height from commonswiki_p.image
 WHERE (img_name LIKE "%.webm"
    OR img_name LIKE "%.ogv"
    OR img_name LIKE "%.ogg")
      AND img_width = 1024
      AND img_height = 1016
     ;

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