*wiki: extract FISA IDs/Sports-Reference IDs from Wikipedia pages

SQL

USE enwiki_p;

SELECT
    pp_value,
    el_to,
	page_title
FROM externallinks JOIN page ON el_from=page_id JOIN page_props ON page_id=pp_page
WHERE
	page_namespace=0
    AND page_title IN ('Thierry_Renault','Ben_Storey_(rower)','Kevin_Cotter_(rower)','Martin_Schwartz_(rower)','Kamal_Abdel_Rehim','Ali_Abdel_Sami','Mohamed_Abdel_Sami','Wolfgang_Fritsch','Peter_Werner_(rower)','Hans-Ludwig_Zimmer','Lutz_Neubert','Peter_Huck','Helmut_Sassenbach','Christopher_Drury','Hans-Hermann_Meyer','Paul_Lutz','Ekkehard_Braun','Gerd_Maye','Volker_Buhren','Günter_Lobing','Bernd_Kerkhoff','Frank_Neumeister','Hans-Josef_Büsken','Jürgen_Nentwig','Bernd_Nehmer','Nigel_Read','Paul_Stuart-Bennett','Christopher_George_(rower)','Stephen_Simpole','Colin_Cusack','Duncan_Innes','Peter_Zeun','Francisco_Goicoechea_García','Luis_Arteaga_Leon','Jaime_Uriarte_García','José_Antonio_Expósito_Sánchez','Antonio_Elizalde','Dionisio_Redondo_González','Javier_Puertas_Cabezudo','Pedro_Olasagasti_Arruti','David_Hosking','Ivar_Molgaard','Arne_Højlund','Søren_Hansson','Mikael_Espersen','Peter_Klug-Andersen','Vittorio_Valentinis','Renzo_Borsini','Lanfranco_Borsini','Leonardo_Salani','Clive_Roberts','Simon_Jeffries','Bent_Fransson','Valentino_Tontodonati','Alejandro_Moya_(rower)','José_Manuel_Cañete','Eulogio_Genova','Carlos_Muniesa','José_Crespo_(rower)','Víctor_Llorente','José_Rojí','Leif_Jacobsen','Jan_Christensen','Karsten_Kobbernagel','Jan_Rasmussen','Michele_Savoia','Paolo_Marostica','Massimo_Di_Deco','Maurizio_Losi','Sebastiano_Zanetti','Luigi_Velotti','Svend_Blitskov','Martin_Sorensen','Alfredo_Striani','Enrico_Barbaranelli','Sabino_Bellomo','Franco_Falossi','Giuseppe_Lamberti','Fabrizio_Ranieri','Domenico_Cantoni','Johnny_Bo_Andersen','Thomas_Croft_(rower)','Jan_Hansen_(rower)','Jeppe_Jensen_Kollat','Bo_Vestergaard','Simon_Cox_(rower)','Steve_Ellis_(rower)','Dave_Lemon','Jim_McNiven','John_Deakin_(rower)')
--  AND el_index LIKE 'http://com.worldrowing%'
    AND el_index LIKE 'https://com.sports-reference%'
    AND pp_propname='wikibase_item'
;
SQL

Checking query status...
