Fork of
Hewiki external links
by IKhitron
This query is marked as a draft
This query has been published
by IKhitron.
SQL
AخA
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 = 0and ((el_to like "%.google.%" and el_to like "http%http%" #and not el_to like "%translate.google%" and not el_to like "http%http%?%"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 page_title = "דמטריוס_פוליורקטס"
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.