Commons:Scuola Normale Superiore
Jump to navigation
Jump to search
Presentation
[edit]This partnership has the first scope of improving the image coverage of Scuola Normale Superiore faculty and alumni and its related associations.
Users
[edit]Useful queries
[edit]#Professors with images
SELECT ?prof ?profLabel ?articleIt ?articleEn (URI(CONCAT("https://commons.wikimedia.org/wiki/Category:",?commons) AS ?commonsUrl) ?img
WHERE {
?prof wdt:P108 wd:Q672416 .
?prof wdt:P373 ?commons .
OPTIONAL { ?prof wdt:P18 ?img . }
OPTIONAL { ?articleIt schema:about ?prof .
?articleIt schema:isPartOf <https://it.wikipedia.org/>. }
OPTIONAL { ?articleEn schema:about ?prof .
?articleEn schema:isPartOf <https://en.wikipedia.org/>. }
MINUS { ?prof wdt:P570 ?death . }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],it,en". }
}
#Professors with missing images
SELECT ?prof ?profLabel ?articleIt ?articleEn
WHERE {
?prof wdt:P108 wd:Q672416 .
OPTIONAL { ?articleIt schema:about ?prof .
?articleIt schema:isPartOf <https://it.wikipedia.org/>. }
OPTIONAL { ?articleEn schema:about ?prof .
?articleEn schema:isPartOf <https://en.wikipedia.org/>. }
MINUS { ?prof wdt:P18 ?img . }
MINUS { ?prof wdt:P570 ?death . }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],it,en". }
}