query-28b5f655b346ff4136f6855017b0ccfe
cellers de gel sense referència SELECT DISTINCT ?item ?itemLabel ?ref WHERE { ?item wdt:P17 wd:Q29. ?item wdt:P131* ?mun. ?mun wdt:P4335 ?idescat. ?item wdt:P31 wd:Q3666499. ?item p:P31 ?st31. MINUS { ?st31 prov:wasDerivedFrom ?ref. } SERVICE wikibase:label { bd:serviceParam wikibase:language "ca" } }
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
# cellers de gel sense referència
SELECT DISTINCT ?item ?itemLabel ?ref
WHERE {
?item wdt:P17 wd:Q29.
?item wdt:P131* ?mun.
?mun wdt:P4335 ?idescat.
?item wdt:P31 wd:Q3666499.
?item p:P31 ?st31.
MINUS {
?st31 prov:wasDerivedFrom ?ref.
}
SERVICE wikibase:label { bd:serviceParam wikibase:language "ca" }
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v3("?idescat")
v1("?item"):::projected
v2("?mun")
v5("?ref"):::projected
v4("?st31")
c2(["wd:Q29"]):::iri
c10(["bd:serviceParam"]):::iri
c6(["wd:Q3666499"]):::iri
c12(["ca"]):::literal
v1 --"p:direct/P17"--> c2
v1 --"p:direct/P131"--> v2
v2 --"p:direct/P4335"--> v3
v1 --"p:direct/P31"--> c6
v1 --"p:P31"--> v4
subgraph minus0["MINUS"]
style minus0 stroke-width:6px,fill:pink,stroke:red;
v4 --"prov:wasDerivedFrom"--> v5
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c10 --"wikibase:language"--> c12
end