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 "%wikinews%" # 14
and not el_to like "%wikivoyage%" # 48
and not el_to like "%wikiquote%" # 46
and not el_to like "%wikisource%" # 794
and not el_to like "%wikibooks%" # 24
and not el_to like "%wiktionary%" # 42
and not el_to like "%commons%" # 155 Ldorfman
and not el_to like "%meta%" # 8
and not el_to like "%wikiversity%" # 5
and not el_to like "%wikidata%" # 5
SQL

Checking query status...
