use hewiki_p;

select distinct(il_to) from imagelinks

where il_from_namespace in (0, 100)

and exists

(select * from commonswiki_p.page

where il_to = page_title

and page_namespace = 6

and (page_title like '%.ogg' or

     page_title like '%.OGG' or

     page_title like '%.Ogg' or

     page_title like '%.ogv' or

     page_title like '%.OGV' or

     page_title like '%.webm' or

     page_title like '%.WebM' or

     page_title like '%.WEBM' or

     page_title like '%.Webm'))

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

​