List of articles on the English Wikipedia illustrated by a video. Animated GIF images longer than 10 seconds are considered a video for our purposes. Note this list is not perfect, in particular there may be some false negatives with ogg files (An ogg file is considered a video if it contains the string "theora" in the first 256 bytes of the file. This may miss some actual ogg videos, well at the same time mislabel some non-videos as video. Only main namespace counted. Last updated Tue 13 Feb 2024 08:06:16 PM UTC.
See also raw tsv of this data, and Most used commons videos on all wiki
| Page name | Commons videos on that page | Local videos | Commons long GIFs | Local long GIFs |
|---|
Total pages with video: -1
SQL Query:
SET session group_concat_max_len = 4096; select page_title, GROUP_CONCAT( i2.img_name separator ', ' ) as "commons videos", GROUP_CONCAT( i1.img_name separator ', ' ) as "enwiki videos", GROUP_CONCAT( i3.img_name separator ', ' ) as "commons long gifs", GROUP_CONCAT( i4.img_name separator ', ' ) as "enwiki long gifs" from page inner join imagelinks on il_from = page_id left join image i1 on il_to = i1.img_name and i1.img_media_type = 'VIDEO' left join commonswiki_p.image i2 on il_to = i2.img_name and i2.img_media_type = 'VIDEO' left join commonswiki_p.image i3 on il_to = i3.img_name and i3.img_media_type = 'BITMAP' and i3.img_major_mime = 'image' and i3.img_minor_mime = 'gif' and i3.img_metadata regexp '"duration";d:\\d{2,}' and i3.img_metadata not like '%s:10:"frameCount";i:1;%' left join image i4 on il_to = i4.img_name and i4.img_media_type = 'BITMAP' and i4.img_major_mime = 'image' and i4.img_minor_mime = 'gif' and i4.img_metadata regexp '"duration";d:\\d{2,}' and i4.img_metadata not like '%s:10:"frameCount";i:1;%' where page_namespace = 0 and (i1.img_name is not null or i2.img_name is not null or i3.img_name is not null or i4.img_name is not null) group by page_title;