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 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")

​