Untitled query #18384

SQL

SELECT 
  wp.page_title AS Title,
  pp_value,
  el_to
FROM page AS wp
JOIN externallinks ON el_from = wp.page_id
JOIN page_props    ON pp_page = wp.page_id AND pp_propname = "wikibase_item"
/* Wikidata */
JOIN wikidatawiki_p.page AS wdp ON wdp.page_namespace = 0 AND wdp.page_title = pp_value
LEFT JOIN wikidatawiki_p.pagelinks AS wdpl
  ON wdpl.pl_from = wdp.page_id AND wdpl.pl_namespace = 120 AND wdpl.pl_title = 'P1447'
WHERE wp.page_namespace = 0
AND   el_to     LIKE 'http://www.procyclingstats.com/rider.php?%'
AND   wdpl.pl_from IS NULL;
SQL

Checking query status...
