Untitled query #42176

SQL

USE dewiki_p;
SELECT pp_value, "P3684",
CONCAT( '"', SUBSTRING_INDEX( REPLACE( REPLACE( el_to, "https://www.driverdb.com/drivers/", "" ), "http://www.driverdb.com/drivers/", "" ), "/", 1 ), '"' ) AS id,
"S143", "Q8449"
FROM (SELECT * FROM externallinks 
      WHERE (el_to LIKE "https://www.driverdb.com/drivers/%" OR el_to LIKE "http://www.driverdb.com/drivers/%")
      AND el_to NOT LIKE "%/article/%"
      AND el_to NOT LIKE "%/discover/%") AS el
JOIN (SELECT * FROM page WHERE page_namespace = 0) AS pages ON pages.page_id = el_from
JOIN (SELECT * FROM page_props WHERE pp_propname = "wikibase_item") AS props ON pp_page = pages.page_id
JOIN (SELECT * FROM wikidatawiki_p.page WHERE page_namespace = 0) AS wd ON wd.page_title = pp_value
SELECT pl_from FROM wikidatawiki_p.pagelinks WHERE pl_namespace = 0 AND pl_title = "Q5" AND pl_from_namespace = wd.page_namespace
)
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 pages.page_title NOT LIKE "%album%"
#AND pages.page_title NOT LIKE "%song%"
#AND pages.page_title NOT LIKE "%discography%"
#AND pages.page_title NOT LIKE "List%"
# pl_title IN ("Q11424", "Q15416", "Q24862", "Q202866", "Q5398426")
GROUP BY pages.page_title HAVING COUNT(DISTINCT id) = 1;
SQL

Checking query status...
