Enwiki external links to query.wikidata.org

Get external links from en.wikipedia.org that are linking to query.wikidata.org with an associated SparQL query in the URL parameters. Originally by PAC2, updated for new externallinks table schema for Mediawiki ≥1.41. By iterating through each associated project, we can collect many SparQL queries.

SQL

#SELECT
#	p.page_id,
#	p.page_title,
#	e.el_to_path
	#CONCAT(REGEXP_REPLACE(e.el_to_domain_index, '^(.*?://)(?:([^.]+)\\.)([^.]+\\.)?([^.]+\\.)?([^.]+\\.)?([^.]+\\.)?([^.]+\\.)?([^.]+\\.)?([^.]+\\.)$', '\\1\\9\\8\\7\\6\\5\\4\\3\\2'), e.el_to_path) AS url
#FROM externallinks e
#JOIN page p
#ON e.el_from = p.page_id
#WHERE
#	el_to_domain_index = "https://org.wikidata.query."
#	OR el_to_domain_index = "http://org.wikidata.query."

select *
from externallinks
where el_to_domain_index = "https://merhav.nli.org.il/primo-explore/fulldisplay?docid=ULI_Main003775956&context=L&vid=ULI&lang=iw_IL&utm_source=he.wikipedia.org&utm_medium=referral&utm_campaign=%22%D7%91%D7%90%D7%92%D7%A1%D7%99+%D7%A1%D7%99%D7%92%D7%9C%22&utm_content=ULI" and el_to_path != "/"

SQL

Checking query status...