query-94002aa7b8e278d87d91507d8ddfe4c8
This gives 1 result. But:
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 psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT ?item ?date WHERE {
?item wdt:P19 ?pob.
?pob wdt:P131* ?parts.
wd:Q47588 wdt:P527 ?parts.
?item wdt:P31 wd:Q5.
?date_node wikibase:timePrecision "11"^^xsd:integer .
?date_node wikibase:timeValue ?date .
FILTER (year(?date) > 1 && day(?date) = (16) && month(?date) = (11))
?item p:P569/psv:P569 ?date_node .
OPTIONAL {?item wdt:P570 ?dod. BIND(YEAR(?dod) AS ?yod)}
}
ORDER BY DESC(?rank)
LIMIT 2000
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?date"):::projected
v6("?date_node")
v7("?dod")
v3("?item"):::projected
v5("?parts")
v4("?pob")
v1("?rank")
v8("?yod")
a1((" "))
c3(["11^^xsd:integer"]):::literal
c6(["wd:Q47588"]):::iri
c9(["wd:Q5"]):::iri
f0[["year-from-dateTime(?date) > '1^^xsd:integer'day-from-dateTime(?date) = '16^^xsd:integer'month-from-dateTime(?date) = '11^^xsd:integer'"]]
f0 --> v2
v3 --"p:direct/P19"--> v4
v4 --"p:direct/P131"--> v5
c6 --"p:direct/P527"--> v5
v3 --"p:direct/P31"--> c9
v6 --"wikibase:timePrecision"--> c3
v6 --"wikibase:timeValue"--> v2
v3 --"p:P569"--> a1
a1 --"p:statement/value/P569"--> v6
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v3 -."p:direct/P570".-> v7
bind1[/"year-from-dateTime(?dod)"/]
v7 --o bind1
bind1 --as--o v8
end