query-186ad3f71f3d1ad1af1904d5f82f7829
TODO
Use at
- https://query.wikidata.org/sparql
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/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?dateOfBirth WHERE {
{
SELECT DISTINCT ?item WHERE {
?item wdt:P27 wd:Q145; wdt:P106 wd:Q82955; p:P569 []; wdt:P31 wd:Q5 .
}
}.
?item p:P569/psv:P569 [ wikibase:timeValue ?dateOfBirth; wikibase:timePrecision ?precision ] .
FILTER(MONTH(?dateOfBirth) = 1 && ?precision >= 10) .
?leapYear wdt:P31 wd:Q19828; wdt:P585 ?pointInTime .
FILTER(YEAR(?dateOfBirth) = YEAR(?pointInTime)) .
SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' }
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?dateOfBirth"):::projected
v4("?item"):::projected
v5("?leapYear")
v2("?pointInTime")
v3("?precision")
a1((" "))
a3((" "))
a2((" "))
c18(["en"]):::literal
c6(["wd:Q82955"]):::iri
c13(["wd:Q19828"]):::iri
c16(["bd:serviceParam"]):::iri
c9(["wd:Q5"]):::iri
c4(["wd:Q145"]):::iri
f0[["year-from-dateTime(?dateOfBirth) = year-from-dateTime(?pointInTime)"]]
f0 --> v1
f0 --> v2
f1[["month-from-dateTime(?dateOfBirth) = '1^^xsd:integer'?precision >= '10^^xsd:integer'"]]
f1 --> v1
f1 --> v3
v4 --"p:direct/P27"--> c4
v4 --"p:direct/P106"--> c6
v4 --"p:P569"--> a1
v4 --"p:direct/P31"--> c9
a2 --"wikibase:timeValue"--> v1
a2 --"wikibase:timePrecision"--> v3
v4 --"p:P569"--> a3
a3 --"p:statement/value/P569"--> a2
v5 --"p:direct/P31"--> c13
v5 --"p:direct/P585"--> v2
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c16 --"wikibase:language"--> c18
end