Video file usage in English Wikipedia

SQL

USE enwiki_p; 

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,}' 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,}' 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;
SQL

Checking query status...
