*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 ('Flemming_Meyer','Stephen_Masters_(rower)','Tadashi_Abe_(rower)','Stewart_Douglas-Mann','Karl_Hudspith','Nicholas_Tee','Andrew_David_Lobbenberg','Søren_Henrichsen','Dennis_Larsen','Teja_Töpfer','Torben_Bech_Jensen','Carsten_Glud','Matthias_Edeler','Dirk_Jenny','Vladimir_Vukelic','Uwe_März','Klaus_Klotz','Jon_Berney','Alastair_Isherwood','Rob_Mitchell_(rower)','Michael_Wiseman_(rower)','Tim_Wright_(rower)','Oliver_Ibielski','Andreas_Laiss','Daniel_Rosenberger','Manuel_Strauch','Olaf_Kaska','Giuseppe_Del_Gaudio','Nicola_Moriconi','Marco_Paniccia','Bruno_Pasqualini','Martin_Hasse','Carsten_Borchardt','Birger_Schmidt','Matthias_Hobein','Abdel_Fattah_Abou-Shanab','Anna_Accensi','Ezio_Acchini','Mario_Acchini')
--    AND el_index LIKE 'http://com.worldrowing%'
    AND el_index LIKE 'https://com.sports-reference%'
    AND pp_propname='wikibase_item'
;
SQL

Checking query status...
