query-483f0f23f46bb3c0f4900e70f82f7183

rq turtle/ttl

: (P569)date of birth and this one for

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?itemDescription ?value ?valueLabel
WHERE
{
    ?item wdt:P650 ?value .
    FILTER NOT EXISTS { ?item wdt:P569 [] } .
    FILTER NOT EXISTS { ?item wdt:P31 wd:Q5 } . 
    FILTER NOT EXISTS {
      SELECT ?item WHERE {
  wd:P650 p:P2302 ?propertyconstraint .
  ?propertyconstraint ps:P2302 wd:Q21503247 .
  ?propertyconstraint pq:P2306 wd:P569 .
  ?propertyconstraint pq:P2303 ?item .
  }
      }
    SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } .
}
LIMIT 1000

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?item"):::projected v1("?propertyconstraint") v3("?value"):::projected a1((" ")) c15(["en"]):::literal c4(["wd:Q21503247"]):::iri c13(["bd:serviceParam"]):::iri c6(["wd:P569"]):::iri c9(["wd:Q5"]):::iri c1(["wd:P650"]):::iri f0[["not "]] subgraph f0e0["Exists Clause"] e0c1 --"p:P2302"--> e0v1 e0v1 --"p:statement/P2302"--> e0c4 e0v1 --"p:qualifier/P2306"--> e0c6 e0v1 --"p:qualifier/P2303"--> e0v2 e0v2("?item"):::projected e0v1("?propertyconstraint") e0c4(["wd:Q21503247"]):::iri e0c6(["wd:P569"]):::iri e0c1(["wd:P650"]):::iri end f0--EXISTS--> f0e0 f0 --> c1 f0 --> c2 f0 --> v1 f0 --> c3 f0 --> c4 f0 --> c5 f0 --> c6 f0 --> c7 f0 --> v2 c1 --"p:P2302"--> v1 v1 --"p:statement/P2302"--> c4 v1 --"p:qualifier/P2306"--> c6 v1 --"p:qualifier/P2303"--> v2 f1[["not "]] subgraph f1e1["Exists Clause"] e1v1 --"p:direct/P31"--> e1c2 e1v1("?item"):::projected e1c2(["wd:Q5"]):::iri end f1--EXISTS--> f1e1 f1 --> v2 f1 --> c8 f1 --> c9 v2 --"p:direct/P31"--> c9 f2[["not "]] subgraph f2e2["Exists Clause"] e2v1 --"p:direct/P569"--> e2a1 e2v1("?item"):::projected e2a1((" ")):::projected end f2--EXISTS--> f2e2 f2 --> v2 f2 --> c10 f2 --> a1 v2 --"p:direct/P569"--> a1 v2 --"p:direct/P650"--> v3 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c13 --"wikibase:language"--> c15 end