query-39a9a4c50613dd0623227d79aa332885

rq turtle/ttl

]reply[10:33, 15 May 2020 (UTC) dosisEpìLascio come promemoria :) --Questa individua gli elementi con "vich" nell'etichetta:

Use at

https://query.wikidata.org/sparql

PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT ?item ?en_label
WHERE {
  ?item p:P214 [ps:P214 ?viaf ; prov:wasDerivedFrom [pr:P248 wd:Q3294867] ] ;
        rdfs:label ?en_label .
  FILTER(LANG(?en_label) = "en") .
  FILTER(CONTAINS(?en_label,"vich"))
}
ORDER BY ?en_label

Query found at

https://www.wikidata.org/wiki/User_talk:Bargioni

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?en_label"):::projected v3("?item"):::projected v2("?viaf") a1((" ")) a2((" ")) c5(["wd:Q3294867"]):::iri f0[["contains(?en_label,'vich')"]] f0 --> v1 f1[["?en_label = 'en'"]] f1 --> v1 a1 --"p:statement/P214"--> v2 a2 --"p:reference/P248"--> c5 a1 --"prov:wasDerivedFrom"--> a2 v3 --"p:P214"--> a1 v3 --"rdfs:label"--> v1