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 page_namespace = 0
and (((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 "%upload.wikimedia.org/wikipedia/commons%" or el_to like "%stats.wikimed%")
and not el_to like "%rationalwiki.%" and not el_to like "%action=history%" and not el_to like "%uselang=he%" and not el_to like "%page=%"
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 page_title in ("אולואיד", "ויקיפדיה_הבולגרית")
and not el_to like "%translate.google.com%") or (el_to like "%.google.%http%" and not (el_to like "http://www.google.co.il/url?%"
or el_to like "https://www.google.co.il/url?%" or el_to like "http://www.google.com/url?%" or el_to like "%google%")) or
(((el_to like "%.google.%" and el_to like "http%http%" and not el_to like "%translate.google%" and el_to like "%?%"
and not ((el_to like "http://www.google.co.il/url?%" or el_to like "https://www.google.co.il/url?%"
or el_to like "http://www.google.com/url?%" or el_to like "https://www.google.com/url?%") and (el_to like "%&url=%"
or el_to like "%&q=%" or el_to like "%?url=%" or el_to like "%?q=%"))) or ((el_to like "http://www.google.co.il/url?%"
or el_to like "https://www.google.co.il/url?%" or el_to like "http://www.google.com/url?%" or el_to like "https://www.google.com/url?%")
and not (el_to like "%&url=%" or el_to like "%&q=%" or el_to like "%?url=%" or el_to like "%?q=%"))) and not el_to like "http://archive.is%"
and not el_to like "http://web.archive.org%" and not el_to like "https://web.archive.org%" and not page_title = "עוואלי")) order by article
SQL

Checking query status...
