USE `commonswiki_p`;

​

SELECT COUNT(*) AS `videos`, COUNT(DISTINCT `gil_page_title`) AS `articles`

FROM `globalimagelinks`

WHERE `gil_wiki` = 'svwiki' -- select different target wiki here (warning: probably prohibitively slow for very large wikis)

AND `gil_page_namespace_id` = 0

AND (`gil_to` LIKE '%.oga' OR `gil_to` LIKE '%.mp3' OR `gil_to` LIKE '%.mid' OR `gil_to` LIKE '%.wav' OR `gil_to` LIKE '%.flac'OR `gil_to` LIKE '%.ogg');