use hewiki_p;

select distinct(il_to) from imagelinks

where il_from_namespace in (0, 100)

and not il_to regexp '[א-ת]+'

and (il_to like '%.ogg' or il_to like '%.OGG' or il_to like '%.Ogg' or il_to like '%.ogv' or il_to like '%.OGV' or il_to like '%.webm' or

     il_to like '%.WebM' or il_to like '%.WEBM' or il_to like '%.Webm')

and exists

(select * from commonswiki_p.page

where il_to = page_title

and page_namespace = 6)

​