Lengths of audio files powering Wikiradio stations

Note that any files whose lengths could not be determined by Commons on upload are excluded from the overall lengths printed.

SQL

select p.pl_title,
#if((p.pl_title like '%.oga') or (p.pl_title like '%.ogg'),
#     substring_index(substring_index(q.img_metadata,'"length";d:',-1),";",1),
#if(p.pl_title like '%.flac',
#     substring_index(substring_index(q.img_metadata,'"playtime_seconds";i:',-1),";",1),
#     substring_index(substring_index(q.img_metadata,'"playtime_seconds";d:',-1),";",1)
#)) as total_length
q.img_metadata
from metawiki_p.pagelinks p
join commonswiki_p.image q
on p.pl_title = q.img_name
where p.pl_from = 9953197;

SQL

Checking query status...