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 "%upload.wikimedia.org/wikipedia/commons%"

       or (el_to like "%wik%org/w%" /* and not el_to like "%wikipedia.org/w%" */ and not el_to like "%upload.wikimedia.org%")

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

and page_namespace = 0 and not el_to like "%//commons%" 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%"

order by article;

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

where el_to like "https://www.google.co.il/url?%" and page_namespace = 0

​