query-5f0524fb84bef511e240f267bff7d412
title:Some items containing date of birth referenced from two URLs wrongly in the same reference SELECT DISTINCT ?item ?itemLabel ?itemDescription WHERE { ?item wdt:P396 [] ; p:P569 [ prov:wasDerivedFrom [ pr:P854 ?u1, ?u2 ] ] . FILTER(?u1 != ?u2) MINUS { ?item wdt:P106 ?occupazione } . SERVICE wikibase:label { bd:serviceParam wikibase:language "it,en". } } ORDER BY ?itemLabel
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
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:Some items containing date of birth referenced from two URLs wrongly in the same reference
SELECT DISTINCT ?item ?itemLabel ?itemDescription
WHERE {
?item wdt:P396 [] ; p:P569 [ prov:wasDerivedFrom [ pr:P854 ?u1, ?u2 ] ] . FILTER(?u1 != ?u2)
MINUS { ?item wdt:P106 ?occupazione } .
SERVICE wikibase:label { bd:serviceParam wikibase:language "it,en". }
}
ORDER BY ?itemLabel
Query found at
- https://www.wikidata.org/wiki/User:Ep%C3%ACdosis/Queries
- https://www.wikidata.org/wiki/User:Ep%C3%ACdosis/sandbox
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v4("?item"):::projected
v1("?itemLabel"):::projected
v5("?occupazione")
v2("?u1")
v3("?u2")
a1((" "))
a3((" "))
a2((" "))
c7(["bd:serviceParam"]):::iri
c9(["it,en"]):::literal
f0[["?u1 != ?u2"]]
f0 --> v2
f0 --> v3
v4 --"p:direct/P396"--> a1
a2 --"p:reference/P854"--> v2
a2 --"p:reference/P854"--> v3
a3 --"prov:wasDerivedFrom"--> a2
v4 --"p:P569"--> a3
subgraph minus1["MINUS"]
style minus1 stroke-width:6px,fill:pink,stroke:red;
v4 --"p:direct/P106"--> v5
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c7 --"wikibase:language"--> c9
end