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/w%" and not el_to like "%upload.wikimedia.org%")
or el_to like "%upload.wikimedia.org/wikipedia/he%" or el_to like "%stats.wikimedia%" or el_to like "%upload.wikimedia.org/wikipedia/commons%")
and (page_namespace = 0 or page_title = "IKhitron/טיוטה") and not el_to like "%rationalwiki.%" and not el_to like "%action=history%"
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 "%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 "http://www.yeshiva.org.il/wiki/%" and not el_to like "http://clinfowiki.org/%"
and not el_to like "https://www.wikidata.org/wiki/Q%?uselang=he#P%" and not el_to like "%stswiki.%" and not el_to like "%inkscape.%"
and not el_to = "http://la.wikisource.org/wiki/Disputatio_pro_declaratione_virtutis_indulgentiarum?match=en" and not el_to like "%antwiki.%"
and not el_to like "%whatwg.%" and not el_to like "%ejwiki%" and not el_to like "https://www.google.co.il/url?%" and not page_title = "אולואיד"
and not el_to like "%translate.google.com%" and not el_to like "%uselang=he%"  and not el_to like "%page=%" order by article # 21263
SQL

Checking query status...
