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 "%strategywiki%"
and not el_to like "%antwiki.%" and not el_to like "%osx86project%" and not el_to like "%postgresql.%" #and not el_to like "%strategywiki%"
SQL

Checking query status...
