Enwiki external links to query.wikidata.org

This query is marked as a draft This query has been published by HTriedman (WMF).

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

use wikidatawiki_p;
#SELECT
#	page_id,
#    page_title,
#    CONCAT(REGEXP_REPLACE(el_to_domain_index, '^(.*?://)(?:([^.]+)\\.)([^.]+\\.)?([^.]+\\.)?([^.]+\\.)?([^.]+\\.)?([^.]+\\.)?([^.]+\\.)?([^.]+\\.)$', '\\1\\9\\8\\7\\6\\5\\4\\3\\2'), el_to_path) AS url
#FROM externallinks, page
#WHERE el_from = page_id
#AND el_to_domain_index LIKE '%query.wikidata.org/%';
# AND el_to_domain_index = "https://org.wikidata.query"

select * from externallinks limit 10

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...