use hewiki_p;

select distinct(replace(page_title, "_", " ")) as article, el_to as address from page join externallinks

on page_id = el_from

where (el_to like "%upload.wikimedia.org/wikipedia/commons%" or el_to like "%upload.wikimedia.org/wikipedia/he%" or

       el_to like "%https://www.google.co.il/url?" or el_to like "%.wikipedia.org/w%")

and not (el_to like "http://translate.google.com/translate?%" or el_to like "%action=history")

and page_namespace = 0

​