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 "%.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%"