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 distinct count(1) from externallinks where el_to_domain_index = "https://org.wikidata.query." and el_to_path != "/" limit 10
#AND el_to_domain_index LIKE '%query.wikidata.org/%';

SQL

Checking query status...