query-0af5b0aa79ea2c8617f92292be777a77

rq turtle/ttl

title:Lista degli identificativi (con codice VIAF, per i membri VIAF) connessi ad allievi SAIA SELECT ?id ?idLabel (COUNT(?idst) AS ?n) ?codice_viaf WHERE { ?person wdt:P69 wd:Q1576779 . ?person ?idst ?idv . ?id wikibase:directClaim ?idst . ?id wikibase:propertyType wikibase:ExternalId . OPTIONAL { ?id p:P1552 [ ps:P1552 wd:Q26921380 ; pq:P3295 ?codice_viaf ] . } SERVICE wikibase:label { bd:serviceParam wikibase:language "it". } } GROUP BY ?id ?idLabel ?n ?codice_viaf ORDER BY DESC(?n)

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title:Lista degli identificativi (con codice VIAF, per i membri VIAF) connessi ad allievi SAIA
SELECT ?id ?idLabel (COUNT(?idst) AS ?n) ?codice_viaf
WHERE {
  ?person wdt:P69 wd:Q1576779 .
  ?person ?idst ?idv .
  ?id wikibase:directClaim ?idst .
  ?id wikibase:propertyType wikibase:ExternalId .
  OPTIONAL { ?id p:P1552 [ ps:P1552 wd:Q26921380 ; pq:P3295 ?codice_viaf ] . }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "it". }
}
GROUP BY ?id ?idLabel ?n ?codice_viaf
ORDER BY DESC(?n)

Query found at