Hewiki external links

SQL

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/wiki%" and not el_to like "%wikipedia%"))
#and not el_to like "%upload%"
and page_namespace = 0
and not el_to like "%commons%"
#and not el_to like "%wikimania20__.%"
and not el_to like "%stswiki.%" and not el_to like "%inkscape.%"
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 "%rationalwiki.%" and not el_to like "%ejwiki%" and not el_to like "%whatwg.%" and not el_to like "%antwiki.%"
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 "%Special:Statistics%"
and not el_to like "http://www.yeshiva.org.il/wiki/%"
and not el_to like "https://www.wikidata.org/wiki/Q%?uselang=he#P%"
and not el_to like "http://clinfowiki.org/%"
and not el_to in ("http://la.wikisource.org/wiki/Disputatio_pro_declaratione_virtutis_indulgentiarum?match=en")
                  #"http://en.wikisource.org/w/index.php?title=User:Tim_Starling/ScanSet_TIFF_demo&vol=12&page=EC2A067",
                  #"http://fr.wikisource.org/w/index.php?title=Fichier:Descartes_La_G%C3%A9om%C3%A9trie.djvu&page=9",
                  #"http://fr.wikisource.org/wiki/Appel_du_18_juin?match=en", "http://www.wikidata.org/wiki/Wikidata:Main_Page")
order by address
#check
SQL

Checking query status...
