USE tewiki_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;

​