diff --git a/.gitmodules b/.gitmodules index 267844b..1868125 100644 --- a/.gitmodules +++ b/.gitmodules @@ -1,15 +1,18 @@ [submodule "includes/boz-mw"] path = includes/boz-mw url = https://github.com/valerio-bozzolan/boz-mw.git [submodule "2018-06-wikidata-volleyball-players/includes/boz-mw"] path = 2018-06-wikidata-volleyball-players/includes/boz-mw url = https://github.com/valerio-bozzolan/boz-mw [submodule "2018-06-wikidata-soccer-serie-a/includes/boz-mw"] path = 2018-06-wikidata-soccer-serie-a/includes/boz-mw url = https://github.com/valerio-bozzolan/boz-mw.git [submodule "2018-02-italian-parks/includes/boz-mw"] path = 2018-02-italian-parks/includes/boz-mw url = https://github.com/valerio-bozzolan/boz-mw.git [submodule "2018-07-wikipedia-citation-language-migration/includes/boz-mw"] path = 2018-07-wikipedia-citation-language-migration/includes/boz-mw url = https://github.com/valerio-bozzolan/boz-mw +[submodule "2017-11-wikidata-volleyball-players/includes/boz-mw"] + path = 2017-11-wikidata-volleyball-players/includes/boz-mw + url = https://github.com/valerio-bozzolan/boz-mw diff --git a/2017-11-wikidata-volleyball-players/commons-volleyball-players-2018.csv b/2017-11-wikidata-volleyball-players/commons-volleyball-players-2018.csv new file mode 100644 index 0000000..4552c76 --- /dev/null +++ b/2017-11-wikidata-volleyball-players/commons-volleyball-players-2018.csv @@ -0,0 +1,678 @@ +Name,Surname,Nome file,Wikidata ID +Simone,Abbio,Simone Abbio (Legavolley 2017),Q55170509 +Andri,Aganits,Andri Aganits (Legavolley 2014),Q15628536 +Andrea,Agnellini,Andrea Agnellini (Legavolley 2016),Q55170511 +Marinfranco,Agrusti,Marinfranco Agrusti (Legavolley 2011),Q55170514 +Antwain Delawarence,Aguillard,Antwain Delawarence Aguillard (Legavolley 2014),Q55170531 +Graydon,Ainsworth,Graydon Ainsworth (Legavolley 2011),Q55170532 +Yasim Youssif,Al Nabhan,Yasim Youssif Al Nabhan (Legavolley 2011),Q55261873 +Paolo,Alborghetti,Paolo Alborghetti (Legavolley 2016),Q3893691 +Todor,Aleksiev,Todor Aleksiev (Legavolley 2011),Q642527 +Denis,Alikaj,Denis Alikaj (Legavolley 2014),Q55261870 +Piero,Allesch,Piero Allesch (Legavolley 2014),Q55261872 +Carlos,Alomia Angulo,Carlos Alomia Angulo (Legavolley 2011),Q55261874 +Thiago,Alves Soares,Thiago Alves Soares (Legavolley 2016),Q55261876 +Ryan,Ammerman,Ryan Ammerman (Legavolley 2011),Q55261877 +Antonio,Ancora,Antonio Ancora (Legavolley 2014),Q55261878 +Matthew,Anderson,Matthew Anderson (Legavolley 2011),Q692345 +Svetoslav,Angelov,Svetoslav Angelov (Legavolley 2012),Q55264287 +Cristian,Anselmi,Cristian Anselmi (Legavolley 2015),Q55264293 +Andrea,Antonaci,Andrea Antonaci (Legavolley 2012),Q32666008 +Gianpio,Aprea,Gianpio Aprea (Legavolley 2013),Q55264339 +Martins,Arasomwan,Martins Arasomwan (Legavolley 2017),Q55264475 +Apostolos,Armenakis,Apostolos Armenakis (Legavolley 2014),Q2859084 +Gabriele,Attanasio,Gabriele Attanasio (Legavolley 2016),Q55264710 +Francesco,Avelli,Francesco Avelli (Legavolley 2017),Q55264719 +Daniel,Bacca,Daniel Bacca (Legavolley 2015),Q55264738 +Joel,Bacci,Joel Bacci (Legavolley 2011),Q55264744 +Mohamed,Badawy,Mohamed Badawy (Legavolley 2012),Q21284582 +Eugen,Bakumovski,Eugen Bakumovski (Legavolley 2011),Q96437 +Paolo Emilio,Baldaccini,Paolo Emilio Baldaccini (Legavolley 2011),Q55264800 +Felipe Airton,Banderò,Felipe Airton Banderò (Legavolley 2016),Q55264847 +Alejandro,Barajas,Alejandro Barajas (Legavolley 2017),Q55264856 +Kamil,Baranek,Kamil Baranek (Legavolley 2015),Q3192430 +Giorgio,Barbareschi,Giorgio Barbareschi (Legavolley 2012),Q55264874 +Giuseppe,Barbone,Giuseppe Barbone (Legavolley 2016),Q55264879 +Arpad,Baroti,Arpad Baroti (Legavolley 2014),Q16623974 +Carlos Eduardo,Barreto Silva,Carlos Eduardo Barreto Silva (Legavolley 2016),Q29080075 +Marco,Barsi,Marco Barsi (Legavolley 2013),Q55264882 +Zbigniew,Bartman,Zbigniew Bartman (Legavolley 2013),Q167988 +Andrea,Bartoletti,Andrea Bartoletti (Legavolley 2011),Q592811 +Alessandro,Bartoli,Alessandro Bartoli (Legavolley 2011),Q55264852 +Daniele,Bassi,Daniele Bassi (Legavolley 2012),Q55264885 +Luca,Battistelli,Luca Battistelli (Legavolley 2016),Q55264901 +Lorenzo,Battocchio,Lorenzo Battocchio (Legavolley 2016),Q55264895 +Luca,Beccaro,Luca Beccaro (Legavolley 2016),Q19395384 +Filippo,Belcecchi,Filippo Belcecchi (Legavolley 2012),Q55264904 +Simone,Bendandi,Simone Bendandi (Legavolley 2011),Q9337069 +Andrea,Bergoli,Andrea Bergoli (Legavolley 2015),Q55264907 +Willian Alejandro,Bermudez,Willian Alejandro Bermudez (Legavolley 2014),Q55264923 +Dario,Berni,Dario Berni (Legavolley 2013),Q55264908 +Paulo Renan,Bertassoni,Paulo Renan Bertassoni (Legavolley 2016),Q55264918 +Giovanni,Bertelle,Giovanni Bertelle (Legavolley 2016),Q55264910 +Alessandro,Bevilacqua,Alessandro Bevilacqua (Legavolley 2016),Q55264928 +Juri,Bianchi,Juri Bianchi (Legavolley 2012),Q55264935 +Jeronimo,Bidegain,Jeronimo Bidegain (Legavolley 2011),Q6185635 +Alberto,Bigarelli,Alberto Bigarelli (Legavolley 2011),Q55264938 +Francesco,Biribanti,Francesco Biribanti (Legavolley 2012),Q3080915 +Matteo,Bisanti,Matteo Bisanti (Legavolley 2016),Q55264943 +Novica,Bjelica,Novica Bjelica (Legavolley 2011),Q194594 +Aleksandar,Blagojevic,Aleksandar Blagojevic (Legavolley 2014),Q16782494 +Alessandro,Blasi,Alessandro Blasi (Legavolley 2016),Q16874857 +Rudinei,Boff,Rudinei Boff (Legavolley 2013),Q55264958 +Marcus,Bohme,Marcus Bohme (Legavolley 2012),Q70652 +Emanuele,Bondini,Emanuele Bondini (Legavolley 2016),Q55264960 +Lorenzo,Bonetti,Lorenzo Bonetti (Legavolley 2016),Q18811801 +Dante,Boninfante,Dante Boninfante (Legavolley 2017),Q1164973 +Sergio,Boroni,Sergio Boroni (Legavolley 2011),Q55264968 +Ivan,Borovnjak,Ivan Borovnjak (Legavolley 2015),Q18225315 +Massimo,Botti,Massimo Botti (Legavolley 2011),Q3851153 +Federico,Braico,Federico Braico (Legavolley 2013),Q55264973 +Georgi,Bratoev,Georgi Bratoev (Legavolley 2015),Q1150488 +Valentin,Bratoev,Valentin Bratoev (Legavolley 2011),Q2516800 +Steve,Brinkman,Steve Brinkman (Legavolley 2011),Q2016044 +Theodore,Brunner,Theodore Brunner (Legavolley 2011),Q18148694 +Marcello ,Bruno,Marcello Bruno (Legavolley 2011),Q55264980 +Martin Nicolas,Bruno,Martin Nicolas Bruno (Legavolley 2013),Q55265003 +Luca,Bucaioni,Luca Bucaioni (Legavolley 2016),Q11763220 +Bartosz,Bucko,Bartosz Bucko (Legavolley 2015),Q23767061 +Andrea,Bulfon,Andrea Bulfon (Legavolley 2016),Q16855108 +Matteo,Burgsthaler,Matteo Burgsthaler (Legavolley 2016),Q3852088 +Ugo,Buzzelli,Ugo Buzzelli (Legavolley 2016),Q55265028 +Matteo,Cacchiarelli,Matteo Cacchiarelli (Legavolley 2011),Q55265037 +Tommaso,Cacchiarelli,Tommaso Cacchiarelli (Legavolley 2012),Q55265046 +Luca,Cacciatore,Luca Cacciatore (Legavolley 2014),Q55265032 +José Miguel,Caceres,José Miguel Caceres (Legavolley 2012),Q3186478 +Sandro Clemente,Caci,Sandro Clemente Caci (Legavolley 2013),Q55265042 +Matteo,Caciorgna,Matteo Caciorgna (Legavolley 2013),Q55265039 +Luca,Calderan,Luca Calderan (Legavolley 2011),Q55265376 +Tomasz,Calligaro,Tomasz Calligaro (Legavolley 2013),Q55265377 +Maurizio,Cannistrà,Maurizio Cannistrà (Legavolley 2016),Q55265382 +Mario,Canzanella,Mario Canzanella (Legavolley 2011),Q16576281 +Emanuele,Caporaletti,Emanuele Caporaletti (Legavolley 2012),Q55265403 +Michele,Capra,Michele Capra (Legavolley 2012),Q3856541 +Alberto,Caprotti,Alberto Caprotti (Legavolley 2011),Q17154604 +Antonio,Caputo,Antonio Caputo (Legavolley 2011),Q55265402 +Maikel Cristobal,Cardona,Maikel Cristobal Cardona (Legavolley 2011),Q3278154 +Aurelio,Cardoso De Figueiredo,Aurelio Cardoso De Figueiredo (Legavolley 2011),Q55265503 +Bertrand,Carletti,Bertrand Carletti (Legavolley 2011),Q2899478 +Matteo,Casarin,Matteo Casarin (Legavolley 2013),Q55265514 +Nicolò,Casaro,Nicolò Casaro (Legavolley 2016),Q55265520 +Daniele,Casciaro,Daniele Casciaro (Legavolley 2014),Q55265510 +Cristian,Casoli,Cristian Casoli (Legavolley 2016),Q589270 +Carlo,Castellani,Carlo Castellani (Legavolley 2012),Q55265507 +Julian,Castellani,Julian Castellani (Legavolley 2012),Q55265512 +Maurizio,Castellano,Maurizio Castellano (Legavolley 2014),Q3301687 +Damiano,Catania,Damiano Catania (Legavolley 2016),Q55265522 +Luca,Catellani,Luca Catellani (Legavolley 2014),Q16268263 +Andrea,Cauteruccio,Andrea Cauteruccio (Legavolley 2012),Q55265530 +Maximiliano,Cavanna,Maximiliano Cavanna (Legavolley 2015),Q19984646 +Edgardo,Ceccoli,Edgardo Ceccoli (Legavolley 2016),Q55265537 +Alberto,Celestini,Alberto Celestini (Legavolley 2012),Q55265538 +Gundars,Celitans,Gundars Celitans (Legavolley 2012),Q2033888 +Federico,Centomo,Federico Centomo (Legavolley 2014),Q16875510 +Andrea,Cerbo,Andrea Cerbo (Legavolley 2014),Q55265539 +Velizar,Chernokozhev,Velizar Chernokozhev (Legavolley 2016),Q22277339 +Stefano,Chillemi,Stefano Chillemi (Legavolley 2017),Q55265541 +Stefan,Chrtiansky Jr,Stefan Chrtiansky Jr (Legavolley 2012),Q4025723 +Edoardo,Ciabattini,Edoardo Ciabattini (Legavolley 2012),Q16268281 +Alessandro,Ciavarella,Alessandro Ciavarella (Legavolley 2013),Q55265543 +Fosco,Cicola,Fosco Cicola (Legavolley 2016),Q3748944 +Alessandro,Cirocco,Alessandro Cirocco (Legavolley 2014),Q55265546 +Marco,Cittadino,Marco Cittadino (Legavolley 2014),Q55265551 +Vincenzo,Civita,Vincenzo Civita (Legavolley 2013),Q55265553 +Andrea,Coali,Andrea Coali (Legavolley 2013),Q3615610 +Fiorenzo,Colarusso,Fiorenzo Colarusso (Legavolley 2016),Q55265560 +Matteo,Consalvo,Matteo Consalvo (Legavolley 2016),Q55265574 +Facundo,Conte,Facundo Conte (Legavolley 2011),Q1391776 +Brian,Cook,Brian Cook (Legavolley 2016),Q18416530 +Alessio,Coppola,Alessio Coppola (Legavolley 2011),Q55265576 +Elio Giuseppe,Cormio,Elio Giuseppe Cormio (Legavolley 2016),Q55265579 +Mirko,Corsano,Mirko Corsano (Legavolley 2011),Q2316322 +Marco,Corsetti,Marco Corsetti (Legavolley 2016),Q55265590 +Francesco,Corsini,Francesco Corsini (Legavolley 2012),Q3749831 +Jordan,Corteggiani,Jordan Corteggiani (Legavolley 2017),Q27758374 +Marco,Cortese,Marco Cortese (Legavolley 2016),Q55265591 +Danilo,Cortina,Danilo Cortina (Legavolley 2016),Q11692823 +Mattia,Coscione,Mattia Coscione (Legavolley 2013),Q55265596 +Paolo,Cozzi,Paolo Cozzi (Legavolley 2013),Q2316341 +Pablo Damian,Crer,Pablo Damian Crer (Legavolley 2013),Q553817 +Sebastian,Creus Larry,Sebastian Creus Larry (Legavolley 2012),Q3827130 +Manuele,Cricca,Manuele Cricca (Legavolley 2013),Q3845123 +Andelko,Cuk,Andelko Cuk (Legavolley 2017),Q12605811 +Ivan,Cuomo,Ivan Cuomo (Legavolley 2011),Q55265603 +Konstantin,Cupkovic,Konstantin Cupkovic (Legavolley 2013),Q11742869 +Valerio,Curti,Valerio Curti (Legavolley 2012),Q3553720 +Roberto,D'Angelo,Roberto D'Angelo (Legavolley 2012),Q55265608 +Andrea,D'Avanzo,Andrea D'Avanzo (Legavolley 2011),Q55265633 +Francesco,Da Prato,Francesco Da Prato (Legavolley 2016),Q55265614 +Willyan,Da Silva,Willyan Da Silva (Legavolley 2016),Q55265632 +Paulo Victor,Da Silva Costa,Paulo Victor Da Silva Costa (Legavolley 2015),Q18279683 +Caio Fernando,Da Silva Fazanha,Caio Fernando Da Silva Fazanha (Legavolley 2014),Q55265615 +Mario,Da Silva Pedreira Junior,Mario Da Silva Pedreira Junior (Legavolley 2014),Q10334459 +Andrea,Dall'Olio,Andrea Dall'Olio (Legavolley 2011),Q55265604 +Matteo,Daolio,Matteo Daolio (Legavolley 2013),Q55265609 +Zoltan,David,Zoltan David (Legavolley 2012),Q55265635 +Dylan,Davis,Dylan Davis (Legavolley 2014),Q16630246 +Joao Rafael,De Barros Ferreira,Joao Rafael De Barros Ferreira (Legavolley 2016),Q55265640 +Michele,De Caria,Michele De Caria (Legavolley 2011),Q55265641 +Michele,De Giorgi,Michele De Giorgi (Legavolley 2011),Q3856576 +Diego,De Giovanni,Diego De Giovanni (Legavolley 2014),Q55265642 +Stefano,De Leo,Stefano De Leo (Legavolley 2013),Q55265638 +Hugo,De Leon Guimaraes,Hugo De Leon Guimaraes (Legavolley 2016),Q48843079 +Francesco,De Luca,Francesco De Luca (Legavolley 2015),Q21030412 +Davide,De Matteis,Davide De Matteis (Legavolley 2015),Q55265664 +Ricardo,De Paula,Ricardo De Paula (Legavolley 2011),Q55265665 +Jason,De Rocco,Jason De Rocco (Legavolley 2013),Q15819008 +Matteo,De Rosas,Matteo De Rosas (Legavolley 2016),Q55265636 +Michele,De Serio,Michele De Serio (Legavolley 2015),Q55265669 +Maciel Daniel,De Souza,Maciel Daniel De Souza (Legavolley 2016),Q55265668 +Federigo,Del Campo,Federigo Del Campo (Legavolley 2016),Q55265645 +Giuseppe,Della Corte,Giuseppe Della Corte (Legavolley 2014),Q16560751 +Ferdinando,Della Volpe,Ferdinando Della Volpe (Legavolley 2017),Q55265646 +Lorenzo,Dellepiaggi,Lorenzo Dellepiaggi (Legavolley 2016),Q55265659 +Angel,Dennis,Angel Dennis (Legavolley 2016),Q2319050 +Sam,Deroo,Sam Deroo (Legavolley 2014),Q3946328 +Rolando,Despaigne Jurquin,Rolando Despaigne Jurquin (Legavolley 2014),Q7360563 +Giovanni,Di Benedetto,Giovanni Di Benedetto (Legavolley 2011),Q55265673 +Luca,Di Felice,Luca Di Felice (Legavolley 2013),Q55265677 +Marcello,Di Felice,Marcello Di Felice (Legavolley 2014),Q55265679 +Fabio,Di Florio,Fabio Di Florio (Legavolley 2016),Q55265675 +Massimiliano,Di Franco,Massimiliano Di Franco (Legavolley 2014),Q3851014 +Fabio,Di Fulvio,Fabio Di Fulvio (Legavolley 2014),Q55265676 +Enzo,Di Manno,Enzo Di Manno (Legavolley 2011),Q3726507 +Andrea,Di Marco,Andrea Di Marco (Legavolley 2015),Q55265681 +Gabriele,Di Martino,Gabriele Di Martino (Legavolley 2017),Q55265683 +Savino,Di Noia,Savino Di Noia (Legavolley 2016),Q55265684 +Fabio,Di Pinto,Fabio Di Pinto (Legavolley 2013),Q55265686 +Andrii,Diachkov,Andrii Diachkov (Legavolley 2012),Q3616325 +Luis Augusto,Diaz,Luis Augusto Diaz (Legavolley 2011),Q3840347 +Dobromir,Dimitrov,Dobromir Dimitrov (Legavolley 2015),Q1233499 +Piervito,Disabato,Piervito Disabato (Legavolley 2016),Q55265687 +Julio Cesar,Do Nascimento Jr,Julio Cesar Do Nascimento Jr (Legavolley 2012),Q55265689 +Fabio,Donadio,Fabio Donadio (Legavolley 2015),Q16268337 +Federico,Donati,Federico Donati (Legavolley 2011),Q55265688 +Alessandro,Dordei,Alessandro Dordei (Legavolley 2011),Q55265690 +Vinicius,Dos Santos,Vinicius Dos Santos (Legavolley 2014),Q18397570 +Thomas Ewen,Douglas-Powell,Thomas Ewen Douglas-Powell (Legavolley 2015),Q55265691 +Gianluca,Durante,Gianluca Durante (Legavolley 2011),Q3763218 +Francesco,Dutto,Francesco Dutto (Legavolley 2011),Q55265698 +Thomas,Edgar,Thomas Edgar (Legavolley 2012),Q7789235 +Thomas,Ereu,Thomas Ereu (Legavolley 2011),Q3525092 +Mikko,Esko,Mikko Esko (Legavolley 2011),Q530340 +Jean-Francois,Exiga,Jean-Francois Exiga (Legavolley 2011),Q1754260 +Diego,Fabiano,Diego Fabiano (Legavolley 2015),Q55265700 +Guillermo,Falasca,Guillermo Falasca (Legavolley 2011),Q2732368 +Marco,Falaschi,Marco Falaschi (Legavolley 2012),Q3846100 +Leonardo,Fantauzzo,Leonardo Fantauzzo (Legavolley 2016),Q55265704 +Alessandro,Farina,Alessandro Farina (Legavolley 2013),Q2371973 +Paul,Ferenciac,Paul Ferenciac (Legavolley 2015),Q21282213 +Giuseppe,Feroleto,Giuseppe Feroleto (Legavolley 2015),Q55265748 +Raffaele,Ferraro,Raffaele Ferraro (Legavolley 2016),Q55265754 +Alexandre,Ferreira,Alexandre Ferreira (Legavolley 2016),Q16525318 +Marco Evan,Ferreira,Marco Evan Ferreira (Legavolley 2017),Q55265749 +Daivison,Ferreira Da Silva,Daivison Ferreira Da Silva (Legavolley 2011),Q55265746 +Alessio,Ferrini,Alessio Ferrini (Legavolley 2016),Q55265743 +Federico,Ferrini,Federico Ferrini (Legavolley 2015),Q55265747 +Giuseppe,Filomena,Giuseppe Filomena (Legavolley 2014),Q55265759 +Danilo,Finazzi,Danilo Finazzi (Legavolley 2011),Q3702176 +Mattia,Fiorelli,Mattia Fiorelli (Legavolley 2014),Q55265762 +Mattia,Fondrieschi,Mattia Fondrieschi (Legavolley 2014),Q55265765 +Miquel Angel,Fornés Jul,Miquel Angel Fornés Jul (Legavolley 2013),Q16782548 +Marcello,Forni,Marcello Forni (Legavolley 2016),Q11767433 +Andreas Dimitrios,Fragkos,Andreas Dimitrios Fragkos (Legavolley 2013),Q16526447 +Fabio,Franchetti,Fabio Franchetti (Legavolley 2016),Q55265768 +Nico,Freriks,Nico Freriks (Legavolley 2013),Q700290 +Diego,Frigo,Diego Frigo (Legavolley 2011),Q55265774 +Alberto,Frizzarin,Alberto Frizzarin (Legavolley 2016),Q55265771 +Christian,Fromm,Christian Fromm (Legavolley 2016),Q1079752 +Paolo,Fusaro,Paolo Fusaro (Legavolley 2011),Q55265779 +Simone,Gabbanelli,Simone Gabbanelli (Legavolley 2016),Q55265781 +Pasquale,Gabriele,Pasquale Gabriele (Legavolley 2016),Q16874968 +Lazzaro,Gaetano,Lazzaro Gaetano (Legavolley 2012),Q55265994 +Claudio,Gaggini,Claudio Gaggini (Legavolley 2015),Q55265784 +Alessandro,Gaia,Alessandro Gaia (Legavolley 2016),Q55265786 +Andrea,Galaverna,Andrea Galaverna (Legavolley 2016),Q23857381 +Danijel,Galic,Danijel Galic (Legavolley 2011),Q16548607 +Lorenzo,Gallosti,Lorenzo Gallosti (Legavolley 2011),Q3836954 +Cosimo,Gallotta,Cosimo Gallotta (Legavolley 2011),Q635532 +Nicola,Gamba,Nicola Gamba (Legavolley 2016),Q55265788 +Qi,Gao,Qi Gao (Legavolley 2015),Q55265795 +Marco,Garelli,Marco Garelli (Legavolley 2016),Q55265805 +Andrea,Garghella,Andrea Garghella (Legavolley 2014),Q3615739 +Luca,Garino,Luca Garino (Legavolley 2011),Q55265803 +Costantino,Garofalo,Costantino Garofalo (Legavolley 2016),Q55265800 +Mitja,Gasparini,Mitja Gasparini (Legavolley 2014),Q3317117 +Iacopo,Gatti,Iacopo Gatti (Legavolley 2014),Q55265808 +Michele,Gatto,Michele Gatto (Legavolley 2011),Q55265809 +Mario,Gaudieri,Mario Gaudieri (Legavolley 2014),Q55265810 +Filip,Gavenda,Filip Gavenda (Legavolley 2015),Q21282216 +Mauro,Gavotto,Mauro Gavotto (Legavolley 2014),Q3852835 +Baptiste,Geiler,Baptiste Geiler (Legavolley 2016),Q2883670 +Andrea,Gelasio,Andrea Gelasio (Legavolley 2011),Q55265813 +Lorenzo,Gemmi,Lorenzo Gemmi (Legavolley 2014),Q3836961 +Umberto,Gerosa,Umberto Gerosa (Legavolley 2016),Q55265818 +Giacomo,Ghibaudo,Giacomo Ghibaudo (Legavolley 2015),Q55265822 +Emiliano,Giglioli,Emiliano Giglioli (Legavolley 2016),Q3724291 +Leondino,Giombini,Leondino Giombini (Legavolley 2013),Q1620010 +Luca,Girolami,Luca Girolami (Legavolley 2016),Q55265826 +Javier,Gonzalez,Javier Gonzalez (Legavolley 2013),Q3163148 +Juan Manuel,Gonzalez,Juan Manuel Gonzalez (Legavolley 2013),Q16875583 +Svetoslav,Gotsev,Svetoslav Gotsev (Legavolley 2016),Q15643904 +Matteo,Granito,Matteo Granito (Legavolley 2015),Q55265839 +Nicola,Grassi,Nicola Grassi (Legavolley 2012),Q55265842 +Marco,Grasso,Marco Grasso (Legavolley 2012),Q55265838 +Nikola,Grbic,Nikola Grbic (Legavolley 2013),Q715898 +Marcel,Gromadowski,Marcel Gromadowski (Legavolley 2013),Q3289004 +Michele,Groppi,Michele Groppi (Legavolley 2017),Q55265849 +Branimir,Grozdanov,Branimir Grozdanov (Legavolley 2016),Q22278041 +Piotr,Gruszka,Piotr Gruszka (Legavolley 2011),Q2414507 +Emanuel,Guazzaroni,Emanuel Guazzaroni (Legavolley 2012),Q55265854 +Michel,Guemart,Michel Guemart (Legavolley 2014),Q17285003 +Giorgio,Guglielmo,Giorgio Guglielmo (Legavolley 2013),Q55265870 +Andrea,Guido,Andrea Guido (Legavolley 2012),Q55265875 +Matteo,Guidone,Matteo Guidone (Legavolley 2015),Q55265879 +Edoardo,Gulli,Edoardo Gulli (Legavolley 2012),Q55265881 +Marcus,Guttmann,Marcus Guttmann (Legavolley 2013),Q2776711 +Gérald,Hardy-Dessources,Gérald Hardy-Dessources (Legavolley 2011),Q3123631 +Niki,Hendriks,Niki Hendriks (Legavolley 2016),Q16268448 +Hubert,Henno,Hubert Henno (Legavolley 2014),Q2529650 +Fernando,Hernandez Ramos,Fernando Hernandez Ramos (Legavolley 2016),Q9259135 +Raydel,Hierrezuelo,Raydel Hierrezuelo (Legavolley 2016),Q7298426 +Marcelo,Hister,Marcelo Hister (Legavolley 2016),Q55265883 +Sam,Holt,Sam Holt (Legavolley 2017),Q22350672 +Robert,Horstink,Robert Horstink (Legavolley 2014),Q747329 +Michal,Hrazdira,Michal Hrazdira (Legavolley 2014),Q11778531 +Pei-Hung,Huang,Pei-Hung Huang (Legavolley 2018),Q16908354 +Andrea,Hueller,Andrea Hueller (Legavolley 2015),Q55265899 +Gazmend,Husaj,Gazmend Husaj (Legavolley 2013),Q16268450 +Gianluca,Iaccarino,Gianluca Iaccarino (Legavolley 2016),Q55265902 +Daniele,Illuzzi,Daniele Illuzzi (Legavolley 2011),Q55265904 +Antonino,Imbesi,Antonino Imbesi (Legavolley 2016),Q55265906 +Vito,Insalata,Vito Insalata (Legavolley 2011),Q55265909 +Aurelio,Inserra,Aurelio Inserra (Legavolley 2011),Q55265907 +Vito,Iurlaro,Vito Iurlaro (Legavolley 2011),Q55265910 +Axel,Jacobsen,Axel Jacobsen (Legavolley 2012),Q792207 +Eerik,Jago,Eerik Jago (Legavolley 2011),Q1456048 +Nemanja,Jakovljevic,Nemanja Jakovljevic (Legavolley 2013),Q26250977 +Peter,Janusek,Peter Janusek (Legavolley 2012),Q22278363 +Jakub,Jarosz,Jakub Jarosz (Legavolley 2012),Q1341322 +Yoann,Jaumel,Yoann Jaumel (Legavolley 2016),Q3572361 +Jani Nikolaev,Jeliazkov,Jani Nikolaev Jeliazkov (Legavolley 2016),Q16862738 +Ernesto,Jimenez,Ernesto Jimenez (Legavolley 2016),Q19599015 +Nikola,Jovovic,Nikola Jovovic (Legavolley 2016),Q1990605 +Michal,Kaczynski,Michal Kaczynski (Legavolley 2015),Q11778857 +Denys Viktorovic,Kaliberda,Denys Viktorovic Kaliberda (Legavolley 2016),Q121967 +Denis,Kalinin,Denis Kalinin (Legavolley 2016),Q22278496 +Lukas,Kampa,Lukas Kampa (Legavolley 2013),Q1876909 +Tamas,Kaszap,Tamas Kaszap (Legavolley 2014),Q19410134 +Joseph Clarence,Kauliakamoa Jr,Joseph Clarence Kauliakamoa Jr (Legavolley 2014),Q16268461 +Niels,Klapwijk,Niels Klapwijk (Legavolley 2013),Q11791526 +Emanuel,Kohut,Emanuel Kohut (Legavolley 2015),Q788776 +Danijel,Koncilja,Danijel Koncilja (Legavolley 2016),Q22269418 +Wytze,Kooistra,Wytze Kooistra (Legavolley 2014),Q1153544 +Dick,Kooy,Dick Kooy (Legavolley 2012),Q3706953 +Lazar,Koprivica,Lazar Koprivica (Legavolley 2017),Q22278685 +Kardo,Koresaar,Kardo Koresaar (Legavolley 2011),Q55265925 +Stanislav,Korniienko,Stanislav Korniienko (Legavolley 2015),Q55265928 +Viktors,Korzenevics,Viktors Korzenevics (Legavolley 2014),Q11901422 +Yu,Koshikawa,Yu Koshikawa (Legavolley 2011),Q1758580 +Damir,Kosmina,Damir Kosmina (Legavolley 2012),Q55265939 +Rafail,Koumentakis,Rafail Koumentakis (Legavolley 2015),Q17154441 +Andrea,Kouznetsov,Andrea Kouznetsov (Legavolley 2014),Q55265940 +Jakub,Kovac,Jakub Kovac (Legavolley 2017),Q55265941 +Ivan,Krachev,Ivan Krachev (Legavolley 2017),Q55265944 +Jiri,Kral,Jiri Kral (Legavolley 2011),Q3808504 +Humphrey Anthony,Krolis,Humphrey Anthony Krolis (Legavolley 2015),Q55265948 +Robert,Kromm,Robert Kromm (Legavolley 2011),Q471186 +Davis,Krumins,Davis Krumins (Legavolley 2015),Q16268463 +Bartosz,Kurek,Bartosz Kurek (Legavolley 2014),Q809573 +Jonas,Kvalen,Jonas Kvalen (Legavolley 2016),Q11728158 +Alessandro,La Forgia,Alessandro La Forgia (Legavolley 2011),Q55265970 +Lorenzo,Labardi,Lorenzo Labardi (Legavolley 2011),Q55265967 +Leonardo,Lacatena,Leonardo Lacatena (Legavolley 2016),Q55265969 +Davidson,Lampariello,Davidson Lampariello (Legavolley 2015),Q16548869 +Luca,Laneri,Luca Laneri (Legavolley 2016),Q55265985 +Eustachio,Lapacciana,Eustachio Lapacciana (Legavolley 2014),Q55265987 +Maurizio,Latelli,Maurizio Latelli (Legavolley 2012),Q3852629 +Pietro Luca,Latorre,Pietro Luca Latorre (Legavolley 2015),Q55265988 +Niccolò,Lattanzi,Niccolò Lattanzi (Legavolley 2011),Q16582301 +Antonio,Lavia,Antonio Lavia (Legavolley 2012),Q55265989 +Bradley,Lawson Colgate,Bradley Lawson Colgate (Legavolley 2012),Q55265993 +Nicola,Lazzari,Nicola Lazzari (Legavolley 2016),Q55265995 +Kevin,Le Roux,Kevin Le Roux (Legavolley 2016),Q3201162 +Martin,Lebl,Martin Lebl (Legavolley 2011),Q933707 +Jukka,Lehtonen,Jukka Lehtonen (Legavolley 2011),Q3188304 +Lucas,Lemanski Salim,Lucas Lemanski Salim (Legavolley 2016),Q55266010 +David,Lensi,David Lensi (Legavolley 2014),Q16548793 +Nicola,Leonardi,Nicola Leonardi (Legavolley 2012),Q3876255 +Luca,Leoni,Luca Leoni (Legavolley 2012),Q55266015 +Antonio,Libraro,Antonio Libraro (Legavolley 2011),Q55266021 +Marco,Lipparini,Marco Lipparini (Legavolley 2016),Q11767943 +Kirill,Listratov,Kirill Listratov (Legavolley 2016),Q55266026 +Milan,Lizala,Milan Lizala (Legavolley 2011),Q55266027 +Marco,Lo Bianco,Marco Lo Bianco (Legavolley 2014),Q3846218 +Marco,Loglisci,Marco Loglisci (Legavolley 2011),Q3846216 +Davide,Lollato,Davide Lollato (Legavolley 2016),Q55266033 +Andrea,Longo,Andrea Longo (Legavolley 2015),Q55266052 +Drazen,Luburic,Drazen Luburic (Legavolley 2015),Q22006383 +Julien,Lyneel,Julien Lyneel (Legavolley 2016),Q3189583 +William,Maestrelli,William Maestrelli (Legavolley 2014),Q55266066 +Alberto,Magalini,Alberto Magalini (Legavolley 2017),Q55266069 +Mladen,Majdak,Mladen Majdak (Legavolley 2015),Q3317417 +Davide,Manassero,Davide Manassero (Legavolley 2016),Q21030432 +Nicolò,Mancin,Nicolò Mancin (Legavolley 2016),Q55266075 +Tomislav,Maniero,Tomislav Maniero (Legavolley 2012),Q55266076 +Simone,Marcovecchio,Simone Marcovecchio (Legavolley 2016),Q55266123 +Lorenzo,Maretti,Lorenzo Maretti (Legavolley 2017),Q55266108 +Goran,Maric,Goran Maric (Legavolley 2015),Q3110807 +Simone,Marini,Simone Marini (Legavolley 2011),Q55266122 +Mario,Marolda,Mario Marolda (Legavolley 2011),Q55266118 +Alessandro,Marta,Alessandro Marta (Legavolley 2016),Q55266078 +Matteo,Martino,Matteo Martino (Legavolley 2013),Q2274886 +Luca,Marzo,Luca Marzo (Legavolley 2016),Q55266117 +Marco,Marzola,Marco Marzola (Legavolley 2014),Q55266120 +Andrea,Masini,Andrea Masini (Legavolley 2017),Q55266124 +Luigi,Mastrangelo,Luigi Mastrangelo (Legavolley 2013),Q965931 +Josè,Matheus,Josè Matheus (Legavolley 2012),Q55266126 +Mattia,Matricardi,Mattia Matricardi (Legavolley 2015),Q55266147 +Giordano,Mattera,Giordano Mattera (Legavolley 2014),Q3765167 +Francesco,Mattioli,Francesco Mattioli (Legavolley 2012),Q3750266 +Carmelo,Mazza,Carmelo Mazza (Legavolley 2015),Q55266150 +Paolo,Mazzone,Paolo Mazzone (Legavolley 2016),Q55266157 +Filippo,Mazzotti,Filippo Mazzotti (Legavolley 2012),Q55266152 +Riley,Mc Kibbin,Riley Mc Kibbin (Legavolley 2014),Q3935824 +Luka,Medic,Luka Medic (Legavolley 2014),Q55266159 +Daniele,Mengozzi,Daniele Mengozzi (Legavolley 2015),Q55266160 +Jeffrey,Menzel,Jeffrey Menzel (Legavolley 2012),Q3807816 +Domotor,Meszaros,Domotor Meszaros (Legavolley 2011),Q3045573 +Peter,Michalovic,Peter Michalovic (Legavolley 2016),Q16658062 +Tommaso,Migliorin,Tommaso Migliorin (Legavolley 2016),Q55266166 +Stefano,Mignolo,Stefano Mignolo (Legavolley 2011),Q55266165 +Ivan,Miljkovic,Ivan Miljkovic (Legavolley 2015),Q726002 +Nicolas,Miola,Nicolas Miola (Legavolley 2016),Q55266170 +Costantino,Mirenda,Costantino Mirenda (Legavolley 2013),Q55266172 +Emanuele,Miscio,Emanuele Miscio (Legavolley 2015),Q55266175 +Andrea,Miselli,Andrea Miselli (Legavolley 2016),Q55266173 +Radzivon,Miskevich,Radzivon Miskevich (Legavolley 2016),Q28859143 +Mihajlo,Mitic,Mihajlo Mitic (Legavolley 2016),Q172436 +Fabio,Molteni,Fabio Molteni (Legavolley 2015),Q55266177 +Marco,Molteni,Marco Molteni (Legavolley 2012),Q1134601 +Davide,Monesi,Davide Monesi (Legavolley 2013),Q55266180 +Maurizio,Montanari,Maurizio Montanari (Legavolley 2015),Q55266187 +Leonardo,Monteleone,Leonardo Monteleone (Legavolley 2014),Q55266185 +Mattia,Montesanti,Mattia Montesanti (Legavolley 2012),Q55266186 +Carlo,Mor,Carlo Mor (Legavolley 2012),Q55266190 +Riccardo,Morciano,Riccardo Morciano (Legavolley 2017),Q55266192 +Alexander,Moreno Quejada,Alexander Moreno Quejada (Legavolley 2011),Q55266189 +Daniele,Moretti,Daniele Moretti (Legavolley 2014),Q55266191 +Federico,Moretti,Federico Moretti (Legavolley 2016),Q16555516 +Stefano,Moro,Stefano Moro (Legavolley 2012),Q16268560 +Milija,Mrdak,Milija Mrdak (Legavolley 2015),Q12755395 +Garrett,Muagututia,Garrett Muagututia (Legavolley 2012),Q16548957 +Giuseppe,Muccio,Giuseppe Muccio (Legavolley 2016),Q55266199 +Carmelo,Muscarà,Carmelo Muscarà (Legavolley 2013),Q55266200 +Fabio,Muzio,Fabio Muzio (Legavolley 2012),Q55266201 +Claudio,Nardi,Claudio Nardi (Legavolley 2012),Q3680155 +Richard,Nemec,Richard Nemec (Legavolley 2011),Q3182060 +Szabolcs,Nemeth,Szabolcs Nemeth (Legavolley 2011),Q55266205 +Alessandro,Nero,Alessandro Nero (Legavolley 2016),Q55266207 +Asclepio,Nicolazzo,Asclepio Nicolazzo (Legavolley 2014),Q55266211 +Milos,Nikic,Milos Nikic (Legavolley 2015),Q1897050 +Nikolay,Nikolov,Nikolay Nikolov (Legavolley 2011),Q1991179 +Vladimir,Nikolov,Vladimir Nikolov (Legavolley 2011),Q2119527 +Paco,Nobili,Paco Nobili (Legavolley 2012),Q55266216 +Sergio,Noda Blanco,Sergio Noda Blanco (Legavolley 2016),Q9335461 +Michele,Nonne,Michele Nonne (Legavolley 2011),Q3856730 +Marco,Norbedo,Marco Norbedo (Legavolley 2016),Q55266217 +Jordan Matthew,Nowakowski,Jordan Matthew Nowakowski (Legavolley 2016),Q55266220 +Floride,Ntotila,Floride Ntotila (Legavolley 2015),Q55266222 +Marco,Nuti,Marco Nuti (Legavolley 2011),Q3290128 +Gianluca,Nuzzo,Gianluca Nuzzo (Legavolley 2013),Q3763274 +Yuri,Occhiogrosso,Yuri Occhiogrosso (Legavolley 2016),Q55266223 +Frantisek,Ogurcak,Frantisek Ogurcak (Legavolley 2017),Q3752095 +Simo-Pekka,Olli,Simo-Pekka Olli (Legavolley 2011),Q2305165 +Bogdan,Olteanu,Bogdan Olteanu (Legavolley 2016),Q2908642 +Igor,Omrcen,Igor Omrcen (Legavolley 2011),Q2526632 +Renato,Orsini,Renato Orsini (Legavolley 2015),Q55266229 +Claudio,Osak,Claudio Osak (Legavolley 2015),Q55266233 +Aleksej Aleksandrovic,Ostapenko,Aleksej Aleksandrovic Ostapenko (Legavolley 2014),Q55266234 +Massimo,Ostuzzi,Massimo Ostuzzi (Legavolley 2016),Q55266237 +Robin,Overbeeke,Robin Overbeeke (Legavolley 2012),Q22279525 +Ryan Jay,Owens,Ryan Jay Owens (Legavolley 2012),Q55266242 +Robart Alexander,Page,Robart Alexander Page (Legavolley 2014),Q18420358 +Filippo,Pagni,Filippo Pagni (Legavolley 2011),Q16268596 +Marco,Pagni,Marco Pagni (Legavolley 2012),Q55266248 +Marco,Palmigiani,Marco Palmigiani (Legavolley 2016),Q55266253 +Giacomo,Pambianchi,Giacomo Pambianchi (Legavolley 2011),Q55266255 +Lorenzo,Panighini,Lorenzo Panighini (Legavolley 2011),Q55266256 +Alessandro,Paparoni,Alessandro Paparoni (Legavolley 2014),Q3610200 +Samuele,Papi,Samuele Papi (Legavolley 2016),Q965892 +Marco,Pappadà,Marco Pappadà (Legavolley 2013),Q55266259 +Claudio,Paris,Claudio Paris (Legavolley 2016),Q55266261 +Gabriele,Parisi,Gabriele Parisi (Legavolley 2014),Q55266262 +Leonardo,Parisi,Leonardo Parisi (Legavolley 2016),Q55266264 +Travis,Passier,Travis Passier (Legavolley 2011),Q7836346 +Evan Hoburg,Patak,Evan Hoburg Patak (Legavolley 2011),Q3662451 +Giuseppe,Patriarca,Giuseppe Patriarca (Legavolley 2014),Q3771172 +Marco,Pavan,Marco Pavan (Legavolley 2011),Q11767948 +Nikolay,Pavlov,Nikolay Pavlov (Legavolley 2015),Q4502714 +Harrison,Peacock,Harrison Peacock (Legavolley 2012),Q5665796 +Massimo,Pecorari,Massimo Pecorari (Legavolley 2011),Q3851392 +Lorenzo,Peirano,Lorenzo Peirano (Legavolley 2015),Q55266274 +Panagiotis,Pelekoudas,Panagiotis Pelekoudas (Legavolley 2012),Q16886457 +Enrico,Peli,Enrico Peli (Legavolley 2014),Q55266278 +Gianluca,Pellegrinelli,Gianluca Pellegrinelli (Legavolley 2017),Q55266286 +Davide,Pellegrino,Davide Pellegrino (Legavolley 2016),Q19985036 +Gianluca,Pellegrino,Gianluca Pellegrino (Legavolley 2012),Q55266282 +Gabriele,Peluffo,Gabriele Peluffo (Legavolley 2015),Q55266279 +Chono,Penchev,Chono Penchev (Legavolley 2017),Q22279632 +Nikolay Zarkov,Penchev,Nikolay Zarkov Penchev (Legavolley 2011),Q1688332 +Rozalin,Penchev,Rozalin Penchev (Legavolley 2016),Q22279633 +Angel Javier,Perez Rivera,Angel Javier Perez Rivera (Legavolley 2017),Q2849353 +Ricardo,Perini De Aviz,Ricardo Perini De Aviz (Legavolley 2015),Q55266294 +Enrico,Perla,Enrico Perla (Legavolley 2016),Q55266292 +John Gordon,Perrin,John Gordon Perrin (Legavolley 2015),Q21097218 +Vlado,Petkovic,Vlado Petkovic (Legavolley 2011),Q2121497 +Nemanja,Petric,Nemanja Petric (Legavolley 2016),Q4360588 +Emanuele,Petrosillo,Emanuele Petrosillo (Legavolley 2013),Q55266296 +Umberto,Picariello,Umberto Picariello (Legavolley 2012),Q55266300 +Gianluca,Piccinini,Gianluca Piccinini (Legavolley 2012),Q55266298 +Francesco,Pieri,Francesco Pieri (Legavolley 2013),Q3081052 +Simone,Pieri,Simone Pieri (Legavolley 2016),Q55266301 +Roberto,Pinali,Roberto Pinali (Legavolley 2016),Q55266304 +Kervin,Pinerua,Kervin Pinerua (Legavolley 2012),Q6394807 +Filipe Fontes,Pinto,Filipe Fontes Pinto (Legavolley 2013),Q55266302 +Edoardo,Pizzileo,Edoardo Pizzileo (Legavolley 2013),Q55266306 +Miha,Plot,Miha Plot (Legavolley 2013),Q16578419 +Oleh,Plotnytskyi,Oleh Plotnytskyi (Legavolley 2017),Q55266308 +Antti,Poikela,Antti Poikela (Legavolley 2011),Q11852209 +Giovanni,Polidori,Giovanni Polidori (Legavolley 2012),Q544188 +Matthew,Pollock,Matthew Pollock (Legavolley 2017),Q19708831 +Pierpaolo,Polselli,Pierpaolo Polselli (Legavolley 2012),Q55266338 +Thiago,Pontes Veloso,Thiago Pontes Veloso (Legavolley 2016),Q25175984 +Marcus,Popp,Marcus Popp (Legavolley 2011),Q69982 +Daniele,Postiglioni,Daniele Postiglioni (Legavolley 2012),Q55266365 +Michele,Pranovi,Michele Pranovi (Legavolley 2016),Q55266366 +Randy,Preval,Randy Preval (Legavolley 2013),Q55266370 +Giovanni,Primavera,Giovanni Primavera (Legavolley 2016),Q55266373 +William,Procopio,William Procopio (Legavolley 2014),Q55266378 +Athanasios,Psarras,Athanasios Psarras (Legavolley 2012),Q55266380 +Leonardo,Puliti,Leonardo Puliti (Legavolley 2015),Q55266386 +Pedro Luiz,Putini,Pedro Luiz Putini (Legavolley 2016),Q55266389 +Guillaume,Quesque,Guillaume Quesque (Legavolley 2014),Q3120147 +Danger Jorber,Quintana Guerra,Danger Jorber Quintana Guerra (Legavolley 2016),Q55266395 +Gonzalo,Quiroga,Gonzalo Quiroga (Legavolley 2015),Q17308247 +Rodrigo Daniel,Quiroga,Rodrigo Daniel Quiroga (Legavolley 2011),Q553793 +Balsa,Radunovic,Balsa Radunovic (Legavolley 2012),Q16268686 +Michal,Rak,Michal Rak (Legavolley 2012),Q947265 +Alex,Ranghieri,Alex Ranghieri (Legavolley 2012),Q17352964 +Antonio,Ratano,Antonio Ratano (Legavolley 2015),Q55266405 +Giancarlo,Rau,Giancarlo Rau (Legavolley 2017),Q55266407 +Jeroen,Rauwerdink,Jeroen Rauwerdink (Legavolley 2014),Q3807990 +Rudi,Rea,Rudi Rea (Legavolley 2013),Q55266408 +Riccardo,Reggio,Riccardo Reggio (Legavolley 2012),Q55266410 +Federico,Reina,Federico Reina (Legavolley 2017),Q55266411 +Filip,Rejlek,Filip Rejlek (Legavolley 2016),Q3071839 +Valerio,Riccardi,Valerio Riccardi (Legavolley 2017),Q55266420 +Luigi,Ricci,Luigi Ricci (Legavolley 2012),Q55266418 +Antonio,Ricciardello,Antonio Ricciardello (Legavolley 2012),Q3620092 +Giacomo,Rigoni,Giacomo Rigoni (Legavolley 2013),Q9267801 +Danilo,Rinaldi,Danilo Rinaldi (Legavolley 2016),Q3702199 +Simone,Riolo,Simone Riolo (Legavolley 2013),Q55266426 +Carlo,Rispoli,Carlo Rispoli (Legavolley 2012),Q55266429 +Andrej,Ristic,Andrej Ristic (Legavolley 2017),Q55266427 +Matteo,Ritacco,Matteo Ritacco (Legavolley 2014),Q55266431 +Roberto,Rivan,Roberto Rivan (Legavolley 2015),Q55266434 +Jose Manuel,Rivera Caamano,Jose Manuel Rivera Caamano (Legavolley 2011),Q3186547 +Salvatore,Roberti,Salvatore Roberti (Legavolley 2017),Q55266436 +Alain Addys,Roca Borrero,Alain Addys Roca Borrero (Legavolley 2011),Q3607653 +Daniel,Rocamora,Daniel Rocamora (Legavolley 2012),Q22280077 +Emanuele,Rodella,Emanuele Rodella (Legavolley 2016),Q55266440 +Israel,Rodriguez,Israel Rodriguez (Legavolley 2011),Q3803401 +Sean,Rooney,Sean Rooney (Legavolley 2011),Q1893361 +Gregor,Ropret,Gregor Ropret (Legavolley 2016),Q19663925 +Simone,Rosalba,Simone Rosalba (Legavolley 2012),Q593499 +Lorenzo,Rossi,Lorenzo Rossi (Legavolley 2014),Q55266457 +Nicolas,Roumeliotis,Nicolas Roumeliotis (Legavolley 2011),Q55266463 +Tomas,Rousseaux,Tomas Rousseaux (Legavolley 2015),Q21207025 +Antonin,Rouzier,Antonin Rouzier (Legavolley 2013),Q2857142 +Gabriele,Rudi,Gabriele Rudi (Legavolley 2016),Q55266464 +Roberto,Ruggeri,Roberto Ruggeri (Legavolley 2011),Q55266465 +Ivan Benito,Ruiz,Ivan Benito Ruiz (Legavolley 2013),Q3804969 +Giorgio,Russo,Giorgio Russo (Legavolley 2013),Q55266468 +Massimiliano,Russo,Massimiliano Russo (Legavolley 2011),Q16268722 +Renato,Russomanno Dos Santos,Renato Russomanno Dos Santos (Legavolley 2016),Q18280440 +Lucas,Saatkamp,Lucas Saatkamp (Legavolley 2015),Q1352837 +Davide,Saitta,Davide Saitta (Legavolley 2013),Q3703617 +Andrea,Sala,Andrea Sala (Legavolley 2015),Q3616025 +Davide,Sala,Davide Sala (Legavolley 2011),Q55266470 +Jacopo,Sala,Jacopo Sala (Legavolley 2016),Q55266472 +Tuomas,Sammelvuo,Tuomas Sammelvuo (Legavolley 2011),Q655863 +Paul,Sanderson,Paul Sanderson (Legavolley 2014),Q22280283 +Giulio,Santilli,Giulio Santilli (Legavolley 2016),Q55266482 +Simone,Sardanelli,Simone Sardanelli (Legavolley 2017),Q16606373 +Davide,Sarnari,Davide Sarnari (Legavolley 2012),Q55266496 +Luca,Sartoretti,Luca Sartoretti (Legavolley 2015),Q16268746 +Andrea,Sartori,Andrea Sartori (Legavolley 2016),Q55266484 +Emanuele,Sborgia,Emanuele Sborgia (Legavolley 2013),Q3723997 +Riccardo,Scaltriti,Riccardo Scaltriti (Legavolley 2016),Q55266512 +Leonardo,Scanferla,Leonardo Scanferla (Legavolley 2017),Q55266508 +Mario,Scappaticcio,Mario Scappaticcio (Legavolley 2015),Q3849088 +Enrico,Scarpi,Enrico Scarpi (Legavolley 2013),Q16867091 +Patrick,Schwagler,Patrick Schwagler (Legavolley 2014),Q21587893 +Sebastian,Schwarz,Sebastian Schwarz (Legavolley 2012),Q74494 +Giuseppe,Scialò,Giuseppe Scialò (Legavolley 2013),Q55266519 +Fabio,Scio,Fabio Scio (Legavolley 2016),Q55266518 +Salvo,Scolaro,Salvo Scolaro (Legavolley 2012),Q55266524 +Lorenzo,Scuderi,Lorenzo Scuderi (Legavolley 2012),Q55266528 +Marko,Sedlacek,Marko Sedlacek (Legavolley 2015),Q24953764 +Andrea,Semenzato,Andrea Semenzato (Legavolley 2014),Q1134586 +Valdir,Sequeira,Valdir Sequeira (Legavolley 2011),Q9368114 +Sergio,Seregni,Sergio Seregni (Legavolley 2013),Q55266541 +Filip,Sestan,Filip Sestan (Legavolley 2016),Q23761862 +Giuseppe,Sette,Giuseppe Sette (Legavolley 2013),Q55266550 +Konstantin,Shumov,Konstantin Shumov (Legavolley 2014),Q1456040 +Mory,Sidibé,Mory Sidibé (Legavolley 2011),Q3324654 +Nicholas,Sighinolfi,Nicholas Sighinolfi (Legavolley 2016),Q22069566 +Gianluca,Signorelli,Gianluca Signorelli (Legavolley 2014),Q55266565 +Antti,Siltala,Antti Siltala (Legavolley 2012),Q2857678 +Ventceslav,Simeonov,Ventceslav Simeonov (Legavolley 2011),Q2316242 +Robertlandy,Simon,Robertlandy Simon (Legavolley 2013),Q2645150 +Lucas,Simone,Lucas Simone (Legavolley 2011),Q55266568 +Giacomo,Sintini,Giacomo Sintini (Legavolley 2014),Q1074873 +Luca,Sirri,Luca Sirri (Legavolley 2013),Q55266573 +Alen,Sket,Alen Sket (Legavolley 2015),Q9147004 +Todor,Skrimov,Todor Skrimov (Legavolley 2016),Q554628 +Lorenzo,Smerilli,Lorenzo Smerilli (Legavolley 2013),Q3837080 +Luke,Smith,Luke Smith (Legavolley 2012),Q16233583 +Sebastian,Solé,Sebastian Solé (Legavolley 2016),Q553806 +Pietro,Soli,Pietro Soli (Legavolley 2016),Q55266592 +Luca,Sorato,Luca Sorato (Legavolley 2011),Q55266598 +Mattia,Sorrenti,Mattia Sorrenti (Legavolley 2014),Q55266599 +Simone,Spescha,Simone Spescha (Legavolley 2012),Q16268775 +Giuseppe,Spicolo,Giuseppe Spicolo (Legavolley 2013),Q55266612 +Patrick,Steuerwald,Patrick Steuerwald (Legavolley 2013),Q89348 +Jan,Stokr,Jan Stokr (Legavolley 2016),Q3495798 +Simone,Straino,Simone Straino (Legavolley 2015),Q55266629 +Nicola,Straolzini,Nicola Straolzini (Legavolley 2014),Q55266627 +Bojan,Strugar,Bojan Strugar (Legavolley 2016),Q23761663 +Vittorio,Suglia,Vittorio Suglia (Legavolley 2014),Q55266631 +Luka,Suljagic,Luka Suljagic (Legavolley 2016),Q3266997 +Joseph Richard,Sunder,Joseph Richard Sunder (Legavolley 2014),Q15630708 +Andrea,Surace,Andrea Surace (Legavolley 2013),Q55266644 +Donald,Suxho,Donald Suxho (Legavolley 2013),Q1240401 +Dàvid,Szabo,Dàvid Szabo (Legavolley 2013),Q3716947 +Matteo,Tabanelli,Matteo Tabanelli (Legavolley 2012),Q55266645 +Daniele,Tailli,Daniele Tailli (Legavolley 2015),Q16546559 +Michele,Tamborra,Michele Tamborra (Legavolley 2012),Q55266653 +Catalin Julian,Tataru,Catalin Julian Tataru (Legavolley 2015),Q55266658 +Futi,Tavana,Futi Tavana (Legavolley 2012),Q15780331 +Miguel,Tavares Rodrigues,Miguel Tavares Rodrigues (Legavolley 2015),Q23761647 +Bruno,Temponi Araujo,Bruno Temponi Araujo (Legavolley 2014),Q55264468 +Luca,Tencati,Luca Tencati (Legavolley 2016),Q3265009 +Thijs,Ter Horst,Thijs Ter Horst (Legavolley 2015),Q16615624 +Lorenzo,Tescaro,Lorenzo Tescaro (Legavolley 2013),Q55266662 +Simone,Testalepre,Simone Testalepre (Legavolley 2015),Q55266665 +Raphael,Thiago De Oliveira,Raphael Thiago De Oliveira (Legavolley 2011),Q18280320 +Stefano,Thiaw,Stefano Thiaw (Legavolley 2013),Q16878820 +Linus,Tholse,Linus Tholse (Legavolley 2011),Q3833132 +Nicolas Jesus,Tibaldo,Nicolas Jesus Tibaldo (Legavolley 2011),Q55266676 +Kevin,Tillie,Kevin Tillie (Legavolley 2013),Q3201170 +Riccardo,Tobaldi,Riccardo Tobaldi (Legavolley 2013),Q55266678 +Alessandro,Tofoli,Alessandro Tofoli (Legavolley 2016),Q55266688 +Giacomo,Tomasello,Giacomo Tomasello (Legavolley 2014),Q55266689 +Benjamin,Toniutti,Benjamin Toniutti (Legavolley 2014),Q2896253 +Maximo,Torcello,Maximo Torcello (Legavolley 2011),Q23417100 +Paolo,Torre,Paolo Torre (Legavolley 2016),Q3362670 +Maurice Armando,Torres,Maurice Armando Torres (Legavolley 2016),Q15817981 +Lorenzo,Tosi,Lorenzo Tosi (Legavolley 2013),Q55266692 +Angel,Trinidad De Haro,Angel Trinidad De Haro (Legavolley 2013),Q16623970 +Murphy Edward,Troy,Murphy Edward Troy (Legavolley 2012),Q9281055 +Jari,Tuominen,Jari Tuominen (Legavolley 2011),Q3162730 +Fabrizio,Turco,Fabrizio Turco (Legavolley 2016),Q55266698 +Nikolay,Uchikov,Nikolay Uchikov (Legavolley 2012),Q16395220 +Riccardo,Valla,Riccardo Valla (Legavolley 2016),Q55266705 +Simon,Van De Voorde,Simon Van De Voorde (Legavolley 2016),Q14339789 +Bram,Van Den Dries,Bram Van Den Dries (Legavolley 2012),Q3643587 +Yannick,Van Harskamp,Yannick Van Harskamp (Legavolley 2012),Q9383357 +Toon,Van Lankvelt,Toon Van Lankvelt (Legavolley 2011),Q3531986 +Floris,Van Rekom,Floris Van Rekom (Legavolley 2012),Q17285799 +Gert,Van Walle,Gert Van Walle (Legavolley 2013),Q3761321 +Andrea,Vanini,Andrea Vanini (Legavolley 2016),Q55266707 +Peter,Veres,Peter Veres (Legavolley 2014),Q1136279 +Matthijs,Verhanneman,Matthijs Verhanneman (Legavolley 2012),Q2913265 +Valerio,Vermiglio,Valerio Vermiglio (Legavolley 2016),Q2737948 +Jakub,Vesely,Jakub Vesely (Legavolley 2012),Q3160694 +Jaime,Viafara,Jaime Viafara (Legavolley 2012),Q55266733 +Marco,Vianello,Marco Vianello (Legavolley 2014),Q19414212 +Raphael,Vieira De Oliveira,Raphael Vieira De Oliveira (Legavolley 2012),Q3930206 +Cristian ,Vigilante,Cristian Vigilante (Legavolley 2011),Q55266736 +Andres,Villena,Andres Villena (Legavolley 2014),Q16526580 +Alessandro,Vinella,Alessandro Vinella (Legavolley 2011),Q55266749 +Marco,Visentin,Marco Visentin (Legavolley 2016),Q16575947 +Simone,Vitangeli,Simone Vitangeli (Legavolley 2016),Q55266764 +Alessandro,Vitanza,Alessandro Vitanza (Legavolley 2013),Q55266759 +Giacomo,Viva,Giacomo Viva (Legavolley 2011),Q55266765 +Goran,Vujevic,Goran Vujevic (Legavolley 2014),Q44406 +Samuel,Walker,Samuel Walker (Legavolley 2014),Q55266777 +Chen,Wang,Chen Wang (Legavolley 2014),Q55266785 +Adam,White,Adam White (Legavolley 2014),Q4679973 +Wout,Wijsmans,Wout Wijsmans (Legavolley 2012),Q512605 +Lincoln Alexander,Williams,Lincoln Alexander Williams (Legavolley 2013),Q6551180 +Kyle,Williamson,Kyle Williamson (Legavolley 2013),Q55266793 +Boyan,Yordanov,Boyan Yordanov (Legavolley 2011),Q2622665 +Jonathan,Zaccaria,Jonathan Zaccaria (Legavolley 2011),Q55266795 +Enrico,Zampetti,Enrico Zampetti (Legavolley 2013),Q55266797 +Matteo,Zamponi,Matteo Zamponi (Legavolley 2012),Q55266803 +Renan,Zanatta Buiatti,Renan Zanatta Buiatti (Legavolley 2015),Q15985076 +Andrea,Zancla,Andrea Zancla (Legavolley 2013),Q55266804 +Mauricio,Zanette Mugnaini,Mauricio Zanette Mugnaini (Legavolley 2017),Q55266808 +Bruno,Zanuto,Bruno Zanuto (Legavolley 2014),Q11688938 +Andrey Georgiev,Zhekov,Andrey Georgiev Zhekov (Legavolley 2011),Q2617159 +Tsimafei,Zhukouski,Tsimafei Zhukouski (Legavolley 2017),Q3999949 +Marco,Zingaro,Marco Zingaro (Legavolley 2011),Q55266812 +Giuseppe,Zito,Giuseppe Zito (Legavolley 2013),Q55266817 +Hristo,Zlatanov,Hristo Zlatanov (Legavolley 2016),Q2294149 +Francois,Zonno,Francois Zonno (Legavolley 2016),Q55266833 +Lukasz,Zygadlo,Lukasz Zygadlo (Legavolley 2014),Q384174 diff --git a/2017-11-wikidata-volleyball-players/includes/boz-mw b/2017-11-wikidata-volleyball-players/includes/boz-mw new file mode 160000 index 0000000..a6ea32f --- /dev/null +++ b/2017-11-wikidata-volleyball-players/includes/boz-mw @@ -0,0 +1 @@ +Subproject commit a6ea32f3526a54128e480a79ec4113ca6529c6af diff --git a/2017-11-wikidata-volleyball-players/volleyball-players.php b/2017-11-wikidata-volleyball-players/volleyball-players.php index d6619e1..f72d56d 100755 --- a/2017-11-wikidata-volleyball-players/volleyball-players.php +++ b/2017-11-wikidata-volleyball-players/volleyball-players.php @@ -1,1090 +1,1022 @@ +#!/usr/bin/php fetch( [ - 'action' => 'query', - 'meta' => 'tokens', - 'type' => 'login' -] )->query->tokens->logintoken; - -################ -# Wikidata login -################ - -$response = $wikidata_api->post( [ - 'action' => 'login', - 'lgname' => WIKI_USERNAME, - 'lgpassword' => WIKI_PASSWORD, - 'lgtoken' => $logintoken -] ); -if( ! isset( $response->login->result ) || $response->login->result !== 'Success' ) { - throw new Exception("login failed"); -} - -############################## -# Wikidata CSRF token (logged) -############################## - -$WIKIDATA_CSRF_TOKEN = $wikidata_api->fetch( [ - 'action' => 'query', - 'meta' => 'tokens', - 'type' => 'csrf' -] )->query->tokens->csrftoken; - -##################### -# Commons Login token -##################### - -$commons_api = mw\APIRequest::factory('https://commons.wikimedia.org/w/api.php'); -$logintoken = $commons_api->fetch( [ - 'action' => 'query', - 'meta' => 'tokens', - 'type' => 'login' -] )->query->tokens->logintoken; - -############### -# Commons login -############### - -$response = $commons_api->post( [ - 'action' => 'login', - 'lgname' => WIKI_USERNAME, - 'lgpassword' => WIKI_PASSWORD, - 'lgtoken' => $logintoken -] ); -if( ! isset( $response->login->result ) || $response->login->result !== 'Success' ) { - throw new Exception("login failed"); -} +$wikidata_api = \wm\Wikidata::getInstance()->login(); +$commons_api = \wm\Commons ::getInstance()->login(); -############################# -# Commons CSRF token (logged) -############################# - -$COMMONS_CSRF_TOKEN = $commons_api->fetch( [ - 'action' => 'query', - 'meta' => 'tokens', - 'type' => 'csrf' -] )->query->tokens->csrftoken; +$WIKIDATA_CSRF_TOKEN = $wikidata_api->getToken( \mw\Tokens::CSRF ); +$COMMONS_CSRF_TOKEN = $commons_api ->getToken( \mw\Tokens::CSRF ); ############# # Nations CSV ############# $NATIONS = []; if( ($handle = fopen('commons-volleyball-nationalities.csv', 'r') ) !== false ) { $i = -1; while( ($data = fgetcsv($handle, 1000, ',') ) !== false ) { $i++; if( $i === 0 ) { // Skip header continue; } // :P This prevents warnings if $better_cat is missing; or don't care if $better_cat is present. $data[] = null; list($code, $wikidata_id, $it_m, $it_f, $en, $cat, $better_cat ) = $data; $NATIONS[ $code ] = new Nat($wikidata_id, $it_m, $en, $cat, $better_cat); } fclose($handle); } $missing_natcodes = []; ######################## # Volleyball players CSV ######################## $LATEST = file_exists( 'latest.txt' ) ? trim( file_get_contents( 'latest.txt' ) ) : false; if( ( $handle = fopen('commons-volleyball-players.csv', 'r') ) !== false ) { $porcelain = false; $i = -1; while( ( $data = fgetcsv($handle, 1000, ',')) !== false ) { $i++; if( $i === 0 ) { // Skip header continue; } - list($ID, $surname, $name, $natcode, $file) = $data; + list($ID, $surname, $name, $natcode, $file, $item) = $data; if( ! isset( $NATIONS[ $natcode ] ) ) { $missing_natcodes[] = $natcode; $porcelain = true; } if( $porcelain ) { continue; } if( false !== $LATEST && $ID < $LATEST ) { echo "Skipping $surname (jet processed)...\n"; continue; } $LATEST = $ID; file_put_contents( 'latest.txt', $LATEST ); $filepath = "$file.jpg"; $filename = "File:$filepath"; if( ! commons_page_exists( $filename ) ) { echo "# Skipping [[$filename]] that does not exist\n"; continue; } $filename_url = commons_page_url( $filename ); $complete_name = "$name $surname"; - $wikidata_item = get_wikidata_item( $filename, $complete_name ); + $wikidata_item = $item ? $item : get_wikidata_item( $filename, $complete_name ); if( SANDBOXED ) { echo "SANDBOXED\n"; $wikidata_item = WIKIDATA_SANDBOX; } $wikidata_item_data = null; if( $wikidata_item ) { // Retrieve & compare // https://www.wikidata.org/w/api.php?action=help&modules=wbgetentities $wikidata_item_data = $wikidata_api->fetch( [ 'action' => 'wbgetentities', 'ids' => $wikidata_item, 'props' => 'info|sitelinks|aliases|labels|descriptions|claims|datatype' ] ); if( ! isset( $wikidata_item_data->entities->{ $wikidata_item } ) ) { throw new Exception("$wikidata_item does not exist?"); } $wikidata_item_data = wb\DataModel::createFromObject( $wikidata_item_data->entities->{ $wikidata_item } ); } $personal_category = $complete_name; if( $wikidata_item && $wikidata_item_data->hasClaimsInProperty('P373') ) { foreach( $wikidata_item_data->getClaimsInProperty('P373') as $claims ) { $personal_category = $claims->getMainSnak()->getDataValue()->getValue(); break; } } $personal_category_prefixed = "Category:$personal_category"; $personal_category_url = commons_page_url( $personal_category_prefixed ); $personal_category_exists = commons_category_exists( $personal_category_prefixed ); if( $personal_category_exists ) { if( ! commons_search_term_in_page_categories( $personal_category_prefixed, 'volleyball' ) ) { if( ! INTERACTION ) { interaction_warning(); continue; } echo "# Is he a volleyball player? [ENTER/n]\n"; echo "# [[$personal_category_prefixed]]\n"; echo "# " . commons_page_url( $personal_category_prefixed ) . "\n"; $no = read(); if( $no === 'n' || $no === 'N' ) { $personal_category .= ' (volleyball player)'; echo "Insert MANUALLY something as '$personal_category':"; $personal_category = read( $personal_category ); $personal_category_prefixed = "Category:$personal_category"; echo "# Input: [[$personal_category_prefixed]]\n"; echo "# " . commons_page_url( $personal_category_prefixed ) . "\n"; $personal_category_exists = commons_category_exists( $personal_category_prefixed ); echo "# Confirm category name."; read(); } } } $italian_category = "Men's volleyball players from Italy"; $italian_category_prefixed = "Category:$italian_category"; $nation = $NATIONS[ $natcode ]; $national_category = $nation->cat; $national_category_prefixed = "Category:$national_category"; $better_national_category_exists = ! empty( trim( $nation->better_cat ) ); if( $better_national_category_exists ) { $better_national_category = $nation->better_cat; $better_national_category_prefixed = "Category:$better_national_category"; $personal_category_has_better_national_category = commons_page_has_categories( $personal_category_prefixed, [ $better_national_category_prefixed ] ); } $file_has_personal_category = commons_page_has_categories( $filename, [ $personal_category_prefixed ] ); $file_has_italian_category = commons_page_has_categories( $filename, [ $italian_category_prefixed ] ); $file_has_iten_templates = commons_page_has_templates( $filename, [ 'Template:En', 'Template:It' ] ); $file_has_template_depicted = commons_page_has_templates( $filename, [ 'Template:Depicted person' ] ); $personal_category_has_national_category = commons_page_has_categories( $personal_category_prefixed, [ $national_category_prefixed ] ); $personal_category_has_wikidata_template = commons_page_has_templates( $personal_category_prefixed, [ 'Template:Wikidata person' ] ); $personal_category_has_best_national_category = $better_national_category_exists ? $personal_category_has_better_national_category : $personal_category_has_national_category; $best_national_category = $better_national_category_exists ? $better_national_category : $national_category; $best_national_category_prefixed = "Category:$best_national_category"; echo "# $name $surname [[$filename_url]]\n"; // Wikidata labels $LABELS = [ 'en' => sprintf( '%s %s', $name, $surname ), 'it' => sprintf( '%s %s', $name, $surname ) ]; $DESCRIPTIONS = [ 'en' => sprintf( '%s volleyball player', $nation->en ), 'it' => sprintf( 'pallavolista %s', $nation->it ) ]; // Wikidata statements $STATEMENTS = [ // Insance of: human legavolley_wikidata_statement_item('P31', 'Q5'), // Image legavolley_wikidata_statement_property_commonsmedia('P18', $filepath), // Commons category legavolley_wikidata_statement_property_string('P373', $personal_category), // Sex: male legavolley_wikidata_statement_item('P21', 'Q6581097'), // Country of citizenship legavolley_wikidata_statement_item('P27', $nation->wd), // Occupation: volleyball player legavolley_wikidata_statement_item('P106', 'Q15117302'), // Sport: volleyball legavolley_wikidata_statement_item('P641', 'Q1734'), // ID LegaVolley legavolley_wikidata_statement_property_string('P4303', $ID) ]; $wikidata_item_new_data = new wb\DataModel(); if( $wikidata_item ) { $summary = WIKIDATA_SUMMARY; // Labels that are not present foreach( $LABELS as $lang => $label ) { if( ! $wikidata_item_data->hasLabelsInLanguage( $lang ) ) { $summary .= "; +label $lang"; $wikidata_item_new_data->setLabel( new wb\LabelAction( $lang, $label, wb\LabelAction::ADD // BUG!!! THIS IS IGNORED SOMETIMES. ) ); } } // Descriptions that are not present foreach( $DESCRIPTIONS as $lang => $description ) { if( ! $wikidata_item_data->hasDescriptionsInLanguage( $lang ) ) { $summary .= "; +description $lang"; $wikidata_item_new_data->setDescription( new wb\DescriptionAction( $lang, $description, wb\DescriptionAction::ADD ) ); } } // Statements that are not present foreach( $STATEMENTS as $statement ) { $property = $statement->getMainsnak()->getProperty(); if( ! $wikidata_item_data->hasClaimsInProperty( $property ) || FORCE_OVERWRITE ) { $summary .= "; +[[P:$property]]"; $wikidata_item_new_data->addClaim( $statement ); } } if( $wikidata_item_new_data->countClaims() ) { echo $wikidata_item_new_data->getJSON( JSON_PRETTY_PRINT ); echo "Confirm existing https://www.wikidata.org/wiki/$wikidata_item\n"; - sleep(1); + read(); // Save existing // https://www.wikidata.org/w/api.php?action=help&modules=wbeditentity $wikidata_api->post( [ 'action' => 'wbeditentity', 'id' => $wikidata_item, 'summary' => $summary, 'token' => $WIKIDATA_CSRF_TOKEN, 'bot' => 1, 'data' => $wikidata_item_new_data->getJSON() ] ); } else { echo "# $wikidata_item OK, skip...\n"; } } else { // Labels foreach( $LABELS as $language => $label ) { $wikidata_item_new_data->setLabel( new wb\Label( $language, $label ) ); } // Descriptions foreach( $DESCRIPTIONS as $lang => $description ) { $wikidata_item_new_data->setDescription( new wb\Description( $lang, $description ) ); } // Claims foreach( $STATEMENTS as $statement ) { $wikidata_item_new_data->addClaim( $statement ); } echo $wikidata_item_new_data->getJSON( JSON_PRETTY_PRINT ); echo "Confirm creation https://www.wikidata.org/w/index.php?search=" . urlencode( $complete_name ); read(); // Create // https://www.wikidata.org/w/api.php?action=help&modules=wbeditentity $result = $wikidata_api->post( [ 'action' => 'wbeditentity', 'new' => 'item', 'summary' => WIKIDATA_SUMMARY, 'token' => $WIKIDATA_CSRF_TOKEN, 'bot' => 1, 'data' => $wikidata_item_new_data->getJSON() ] ); if( ! $result->success ) { var_dump( $result ); die("API error"); } $wikidata_item = $result->entity->id; } echo "$wikidata_item\n"; // Wikitext // https://it.wikipedia.org/w/api.php?action=query&prop=revisions&titles=linux+%28kernel%29&rvprop=content $titles = [ $personal_category_prefixed, $filename ]; $pages = $commons_api->fetch( [ 'action' => 'query', 'prop' => 'revisions', 'titles' => implode( '|', $titles ), 'rvprop' => 'content' ] ); $title_pages = []; foreach( $titles as $title ) { $normalized_title = $title; if( isset( $query->normalized ) ) { foreach( $query->normalized as $normalized ) { if( $normalized->from === $title ) { $normalized_title = $normalized->to; break; } } } $page_content = null; foreach( $pages->query->pages as $page ) { if( $page->title === $normalized_title ) { $page_content = $page->revisions[0]->{'*'}; break; } } $title_pages[ $title ] = $page_content; } $personal_category_content = $title_pages[ $personal_category_prefixed ]; $filename_content = $title_pages[ $filename ]; if( ! $file_has_template_depicted || ! $file_has_personal_category ) { $summary = COMMONS_SUMMARY; $replace = false; $search_and_replace = []; if( ! $file_has_template_depicted ) { $search_and_replace = [ '/{{[ ]*[eE]n *\|.+?}}\n?/' => '', '/{{[ ]*[iI]t *\|.+?}}/' => "{{Depicted person|$wikidata_item}}", "/({{Depicted person\|Q[0-9]+}})\n([a-zA-Z])/" => "\$1
\n\$2" ]; $filename_content = preg_replace( array_keys( $search_and_replace ), array_values( $search_and_replace ), $filename_content ); $summary .= "; +[[Template:Depicted person]] [[d:$wikidata_item]]"; $replace = true; } if( $file_has_italian_category ) { if( $national_category !== $italian_category ) { if( ! $file_has_personal_category ) { $filename_content = preg_replace( '/' . space2regex( $italian_category_prefixed ) . '/', $personal_category_prefixed, $filename_content ); $summary .= "; [[$italian_category_prefixed]] → [[$personal_category_prefixed]]"; $file_has_italian_category = false; $file_has_personal_category = true; $replace = true; } } if( $file_has_italian_category ) { $filename_content = preg_replace( '/\[\[ *' . space2regex( $italian_category_prefixed ) . ' *\]\]\n*/', '', $filename_content ); $summary .= "; -[[$italian_category_prefixed]]"; $replace = true; } } if( ! $file_has_personal_category ) { $filename_content = preg_replace( '/$/', "\n[[$personal_category_prefixed]]", $filename_content ); $summary .= "; +[[$personal_category_prefixed]]"; $replace = true; // Probably it has two very similar categories if( $personal_category !== $complete_name ) { var_dump( $personal_category, $complete_name ); if( 1 === preg_match( '/' . space2regex( $complete_name ) . '/', $complete_name ) ) { $filename_content = preg_replace( '/\[\[ *' . space2regex( "Category:$complete_name" ) . ' *\]\]\n*/', '', $filename_content ); $summary .= "; -[[Category:$complete_name]] (wrong name)"; } } } if( $replace ) { commons_save( $filename, $filename_content, $summary ); } } echo "\n\n"; $summary = COMMONS_SUMMARY; if( $personal_category_exists ) { echo "# [[Category:$personal_category]] [[$personal_category_url]]\n"; // Decides if skip if( $personal_category_has_best_national_category ) { if( $personal_category_has_wikidata_template ) { echo "# It's perfect yet! Skip.\n"; continue; } } if( ! $personal_category_has_wikidata_template ) { $summary .= sprintf("; +[[Template:Wikidata person]] [[d:%s]]", $wikidata_item); $personal_category_content = preg_replace( '/^(?!{{Wikidata person)/', "{{Wikidata person|$wikidata_item}}\n", $personal_category_content ); } if( ! $personal_category_has_best_national_category ) { echo "personal category has not best national_category: '$best_national_category_prefixed'\n"; if( $better_national_category_exists ) { if( $personal_category_has_national_category ) { // National → Best national $summary .= "; better national category"; $personal_category_content = preg_replace( '/' . space2regex( $national_category_prefixed ) . '/', $best_national_category_prefixed, $personal_category_content ); } else { // + Best national $summary .= "; +[[$better_national_category_prefixed]]"; $personal_category_content = preg_replace( '/$/', "\n[[$better_national_category_prefixed]]", $personal_category_content ); } } elseif( ! $personal_category_has_national_category ) { // + National $summary .= "; +[[$national_category_prefixed]]"; $personal_category_content = preg_replace( '/$/', "\n[[$national_category_prefixed]]", $personal_category_content ); } } commons_save( $personal_category_prefixed, $personal_category_content, $summary ); } else { // Create $summary = COMMONS_SUMMARY; $lines = []; $lines[] = sprintf( '{{Wikidata person|%s}}', $wikidata_item ); $summary .= "; +[[Template:Wikidata person]] [[d:$wikidata_item]]"; $lines[] = sprintf( '{{DEFAULTSORT:%s, %s}}', $surname, $name ); $lines[] = "[[$best_national_category_prefixed]]"; $summary .= "; +[[$best_national_category_prefixed]]"; commons_save( $personal_category_prefixed, implode("\n", $lines), $summary ); } if( ONE_SHOT ) { break; } } } if( $missing_natcodes ) { echo "Missing natcodes: "; echo implode("\n", array_unique( $missing_natcodes ) ); } ################# # Commons queries ################# function commons_page_exists( $page_title ) { if( VERBOSE ) { echo "# Does [[$page_title]] exists?\n"; } $pages_exists = mw\APIRequest::factory('https://commons.wikimedia.org/w/api.php', [ 'action' => 'query', 'titles' => $page_title, 'prop' => 'info' ] )->fetch(); foreach( $pages_exists->query->pages as $page_id => $page ) { if( $page_id > 0 ) { return true; } } return false; } function commons_category_exists($category_name) { if( VERBOSE ) { echo "# Does [[$category_name]] exist?\n"; } $category_info = mw\APIRequest::factory('https://commons.wikimedia.org/w/api.php', [ 'action' => 'query', 'prop' => 'categoryinfo', 'titles' => $category_name ] )->fetch(); foreach( $category_info->query->pages as $page_id => $page ) { if( $page_id > 0 ) { return true; } } return false; } function commons_search_term_in_page_categories( $page_title, $search_term ) { if( VERBOSE ) { echo "# Cesarelombrosing [[$page_title]] looking for '$search_term'\n"; } $categories = mw\APIRequest::factory('https://commons.wikimedia.org/w/api.php', [ 'action' => 'query', 'prop' => 'categories', 'clshow' => '!hidden', 'titles' => $page_title ] )->fetch(); foreach( $categories->query->pages as $page ) { foreach( $page->categories as $category ) { $title = strtolower( $category->title ); if( false !== strpos( $title, $search_term ) ) { if( VERBOSE ) { echo "# Matches\n"; } return true; } } } if( VERBOSE ) { echo "# Doesn't match\n"; } return false; } function commons_page_has_categories( $page_title, $categories = [] ) { if( VERBOSE ) { echo "# Does [[$page_title]] have these categories? ([[{$categories[0]}]], ...)\n"; } $results = commons_page_props( $page_title, 'categories', [ 'clcategories' => implode( '|', $categories ) ] ); $status = false; foreach( $results as $result ) { foreach( $result->query->pages as $page ) { if( isset( $page->categories ) ) { $status = count( $page->categories ) === count( $categories ); break; } } } debug_yes_no( $status ); return $status; } function commons_page_has_templates( $page_title, $templates = [] ) { if( VERBOSE ) { echo "# Does [[$page_title]] have these templates? ([[{$templates[0]}]], ...)\n"; } $results = commons_page_props( $page_title, 'templates', [ 'tlnamespace' => 10, 'tltemplates' => implode( '|', $templates ) ] ); $status = false; foreach( $results as $result ) { foreach( $result->query->pages as $page ) { if( isset( $page->templates ) ) { $status = count( $page->templates ) === count( $templates ); break; } } } debug_yes_no( $status ); return $status; } function commons_page_props( $page, $prop, $args = [] ) { - $args = array_merge( [ + $api = \wm\Commons::getInstance()->createQuery( array_merge( [ 'action' => 'query', 'prop' => $prop, - 'titles' => $page - ], $args ); - - $api = mw\APIRequest::factory( 'https://commons.wikimedia.org/w/api.php', $args ); + 'titles' => $page, + ] ) ); $pages = []; - while( $api->hasNext() ) { + foreach( $api->getGenerator() as $page ) { // TODO: callback to obtain the right object? - $pages[] = $api->getNext(); + $pages[] = $page; } return $pages; } ################## # Wikidata queries ################## function search_disperately_wikidata_item( $title ) { echo "# Searching Wikidata item as '$title'\n"; - $wbsearch = mw\APIRequest::factory( 'https://www.wikidata.org/w/api.php', [ + $wbsearch = \wm\Wikidata::getInstance()->fetch( [ 'action' => 'query', 'list' => 'wbsearch', 'wbssearch' => $title, 'wbslanguage' => 'en' - ] )->fetch(); + ] ); $titles = []; foreach( $wbsearch->query->wbsearch as $wbsearch ) { $titles[] = $wbsearch->title; } $titles = filter_volleyball_wikidata_IDs( $titles ); return ask_which( $titles, "Pick Wikidata Item for '$title' volleyball player:", function( $title ) { return "https://www.wikidata.org/wiki/{$title}"; } ); } /** * Giving a list of volleyball player Wikidata IDs, returns which of them has a "volleyball label". */ function filter_volleyball_wikidata_IDs( $wikidata_IDs ) { if( ! $wikidata_IDs ) { return []; } if( VERBOSE ) { echo "# Cesarelombrosing following volleyball players:\n"; foreach( $wikidata_IDs as $wikidata_ID ) { echo "# \t https://www.wikidata.org/wiki/$wikidata_ID \n"; } } $SEARCH_TERMS = [ 'de' => 'volleyball', 'en' => 'volleyball', 'it' => 'pallavol' // pallavolo | pallavolista ]; $languages = array_keys( $SEARCH_TERMS ); // https://www.wikidata.org/w/api.php?action=wbgetentities&props=descriptions&ids=Q19675&languages=en|it - $entities = mw\APIRequest::factory( 'https://www.wikidata.org/w/api.php', [ + $entities = \wm\Wikidata::getInstance()->createQuery( [ 'action' => 'wbgetentities', 'props' => 'descriptions|claims', 'ids' => implode( '|', $wikidata_IDs ), 'languages' => implode( '|', $languages ) ] ); $matching_wikidata_IDs = []; - while( $entities->hasNext() ) { - $entity = $entities->getNext(); + foreach( $entities->getGenerator() as $entity ) { foreach( $entity->entities as $entity_ID => $entity ) { $entity_object = wb\DataModel::createFromObject( $entity ); foreach( $wikidata_IDs as $wikidata_ID ) { if( $wikidata_ID === $entity_ID ) { // Find LegaVolley ID if( $entity_object->hasClaimsInProperty('P4303') ) { if( VERBOSE ) { echo "ID LegaVolley match\n"; } $matching_wikidata_IDs[ $wikidata_ID ] = true; break; } // Find "volleyball" in description foreach( $SEARCH_TERMS as $language => $term ) { if( isset( $entity->descriptions->{ $language } ) ) { $label = $entity->descriptions->{ $language }; if( false !== strpos( $label->value, $term ) ) { if( VERBOSE ) { echo "Wikidata $language label match\n"; } $matching_wikidata_IDs[ $wikidata_ID ] = true; break; } } } // Find an image like "Foo (Legavolley 2017).jpg" $images = $entity_object->getClaimsInProperty('P18'); foreach( $images as $image ) { $image_value = $image->getMainsnak()->getDataValue()->getValue(); if( false !== strpos( $image_value, 'Legavolley' ) ) { if( VERBOSE ) { echo "Image name with 'Legavolley' match\n"; } $matching_wikidata_IDs[ $wikidata_ID ] = true; break; } } } } } } $matching_wikidata_IDs = array_keys( $matching_wikidata_IDs ); if( VERBOSE ) { echo "# Matching:\n"; - foreach($matching_wikidata_IDs as $matching_wikidata_ID) { + foreach( $matching_wikidata_IDs as $matching_wikidata_ID ) { echo "# https://www.wikidata.org/wiki/$wikidata_ID \n"; } if( ! $matching_wikidata_IDs ) { echo "# None :(\n"; } } return $matching_wikidata_IDs; } function fetch_wikidata_item( $page_name ) { // https://commons.wikimedia.org/w/api.php?action=query&prop=wbentityusage&titles=Category:Alberto+Casadei - $wbentityusage = mw\APIRequest::factory( 'https://commons.wikimedia.org/w/api.php', [ + $wbentityusage = \wm\Commons::getInstance()->fetch( [ 'action' => 'query', 'prop' => 'wbentityusage', 'titles' => $page_name - ] )->fetch(); + ] ); // Page not found if( isset( $wbentityusage->query->pages->{-1} ) ) { return false; } foreach( $wbentityusage->query->pages as $page_id => $page ) { if( isset( $page->wbentityusage ) ) { foreach( $page->wbentityusage as $wikidata_id => $aspects ) { // Just the first is enough return $wikidata_id; } } } // Wikidata element not found return null; } function get_wikidata_item( $page_name, $title ) { static $latest; static $latest_title; if( $latest_title === $title ) { return $latest; } $latest_title = $title; $latest = fetch_wikidata_item( $page_name ); if( ! $latest ) { $latest = search_disperately_wikidata_item( $title ); } return $latest; } ############################## # Legavolley referenced claims ############################## function legavolley_wikidata_statement_item( $property, $item ) { $statement = new wb\StatementItem( $property, $item ); return $statement->setReferences( legavolley_references() ); } function legavolley_wikidata_statement_property_string( $property, $string ) { $statement = new wb\StatementString( $property, $string ); return $statement->setReferences( legavolley_references() ); } function legavolley_wikidata_statement_property_commonsmedia( $property, $filename ) { $statement = new wb\StatementCommonsMedia( $property, $filename ); return $statement->setReferences( legavolley_references() ); } function legavolley_references() { $snaks = new wb\Snaks( [ // stated in: Lega Pallavolo Serie A new wb\SnakItem( 'P248', 'Q16571730' ) ] ); return [ [ 'snaks' => $snaks->getAll() ] ]; } ########### # CSV stuff ########### class Nat { var $wd; var $it; var $en; var $cat; var $better_cat; function __construct( $wikidata_id, $it, $en, $cat, $better_cat ) { $this->wd = $wikidata_id; $this->it = $it; $this->en = $en; $this->cat = $cat; $this->better_cat = $better_cat; } } ############ # Mixed shit ############ function read( $default = '' ) { $v = chop( fgets(STDIN) ); return $v ? $v : $default; } function interaction_warning() { echo "# Skipping: it requires interaction\n"; } function commons_page_url($page) { return 'https://commons.wikimedia.org/wiki/' . urlencode( str_replace(' ', '_', $page) ); } function debug_yes_no($v) { if( VERBOSE ) { $yesno = $v ? "yes" : "no"; echo "# $yesno\n"; } } function ask_which($answers, $question, $callback = null) { if( ! $answers ) { return false; } if( 1 === count( $answers ) ) { return array_pop( $answers ); } echo "# $question\n"; $answers = array_values( $answers ); foreach( $answers as $i => $question ) { if( $callback !== null ) { $question = $callback( $question ); } printf("# \t[%s]: %s\n", $i + 1, $question); } if( ! INTERACTION ) { echo "# More than one result\n"; return null; } printf("\t[ENTER]: none\n"); $in = (int) read(); return $in <= 0 ? false : $answers[ $in - 1 ]; } function wiki_save( $api, $csrf, $title, $content, $summary ) { echo "########### Saving [[$title]]: ##########\n"; echo $content; echo "\n"; echo "#########################################\n"; echo "Confirm: |$summary|"; read(); return $api->post( [ 'action' => 'edit', 'title' => $title, 'summary' => $summary, 'text' => $content, 'token' => $csrf, 'bot' => '' ] ); } function commons_save( $title, $content, $summary ) { return wiki_save( $GLOBALS['commons_api'], $GLOBALS['COMMONS_CSRF_TOKEN'], $title, $content, $summary ); } function space2regex( $s ) { return str_replace( ' ', '[_ ]+', escape_regex( $s ) ); } function escape_regex( $s ) { return str_replace( '/', '\/', preg_quote( $s ) ); }