query-3d621f9b214cf1bec861393e4e514478

rq turtle/ttl

title:Items containing date of birth referenced from NKC both as ID and as URL SELECT ?item WHERE { ?item wdt:P691 ?nkc ; p:P569 [ prov:wasDerivedFrom ?ref1, ?ref2 ] . ?ref1 pr:P854 ?url . FILTER(CONTAINS(STR(?url), "aleph.nkp.cz")) ?ref2 pr:P691 ?nkc . }

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:Items containing date of birth referenced from NKC both as ID and as URL
SELECT ?item
WHERE {
  ?item wdt:P691 ?nkc ; p:P569 [ prov:wasDerivedFrom ?ref1, ?ref2 ] .
  ?ref1 pr:P854 ?url . FILTER(CONTAINS(STR(?url), "aleph.nkp.cz"))
  ?ref2 pr:P691 ?nkc .
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?item"):::projected v3("?nkc") v4("?ref1") v5("?ref2") v1("?url") a1((" ")) f0[["contains(str(?url),'aleph.nkp.cz')"]] f0 --> v1 v2 --"p:direct/P691"--> v3 a1 --"prov:wasDerivedFrom"--> v4 a1 --"prov:wasDerivedFrom"--> v5 v2 --"p:P569"--> a1 v4 --"p:reference/P854"--> v1 v5 --"p:reference/P691"--> v3