use hewiki_p;

select replace(page_title, "_", " ") as article, el_to as address from page join externallinks on page_id = el_from

where (el_to like "%action=edit%" or el_to like "%org/w/index.php%" or (el_to like "%wik%org/w%" and not el_to like "%upload.wikimedia.org%")

or el_to like "%upload.wikimedia.org/wikipedia/he%" or el_to like "%stats.wikimed%" or el_to like "%upload.wikimedia.org/wikipedia/commons%"

      or el_to like "https://he.wikipedia.org/w/index.php%")

and page_namespace = 0 #and not el_to like "%rationalwiki.%" and not el_to like "%action=history%"

#and not el_to like "%jugglewiki.%" and not el_to like "%openoffice%" and not el_to like "%wikileaks.%" and not el_to like "%strategywiki%"

#and not el_to like "%osx86project.%" and not el_to like "%postgresql.%" and not el_to like "%wikigallery.%" and not el_to like "%wikisage.%"

#and not el_to like "%wikiberal.%" and not el_to like "http://www.yeshiva.org.il/wiki/%" and not el_to like "http://clinfowiki.org/%"

#and not el_to like "https://www.wikidata.org/wiki/Q%?uselang=he#P%" #and not el_to like "%stswiki.%" and not el_to like "%inkscape.%"

#and not el_to = "http://la.wikisource.org/wiki/Disputatio_pro_declaratione_virtutis_indulgentiarum?match=en" and not el_to like "%antwiki.%"

#and not el_to like "%whatwg.%" and not el_to like "%ejwiki%" and not el_to like "https://www.google.co.il/url?%"

#and not page_title in ("אולואיד", "ויקיפדיה_הבולגרית")

#and not el_to like "%translate.google.com%" and not el_to like "%uselang=he%"  and not el_to like "%page=%" order by article # 21263

and  el_to like "https://he.wikipedia.org/w/index.php%"

​