query-0b907edba496d2779285e66913ead36e
title:vere fonti (esclusione di wikipedia)
SELECT ?human ?humanLabel ?datan ?refn{
?human wdt:P31 wd:Q5 .
?human wdt:P1986 ?dbi .
?human wdt:P569 ?datan .
?human p:P569 ?dn .
?dn prov:wasDerivedFrom ?ref .
{ ?ref pr:P143 ?wp . } UNION { ?ref pr:P4656 ?urlwp . }
MINUS { ?dn prov:wasDerivedFrom ?truerefsource . ?truerefsource pr:P248 ?source . }
MINUS { ?dn prov:wasDerivedFrom ?truerefurl . ?truerefurl pr:P854 ?url . }
FILTER ("1800-01-01"^^xsd:dateTime < ?datan)
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?itemLabel
Use at
- https://query.wikidata.org/sparql
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
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 pr: <http://www.wikidata.org/prop/reference/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#title:vere fonti (esclusione di wikipedia)
SELECT ?human ?humanLabel ?datan ?refn{
?human wdt:P31 wd:Q5 .
?human wdt:P1986 ?dbi .
?human wdt:P569 ?datan .
?human p:P569 ?dn .
?dn prov:wasDerivedFrom ?ref .
{ ?ref pr:P143 ?wp . } UNION { ?ref pr:P4656 ?urlwp . }
MINUS { ?dn prov:wasDerivedFrom ?truerefsource . ?truerefsource pr:P248 ?source . }
MINUS { ?dn prov:wasDerivedFrom ?truerefurl . ?truerefurl pr:P854 ?url . }
FILTER ("1800-01-01"^^xsd:date < ?datan)
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY ?itemLabel
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?datan"):::projected
v4("?dbi")
v5("?dn")
v3("?human"):::projected
v1("?itemLabel")
v6("?ref")
v10("?source")
v9("?truerefsource")
v11("?truerefurl")
v12("?url")
v8("?urlwp")
v7("?wp")
c13(["bd:serviceParam"]):::iri
c3(["wd:Q5"]):::iri
c15(["#91;AUTO_LANGUAGE#93;,en"]):::literal
f0[["'1800-01-01^^xsd:date' < ?datan"]]
f0 --> v2
v3 --"p:direct/P31"--> c3
v3 --"p:direct/P1986"--> v4
v3 --"p:direct/P569"--> v2
v3 --"p:P569"--> v5
v5 --"prov:wasDerivedFrom"--> v6
subgraph union0[" Union "]
subgraph union0l[" "]
style union0l fill:#abf,stroke-dasharray: 3 3;
v6 --"p:reference/P4656"--> v8
end
subgraph union0r[" "]
style union0r fill:#abf,stroke-dasharray: 3 3;
v6 --"p:reference/P143"--> v7
end
union0r <== or ==> union0l
end
subgraph minus1["MINUS"]
style minus1 stroke-width:6px,fill:pink,stroke:red;
v5 --"prov:wasDerivedFrom"--> v9
v9 --"p:reference/P248"--> v10
end
subgraph minus2["MINUS"]
style minus2 stroke-width:6px,fill:pink,stroke:red;
v5 --"prov:wasDerivedFrom"--> v11
v11 --"p:reference/P854"--> v12
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c13 --"wikibase:language"--> c15
end