Untitled query #71969

This query is marked as a draft This query has been published by BilledMammal.
SQL

SELECT page_title, year.cl_to, country.cl_to
FROM page
JOIN categorylinks AS year ON year.cl_from = page_id
JOIN categorylinks AS country ON country.cl_from = page_id
WHERE page_title IN ('Aarne_Lindholm', 'Achille_Morin', 'Adamo_Bozzani', 'Addin_Tyldesley', 'Adjutant_Lemoine', 'Adolf_Schmal_(sport_shooter)', 'Adolf_Tannert', 'Adolph_Weber', 'Adolphe_Rouleau', 'Aladár_von_Farkas', 'Albert_Bechestobill', 'Albert_Gauthier', 'Albert_Hawkins_(wrestler)', 'Albert_Johnstone', 'Albert_Rose_(wrestler)', 'Albert_Stüdemann', 'Albert_Taylor_(diver)', 'Albert_Whittingstall', 'Albert_Wyatt', 'Aleksandr_Akhyun', 'Aleksandr_Shkylev', 'Aleksandr_Soldatenkov_(fencer)', 'Aleksandr_Tillo', 'Aleksandr_Yelizarov_(athlete)', 'Aleksey_Selikhov', 'Alexander_Beckett', 'Alexander_Duncan_(athlete)', 'Alexander_Martin_(Canadian_sport_shooter)', 'Alexandre_Bergès', 'Alexandre_Chantelat', 'Alexandre_Fayollat', 'Alexandre_Guillemand', 'Alf_Davies_(swimmer)', 'Alfons_Brehm', 'Alfonso_Sánchez_(athlete)', 'Alfred_Banbrook', 'Alfred_Black_(sport_shooter)', 'Alfred_Goddard', 'Alfred_Hodges', 'Alfred_Keene', 'Alfred_Nau', 'Alfred_Schwarz', 'Alfred_Syson', 'Alfred_Yeoumans', 'Alphonse_Eggremont', 'Alphonse_Moquet', 'Alvin_Kritschmann', 'Amilcare_Beretta', 'Amédée_Aubry', 'Anastasios_Antonopoulos', 'Anastasios_Koutoulakis', 'Anatoly_Jakovlev', 'Anders_Møller_(wrestler)', 'Anders_Tamminen', 'Andor_Horvag', 'Andreas_Asimakopoulos', 'Andreas_Kempf_(gymnast)', 'Andreas_von_Flotow', 'Andrew_Neu', 'André-Marie_Rabel', 'André_Angelini', 'André_Barbillat', 'André_Duprez', 'André_Labat', 'André_Mercier', 'André_de_Romilly', 'Antal_Lovas', 'Anthony_Jahnke', 'Antoine_Costa', 'Antoine_De_Buck', 'Antonie_de_Gee', 'Antonio_Cotichini', 'António_Pereira_(wrestler)', 'Archibald_Murray_(fencer)', 'Archibald_Sharp', 'Archie_Taylor_(sport_shooter)', 'Aristide_Pontanani', 'Armand_Viguier', 'Armas_Laitinen', 'Arne_Højme', 'Arthur_Burn', 'Arthur_Gould_(wrestler)', 'Arthur_Havemeyer', 'Arthur_Lord', 'Arthur_Maranda', 'Arthur_Seward', 'Arthur_Smith_(sport_shooter)', 'Arthur_Sundbye', 'Arthur_Wallis_(wrestler)', 'Artúr_Baján', 'Arvid_Beckman', 'Arvo_Laine', 'Arvīds_Ozols-Bernē', 'Asmund_Enger', 'Aubrey_Coleman_(wrestler)', 'August_Ehrich', 'August_Jokinen', 'August_Meesen', 'August_Placke', 'Axel_Frank', 'Axel_Haglund', 'Axel_Kristensen', 'Axel_Larsson_(Danish_wrestler)', 'Axel_Wiegandt', 'Aäron_Lelie', 'Ben_Chimberoff', 'Benjamin_Sherman_(athlete)', 'Bernard_Berg_(gymnast)', 'Billy_Grantham', 'Bob_Reynolds_(gymnast)', 'Boris_Arsenyev', 'Boris_Belinsky', 'Boris_Nepokupnoy', 'Boris_Pertel', 'Bruno_Heckel', 'Bruto_Buozzi', 'Burt_Sansom', 'Béla_Darányi', 'Carl-Johan_Sund', 'Carl_Ebert_(field_hockey)', 'Carl_Hansen_(wrestler)', 'Carl_Körting', 'Carl_Saunte', 'Carl_Wiegand', 'Carlo_Bonfanti', 'Carlo_Marchiandi', 'Casimir_Semelaignes', 'Cecil_McKaig', 'Charles_Avrillon', 'Charles_Bersin', 'Charles_Broadbeck', 'Charles_Churcher', 'Charles_Cléry', 'Charles_Cresson', 'Charles_Dellert', 'Charles_Eng', 'Charles_Garnier_(rower)', 'Charles_Hall_(athlete)', 'Charles_Jeffers', 'Charles_Lagarde', 'Charles_Loizillon', 'Charles_Marty', 'Charles_Morard', 'Charles_Schwartz_(gymnast)', 'Charles_Smith_(gymnast)', 'Charles_Sorum', 'Charles_Stevens_(wrestler)', 'Charles_Umbs', 'Charles_Vestergaard', 'Charles_de_Béthune-Sully', 'Charlie_Clark_(cyclist)', 'Christian_Carlsen', 'Christian_Deubler', 'Christian_Sperl', 'Christian_Tauson', 'Clarence_Lidington', 'Coen_van_Veenhuijsen', 'Colin_Lewis_(swimmer)', 'Constant_Dulau', 'Cyril_Brown_(wrestler)', 'Daniel_Flynn_(cyclist)', 'Daniel_Lavielle', 'Daniel_McMahon_(sport_shooter)', 'David_Karlsson_(wrestler)', 'David_McGowan_(archer)', 'David_Noon_(cyclist)', 'David_Robertson_(cyclist)', 'Davide_Baiardo', 'Decio_Pavani', 'Defkalion_Rediadis', 'Dezső_Orosz', 'Dimitrios_Muller', 'Dimitrios_Triantafyllakos', 'Dino_Diana', 'Dmitry_Kuskov', 'Dmitry_Nazarov_(athlete)', 'Donnell_Young', 'Douglas_Godfree', 'Douwe_Wijbrands', 'Désiré_Hudelo', 'Dāvids_Veiss', 'Eddie_Fitzgerald_(athlete)', 'Edgar_Dyson', 'Edmund_Aspinall', 'Edmund_Pueschel', 'Edoardo_Alaimo', 'Edvard_Jansson', 'Edvin_Lönnberg', 'Edward_Clough', 'Edward_Cooke_(swimmer)', 'Edward_Cotter_(athlete)', 'Edward_Gould_(golfer)', 'Edward_Greene_(sport_shooter)', 'Edward_Leader', 'Edward_Newitt', 'Edward_Tickell', 'Edward_Tritschler', 'Efraim_Harju', 'Einar_Hermann', 'Einar_Møbius', 'Elard_Dauelsberg', 'Elis_Holmer', 'Elías_Yáñez', 'Emil_Backenius', 'Emil_Bömches', 'Emil_Fabritius', 'Emil_Gustafsson', 'Emil_Jand', 'Emil_Nylund', 'Emil_Rothe', 'Emil_Rotong', 'Emile_Jurgens', 'Emmanuel_Andrieu', 'Emmanuel_Boislèvé', 'Enrique_Deichler', 'Erich_Schultze', 'Erich_Seidel_(swimmer)', 'Erik_Odelberg', 'Erik_Öberg', 'Ernest_Blount', 'Ernest_Gignoux', 'Ernest_Larner', 'Ernie_Fearman', 'Ernst_Frigast', 'Ernst_Johansson', 'Ernst_Kovács', 'Ervin_Barker', 'Erwin_Kurtz', 'Erwin_von_Sigel', 'Eskil_Wedholm', 'Ettore_Massari', 'Eugen_Fürstenberger', 'Eugène_Lesieur', 'Eugène_Plisson', 'Ewald_Persson', 'Fabio_Maioni', 'Federico_Mueller', 'Felix_Kwieton', 'Fernand_Boulmant', 'Fernand_Castille', 'Fernand_Semelaignes', 'Fernand_Steens', 'Fernando_Cavallini_(fencer)', 'Flaminio_Bottoni', 'Francesco_Pietrasanta', 'Francis_Sabourin', 'Frank_Collings', 'Frank_Denby', 'Frank_Ihrcke', 'Frank_McGurk_(boxer)', 'Frank_Montaldi', 'Frank_Morris_(sport_shooter)', 'Frank_Shore', 'František_Souček', 'Franz_Diederichsen', 'Franz_Schuh_(swimmer)', 'François_Bonnet_(cyclist)', 'François_Brun-Buisson', 'François_Celis', 'François_Delibes', 'François_Elichagaray', 'François_Nidal', 'François_de_Boffa', 'Fred_Davis_(wrestler)', 'Fred_Grinham', 'Fred_Hussman', 'Fred_Koenig_(wrestler)', 'Fred_Narganes', 'Fred_Sanderson_(tennis)', 'Fred_Utton', 'Frederick_Ferguson_(wrestler)', 'Frederick_Knight_(wrestler)', 'Frederick_Osborne_(boxer)', 'Frederick_Tomkins', 'Frederik_Hansen_(wrestler)', 'Friedrich_Scharrer', 'Friedrich_Uhl', 'Friedrich_von_Grote', 'Friedrich_von_Oesterley', 'Frigyes_Gráf', 'Fritz_Bøchen_Vikke', 'Fritz_Danild', 'Fritz_Danner', 'Fritz_Fleischer', 'Fritz_Krombholz', 'Fritz_Lange_(wrestler)', 'Fritz_Larsson', 'Fritz_Möding', 'Fritz_Reiser', 'Fritz_Sauer', 'Fritz_Scheider', 'Fritz_Weinzinger', 'Fyodor_Zabelin', 'Félicien_Lekim', 'Félix_Alegría', 'Félix_Ghysels', 'Gabriel_St._Laurent', 'Garnett_Wikoff', 'Gaston_Aspa', 'Gaston_Bullier', 'Gaston_Dreyfus', 'Gaston_Dutertre', 'Gaston_Koëger', 'Gaston_Renard', 'Gaston_Van_Laere', 'Gaston_de_Trannoy', 'Gastone_Calabresi', 'Gayle_Dull', 'Geoffrey_Burton_(athlete)', 'Georg_Andersen_(wrestler)', 'Georg_Erdmann', 'Georg_Hax', 'Georg_Karth', 'Georg_Kröder', 'Georg_Lind', 'Georg_Peterson', 'George_Anderson_(cyclist)', 'George_Aschenbrenner', 'George_Bailey_(gymnast)', 'George_Barber_(jumper)', 'George_Buff', 'George_Cameron_(cyclist)', 'George_Faulkner_(wrestler)', 'George_Godfrey_(swimmer)', 'George_Innocent', 'George_Jessup', 'George_Mastrovich', 'George_Meade_(gymnast)', 'George_Patching', 'George_Pinchard', 'George_Powell_(golfer)', 'George_Retzer', 'George_Rowe_(sport_shooter)', 'George_Saunders_(British_wrestler)', 'George_Schroeder', 'George_Stapf', 'George_Summers_(cyclist)', 'George_Webster_(swimmer)', 'Georges-Louis_Bézy', 'Georges_Augoyat', 'Georges_Coindre', 'Georges_Daussy', 'Georges_Donnet', 'Georges_Dubois_(hurdler)', 'Georges_Lefèvre', 'Georges_Leroy', 'Georges_Perrin', 'Georges_Pinault', 'Georges_Redeuil', 'Georges_de_Zogheb', 'Georgios_Drosos', 'Georgios_Louridas', 'Georgius_Damen', 'Georgy_Zakyrich', 'Georgy_de_Davydov', 'Gerald_Bradshaw', 'Gerard_van_den_Bergh', 'Gerhard_Topp', 'Gerrit_Duijm', 'Giacomo_Stratta', 'Giannetto_Termanini', 'Gino_Ciabatti', 'Gioacchino_Vaccari', 'Giulio_Cagiati', 'Giunio_Fedreghini', 'Grigory_Dyomin', 'Guido_Cristofori', 'Gunnar_Bolander', 'Gunnar_Nilsson_(athlete)', 'Gunnar_Wingqvist', 'Gustaaf_van_Hulstijn', 'Gustaf_Ljunggren_(athlete)', 'Gustaf_Lyman', 'Gustaf_Pelander', 'Gustaf_Stiernspetz', 'Gustaf_Westerberg', 'Gustav_Aurisch', 'Gustav_Betzén', 'Gustav_Collin', 'Gustav_Hämmerlin', 'Gustav_Mueller_(gymnast)', 'Gustave_Charmoille', 'Gustave_Fahy', 'Gustave_Masselin', 'Gustavo_Taddia', 'Guy_Reyntiens', 'Guy_Schwan', 'Gyula_Iványi', 'Géza_Kövesdi', 'Hans_Bredmose', 'Hans_Tronner', 'Harald_Agger', 'Harald_Ekwall', 'Haralds_Hāns', 'Harold_Bartlett', 'Harold_Goodworth', 'Harold_Heiland', 'Harold_Simpkins', 'Harry_Baillie', 'Harry_Beasley_(athlete)', 'Harry_Challstorp', 'Harry_Hansen_(gymnast)', 'Harry_Larsson', 'Harry_Prinzler', 'Harry_Sprenger', 'Harry_Warnken', 'Haswell_Wilson', 'Heinrich_Rauß', 'Heinrich_Siebenhaar', 'Hendrik_Johansen', 'Hendrik_Rasmussen', 'Henri_Baumler', 'Henri_Coquelin', 'Henri_Cunault', 'Henri_Davids', 'Henri_Delamaide', 'Henri_Fréteur', 'Henri_Gutierrez', 'Henri_Jean_Début', 'Henri_Leclerc_(equestrian)', 'Henri_Nielsen', 'Henri_Pantin', 'Henri_Plommet', 'Henri_Sauveur', 'Henri_Yvon', 'Henri_le_Marié', 'Henry_Barker_(athlete)', 'Henry_Field_(athlete)', 'Henry_Foskett', 'Henry_Hiatt', 'Henry_Koeder', 'Henry_Kraft', 'Henry_Munday', 'Henry_Weyland', 'Henry_Witherall', 'Henry_Wittmann', 'Herbert_Gidney', 'Herbert_Putnam_(athlete)', 'Herbert_Wetter', 'Herberts_Baumanis', 'Herbrand_Lofthus', 'Herman_Nyberg_(sport_shooter)', 'Herman_de_By', 'Hermann_Buchfelder', 'Hippolyte-Jacques_Hyvernaud', 'Hjalmar_Saxtorph', 'Holger_Baden', 'Horace_Chenery', 'Hugh_Maguire_(athlete)', 'Hugo_Cužna', 'Hugo_Johansson_(wrestler)', 'Hugo_Peitsch', 'Hugo_Svensson', 'Hugó_Hoch', 'Hvitfeldt_Hansen', 'Imre_Wampetich', 'Ingvardt_Hansen', 'Ioannis_Loungitsas', 'Ioannis_Santorinaios', 'Iraklis_Sakellaropoulos', 'Isaac_Myrans', 'István_Jeney', 'Ivan_Ivanovitch_(fencer)', 'J._Nelson_Le_Fevre', 'Jack_Taylor_(British_swimmer)', 'Jack_Warner_(sport_shooter)', 'Jacob_Hergenhahn', 'Jacob_Laan', 'Jacob_van_Westrop', 'Jacobus_Lorenz', 'Jacques_Droëtti', 'Jacques_Holzschuch', 'Jacques_Léauté', 'Jacques_Nivière', 'Jacques_Pinchart', 'Jacques_de_la_Chevalerie', 
                     'Jalo_Autonen', 'James_Bollinger', 'James_Cotterell', 'James_Cowan_(sport_shooter)', 'James_Dwyer_(gymnast)', 'James_Freeborn', 'James_Graham_(gymnast)', 'James_Greene_(swimmer)', 'James_Kenyon_(sport_shooter)', 'James_Milne_(sport_shooter)', 'James_Mitchell_Baker', 
                     'James_Murphy_(athlete)', 'James_O\'Connell_(athlete)', 'James_Reid_(athlete)', 'James_Reilly_(swimmer)', 'James_Steele_(sports_shooter)', 'James_Webster_(wrestler)', 'Jan_Sint', 'Jay_Nash_McCrea', 'Jean-André_Hilleret', 'Jean-Marie_Borringes', 'Jean_Bouffechoux', 'Jean_Boulège', 'Jean_Depassio', 'Jean_Hauptmanns', 'Jean_Jeanvoix', 'Jean_Lafoucrière', 'Jean_Madelaine', 'Jean_Michel_(fencer)', 'Jean_Mikorski', 'Jean_Rodier', 'Jean_Taillefer', 'Jean_Van_Benthem', 'Jean_Weill', 'Jenő_Apáthy', 'Jenő_Várady', 'Jindřich_Jirsák', 'Johan_Andersson_(wrestler)', 'Johan_Ekman', 'Johan_Lindqvist', 'Johan_Praem', 'Johan_van_Schreven', 'Johann_Martin', 'Johann_Trestler', 'Johannes_Eillebrecht', 'Johannes_Kolling', 'Johannes_Ussing', 'Johannes_van_Spengen', 'John_Barnard_(cyclist)', 'John_Brandt', 'John_Butler_(athlete)', 'John_Cardwell_(wrestler)', 'John_Cox_(wrestler)', 'John_Densham', 'John_Goodwin_(sport_shooter)', 'John_Hession', 'John_Hoy', 'John_Krug', 'John_Laichinger', 'John_Lloyd_(boxer)', 'John_McKenzie_(wrestler)', 'John_Murray_(athlete)', 'John_Sellars_(sport_shooter)', 'John_Somers_(sport_shooter)', 'John_Watters_(gymnast)', 'John_Wolf_(gymnast)', 'John_Wussow', 'Josef_Bechyně', 'Josef_Stejskal_(wrestler)', 'Josefa_Kellner', 'Joseph,_Marquis_de_Saint_Brisson', 'Joseph-Auguste_Métais', 'Joseph-Marie_Rosé', 'Joseph_Campot', 'Joseph_Charles_(tennis)', 'Joseph_Cook_(gymnast)', 'Joseph_Dilg', 'Joseph_English_(athlete)', 'Joseph_Fontaine_(fencer)', 'Joseph_Geens', 'Joseph_Guyader', 'Joseph_Kinchin', 'Joseph_Lavielle', 'Joseph_Mallet', 'Joseph_Marais', 'Joseph_Merkle', 'Joseph_Rodrigues', 'Joseph_Sénat', 'Joseph_White_(wrestler)', 'Josiah_Bowden', 'José_Torres_(cyclist)', 'Jules_Ducret', 'Jules_Fehr', 'Jules_Ringnet', 'Jules_Roffe', 'Jules_Rossignol', 'Jules_Wuyts', 'Jules_de_Pradel', 'Julien_Boullery', 'Julius_Jørgensen', 'Julius_Nuninger', 'Julius_Schaefer', 'János_Antal', 'János_Nyisztor', 'József_Fabinyi', 'József_Haluzsinsky', 'József_Maróthy', 'József_Téger', 'Jānis_Polis_(wrestler)', 'Kai_Jølver', 'Karl_Barl', 'Karl_Borchert', 'Karl_Hack', 'Karl_Julius_Jensen', 'Karl_Kangas', 'Karl_Lind', 'Karl_Åberg', 'Knud_Gøtke', 'Knut_Lindberg_(wrestler)', 'Kolbjørn_Kvam', 'Konrad_Stein', 'Konstantin_Kalinin_(sport_shooter)', 'Konstantin_Vaterkampf', 'Kálmán_Szabó_(gymnast)', 'Kálmán_Szathmáry', 'Károly_Rémi', 'Ladislav_Jiránek-Strana', 'Lajos_Haraszthy', 'Lajos_Horváth', 'Lajos_Ludinszky', 'Lancelot_Stafford', 'Langford_Lloyd', 'Laurent_Gerstmans', 'Laurent_de_Champeaux', 'Lauri_Haapanen', 'Laurids_Kjær', 'Lauritz_Christiansen_(athlete)', 'Leander_Keim', 'Lee_Jones_(golfer)', 'Leendert_van_Oosten', 'Len_Richardson_(athlete)', 'Lennart_Lind_(wrestler)', 'Leo_Hunger', 'Leo_Larson', 'Leon_Hazelton', 'Leonid_Grinev', 'Leopoldo_Palma', 'Leopolds_Lēvenšteins', 'Lev_Martyushev', 'Lewis_Moist', 'Lionel_Cornish', 'Lou_Scholes', 'Louis_Constant', 'Louis_Coudurier', 'Louis_Garnoty', 'Louis_Gauthier_(fencer)', 'Louis_Haller', 'Louis_Kniep', 'Louis_Lafite', 'Louis_Midelair', 'Louis_Rathke', 'Louis_Roche', 'Louis_Thomaturgé', 'Louis_Weintz', 'Louis_d\'Havrincourt', 'Louis_du_Douet_de_Graville', 'Lucien_Hansen', 'Lucien_Largé', 'Lucien_Millet', 'Lucien_Renard', 'Ludovic_Laborderie', 'Luigi_Colombo_(cyclist)', 'Luigi_Pinelli', 'Luis_Antonio_de_Guadalmina', 'Luis_Maria_Heyden', 'László_Hauler', 'Léon_Coeckelberg', 'Léon_Gingembre', 'Léon_Hecht', 'Léon_Maisonnave', 'Léon_Tétart', 'Léopold_Ramus', 'Magnus_Nilsson_(athlete)', 'Marc_Texier', 'Marcel_Boulanger_(fencer)', 'Marcel_Dubois_(wrestler)', 'Marcel_Lévy', 'Marcel_Montuel', 'Mariano_Ciai', 'Marie-Joseph_Gabriel', 'Marie-Louis_Damotte', 'Marius_Delaby', 'Martin_Ludwig_(gymnast)', 'Mary_Langford', 'Matthias_Triantafyllidis', 'Maurice_Barry_(gymnast)', 'Maurice_Fleury', 'Maurice_Jay_(fencer)', 'Maurice_Jéhin', 'Maurice_Monniot', 'Maurice_Robion_du_Pont', 'Maurice_Terrier', 'Max_Dwinger_(fencer_born_1870)', 'Max_Rodrigues_(fencer)', 'Max_Thomas_(gymnast)', 'Maxime_Piaggio', 'Mellor_Clay', 'Michael_Collins_(athlete)', 'Michael_Dineen', 'Michael_Lang_(gymnast)', 'Michel_Bettenfeld', 'Michel_Filippi', 'Michel_Meerz', 'Mihály_Antos', 'Mikhail_Nikolsky', 'Mikhail_Yekimov', 'Mikko_Holm', 'Miklós_Orosz', 'Miklós_Todoresku', 'Murray_Carleton', 'Márton_Endrédy', 'Nicolai_Philipsen', 'Niels_Laursen', 'Niels_Pedersen_(athlete)', 'Nikolajs_Fārnasts', 'Nikolaos_Kouloumberdas', 'Nikolay_Goredetsky', 'Nikolay_Kharkov', 'Nikolay_Kuznetsov_(fencer)', 'Nikolay_Neklepayev', 'Nikolay_Voronkov', 'Nils_Klein', 'Oliver_Olsen_(gymnast)', 'Olivier_Collarini', 'Oluf_Landnes', 'Orazio_Santelli', 'Oreste_Arpè', 'Oreste_Muzzi', 'Orvil_Elliott', 'Oscar_Lemming', 'Oskar_Forsman', 'Oskar_Näumann', 'Oskar_Wiklund', 'Ossian_Jörgensen', 'Osvald_Reshke', 'Otto_Bauscher', 'Otto_Boehnke', 'Otto_Feyder', 'Otto_Götze', 'Otto_Knerr', 'Otto_Nagel_(wrestler)', 'Otto_Niemand', 'Otto_Roesner', 'Otto_Thomsen', 'Otto_Wiegand_(gymnast)', 'Pablo_Eitel', 'Patrick_Fee', 'Paul_Beulque', 'Paul_Carrichon', 'Paul_Convert', 'Paul_Fournelle', 'Paul_Gebauer', 'Paul_Legrain', 'Paul_Leroy_(fencer)', 'Paul_Rosso', 'Paul_Stendel', 'Paul_de_Saint-Léger', 'Pavel_Avksentyev', 'Pavel_Guvorsky', 'Pavel_Kushnikov', 'Pavel_Lesh', 'Pavel_Lieth', 'Pavel_Pavlovich', 'Pavel_de_Shtiglits', 'Per_Olaf_Olsen', 'Percy_Cockings', 'Percy_Whitehead', 'Peter_Jones_(sport_shooter)', 'Peter_Nielsen_(sport_shooter)', 'Peter_Oehler', 'Petros_Pipiles', 'Philip_Plater', 'Philipp_Ehrenreich', 'Phillip_Sontag', 'Pierre_Alvarez', 'Pierre_Hostein', 'Pierre_Mazior', 'Pierre_Perrier_(sport_shooter)', 'Pierre_Peyrusson', 'Pierre_Rosenbaum', 'Pierre_Saintongey', 'Pierre_Samiac', 'Pierre_Seginaud', 'Pierre_Selderslagh', 'Pierre_Strauwen', 'Pieter_van_Waas', 'Pietro_Sarzano', 'Poul_Holm_(sportsman)', 'Poul_Liebst', 'Pyotr_Gayevsky', 'Pál_Pajzs', 'Pál_Rosty', 'Ragnvald_Berg', 'Ragnvald_Gullaksen', 'Ralph_Harrison_(athlete)', 'Raoul_Bideau', 'Raphaël_Diaz', 'Raphaël_Perrissoud', 'Rasmus_Friis', 'Raulino_Galvao', 'Raymond_Cabal', 'Raymond_Havemeyer', 'Regina_Kari', 'Reinhard_Wagner', 'René_André', 'René_Doudelle', 'René_Raynaud', 'René_de_Quincey', 'Reuben_Povey', 'Rezsõ_Újlaki', 'Richard_Genserowski', 'Richard_Gregory_(rower)', 'Richard_Manuel_(water_polo)', 'Richard_Mayer_(rower)', 'Richard_Piggott_(athlete)', 'Richard_Rösler', 'Richard_Sanford_(runner)', 'Richard_Tritschler', 'Richard_Villepontoux', 'Risdon_Couch', 'Robert_Badman', 'Robert_Bonney_(gymnast)', 'Robert_Brown_(sport_shooter)', 'Robert_Hanley_(gymnast)', 'Robert_Hassell_(swimmer)', 'Robert_Hawkins_(sport_shooter)', 'Robert_Herrmann_(gymnast)', 'Robert_Hutcheson', 'Robert_Jolly', 'Robert_Jonsson', 'Robert_Löfman', 'Robert_Marc_(fencer)', 'Robert_Pascarel', 'Robert_Patterson_(sport_shooter)', 'Robert_Phelps_(wrestler)', 'Robert_Thach', 'Roberto_Nardini', 'Roland_Spitzer', 'Rudolf_Buchfelder', 'Rudolf_Keyper', 'Rudolf_Krupitzer', 'Rudolf_Rauch', 'Sam_Blatherwick', 'Samuel_Filler', 'Samuel_LaVoice', 'Samuel_Stevenson', 'Sander_Santesson', 'Semyon_Kulikov', 'Sherman_Hall_(fencer)', 'Sidney_Domville', 'Sidney_Parvin', 'Sidney_Peake', 'Sidney_Willis', 'Sigmund_Muenz', 'Silva_Smedberg', 'Spyridon_Mostras', 'Stan_François', 'Stanley_Jones_(cyclist)', 'Steen_Rasmussen_(athlete)', 'Stefanos_Kountouriotis', 'Sydney_Brown_(sport_shooter)', 'Sylvain_Lézard', 'Sándor_Kleckner', 'Sándor_Török', 'Ted_Savage_(athlete)', 'Ted_Studier', 'Teofil_Savniky', 'Theo_Koppen', 'Theodor_Zeilau', 'Theodore_Gross', 'Thomas_Caldwell_(sport_shooter)', 'Thomas_Dick_(gymnast)', 'Thomas_Downing_(athlete)', 'Thomas_Elmitt', 'Thomas_LeBoutillier', 'Thomas_Lilley', 'Théophile_Fras', 'Tuomas_Pukkila', 'Ugo_Di_Nola', 'Ugo_Savonuzzi', 'Valdemar_Christoffer_Nielsen', 'Vasily_Molokanov', 'Verner_Hetmar', 'Victor_Dubois', 'Victor_Polidori', 'Victor_Robert_(sport_shooter)', 'Viggo_Petersen', 'Viktor_Baranov_(diver)', 'Viktor_Franzl', 'Vilhelm_Laybourn', 'Vilhelm_Lehmusvirta', 'Vilhelm_Lindgrén', 'Viljam_Johansson', 'Viljo_Lietola', 'Villiam_Nieminen', 'Vincent_Dargein', 'Vincenzo_Blo', 'Vladimir_Andreyev_(fencer)', 'Vladimir_Danich', 'Vladimir_Kayser', 'Vladimir_Potekin', 'Vladimir_Samoylov', 'Vladimir_Sarnavsky', 'Vladislav_Chalupa', 'Väinö_Heikkilä', 'Wallace_McCurdy', 'Walter_Bodneck', 'Walter_Bowler', 'Walter_Real', 'Walter_Schachlitz', 'Wilfred_Bleaden', 'Wilfred_Edwards_(swimmer)', 'Wilfred_Holroyd', 'Wilhelm_Kaufmann', 'Wilhelm_Lemke_(gymnast)', 'Wilhelm_Zabel', 'Wilhelmus_Braams', 'Will_Davis_(cyclist)', 'Willard_Schrader', 'Willem_Molijn', 'Willi_Steputat', 'William_Andelfinger', 'William_Berewald', 'William_Bowman_(fencer)', 'William_Clarke_(athlete)', 'William_Cox_(wrestler)', 'William_Davies_(sport_shooter)', 'William_Dove', 'William_Fergus', 'William_Friedrich', 'William_Hennessy_(wrestler)', 'William_Henson_(wrestler)', 'William_Herzog', 'William_Hill_(sport_shooter)', 'William_Hoare_(gymnast)', 'William_Horschke', 'William_Jones_(British_wrestler)', 'William_Kramer_(athlete)', 'William_Kruppinger', 'William_Lower_(cyclist)', 'William_Lupton', 'William_McClure', 'William_Ruff', 'William_Schaefer_(wrestler)', 'William_Shepherd_(wrestler)', 'William_Smith_(golfer)', 'William_Stewart_(athlete)', 'William_Tagg', 'William_Traband', 'William_Tritschler', 'William_Valentine_(archer)', 'William_Watt_(athlete)', 'William_Watters', 'William_West_(wrestler)', 'Willie_Magee_(cyclist)', 'Winslow_McCleary', 'Yevgeny_Petrov_(athlete)', 'Yevgeny_Zamotin', 'Yrjö_Vuolio', 'Zeno_von_Singalewicz', 'Zoltán_Jelenffy', 'Édmond_Dharancy', 'Édouard_Fouchier', 'Édouard_Geynet', 'Édouard_Martin_(wrestler)', 'Édouard_Poty', 'Élie_Dufraisse', 'Émile_Bouard', 'Émile_Dubois_(cyclist)', 'Émile_Lafourcade-Cortina', 'Émile_Maréchal', 'Émile_Vadbled', 'Étienne_Lesbats', 'Ödön_Toldi')
AND page_namespace = 0
AND year.cl_to LIKE "%Summer_Olympics"
AND country.cl_to LIKE "Olympic_%_of_%"
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.
SQL

Checking query status...
