Fork of
Hewiki external links
by IKhitron
This query is marked as a draft
This query has been published
by IKhitron.
SQL
x
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 "%.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 "https://www.google.com/url?%")
#(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=%" and not el_to like "%&q=%"
#and not el_to like "%?url=%" and not el_to like "%?q=%"
and page_namespace = 0
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.