Hewiki external links

SQL

use hewiki_p;
select replace(page_title, "_", " ") as article, el_index 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 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",
                  "https://fr.wikisource.org/w/index.php?title=Page:Michaud_-_Biographie_universelle_ancienne_et_"
                  "moderne_-_1843_-_Tome_41.djvu/173&action=edit&redlink=1")
#check
SQL

Checking query status...
