query-d31338d0e68611c5fa628ee679cbb22b
title:A birth date referenced only from Wikimedia projects SELECT ?item (COUNT(?ref) AS ?n) WHERE { ?item wdt:P1986 ?dbi ; p:P569 ?st . ?st prov:wasDerivedFrom ?ref, ?ref2 . ?ref2 pr:P143 [] . } GROUP BY ?item HAVING(?n = 1)
Use at
- https://query.wikidata.org/sparql
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/>
#title:A birth date referenced only from Wikimedia projects
SELECT ?item (COUNT(?ref) AS ?n)
WHERE {
?item wdt:P1986 ?dbi ; p:P569 ?st .
?st prov:wasDerivedFrom ?ref, ?ref2 . ?ref2 pr:P143 [] .
}
GROUP BY ?item
HAVING(?n = 1)
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;
v3("?dbi")
v2("?item"):::projected
v7("?n")
v5("?ref"):::projected
v6("?ref2")
v4("?st")
a1((" "))
f0[["?n = '1^^xsd:integer'"]]
f0 --> v7
v2 --"p:direct/P1986"--> v3
v2 --"p:P569"--> v4
v4 --"prov:wasDerivedFrom"--> v5
v4 --"prov:wasDerivedFrom"--> v6
v6 --"p:reference/P143"--> a1
bind2[/"count(?ref)"/]
v5 --o bind2
bind2 --as--o v7