Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
SR5
.
Toggle Highlighting
SQL
USE enwiki_p; SELECT pp_value, "P3684", CONCAT( '"', REPLACE( REPLACE( el_to, "https://www.driverdb.com/drivers/", "" ), "/", "" ), '"' ) AS id, "S143", "Q1551807" FROM (SELECT * FROM externallinks WHERE el_to LIKE "https://www.driverdb.com/drivers/%") AS el# AND el_to RLIKE "/id[0-9]+/?$") AS el JOIN (SELECT * FROM page WHERE page_namespace = 0 AND page_title NOT LIKE "Seznam%") AS cs ON cs.page_id = el_from JOIN (SELECT * FROM page_props WHERE pp_propname = "wikibase_item") AS props ON pp_page = cs.page_id JOIN (SELECT * FROM wikidatawiki_p.page WHERE page_namespace = 0) AS wd ON wd.page_title = pp_value WHERE wd.page_id NOT IN ( SELECT pl_from FROM wikidatawiki_p.pagelinks WHERE pl_namespace = 120 AND pl_title = "P3684" AND pl_from_namespace = wd.page_namespace ) AND wd.page_id IN ( SELECT pl_from FROM wikidatawiki_p.pagelinks WHERE pl_namespace = 0 AND pl_title = "Q5" AND pl_from_namespace = wd.page_namespace ) GROUP BY cs.page_title HAVING COUNT(DISTINCT id) = 1 ORDER BY pp_value;
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
.
Checking query status...