query-fcdd1e5f83dfbf121ecfdcff06564c9c
Propertiesinstance of (P31)position held (P39)date of birth (P569)
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 ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?item ?itemLabel ?dob ?sign
{
?item wdt:P31 wd:Q5 ; p:P39 ?ps . ?ps ps:P39 ?term .
?term wdt:P39* wd:Q274948 . # all Japanese Prime Ministers
?positionStatement ps:P39 wd:Q274948 .
?item p:P569/psv:P569 [ # with a known birthday
wikibase:timeValue ?dob;
wikibase:timePrecision 11 # of “day” precision
].
BIND( IF(MONTH(?dob) = 3&& DAY(?dob) >=21, "Aries" ,
IF(MONTH(?dob) = 4&& DAY(?dob) < 20, "Aries" ,
IF(MONTH(?dob) = 4&& DAY(?dob) >=20, "Taurus" ,
IF(MONTH(?dob) = 5&& DAY(?dob) < 21, "Taurus" ,
IF(MONTH(?dob) = 5&& DAY(?dob) >=21, "Gemini" ,
IF(MONTH(?dob) = 6&& DAY(?dob) < 21, "Gemini" ,
IF(MONTH(?dob) = 6&& DAY(?dob) >=21, "Cancer" ,
IF(MONTH(?dob) = 7&& DAY(?dob) < 23, "Cancer" ,
IF(MONTH(?dob) = 7&& DAY(?dob) >=23, "Leo" ,
IF(MONTH(?dob) = 8&& DAY(?dob) < 23, "Leo" ,
IF(MONTH(?dob) = 8&& DAY(?dob) >=23, "Virgo" ,
IF(MONTH(?dob) = 9&& DAY(?dob) < 23, "Virgo" ,
IF(MONTH(?dob) = 9&& DAY(?dob) >=23, "Libra" ,
IF(MONTH(?dob) = 10&& DAY(?dob) < 23, "Libra" ,
IF(MONTH(?dob) = 10&& DAY(?dob) >=23, "Scorpio" ,
IF(MONTH(?dob) = 11&& DAY(?dob) < 22, "Scorpio" ,
IF(MONTH(?dob) = 11&& DAY(?dob) >=23, "Sagittarius" ,
IF(MONTH(?dob) = 12&& DAY(?dob) < 22, "Sagittarius" ,
IF(MONTH(?dob) = 12&& DAY(?dob) >=22, "Capricorn" ,
IF(MONTH(?dob) = 1&& DAY(?dob) < 20, "Capricorn" ,
IF(MONTH(?dob) = 1&& DAY(?dob) >=20, "Aquarius" ,
IF(MONTH(?dob) = 2&& DAY(?dob) < 19, "Aquarius" ,
IF(MONTH(?dob) = 2&& DAY(?dob) >=19, "Pisces" ,
IF(MONTH(?dob) = 3&& DAY(?dob) < 21, "Pisces" ,
"unknown (this should never happen)"
))))))))))))))))))))))))
AS ?sign)
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;
v5("?dob"):::projected
v1("?item"):::projected
v4("?positionStatement")
v2("?ps")
v6("?sign"):::projected
v3("?term")
a2((" "))
a1((" "))
c9(["11^^xsd:integer"]):::literal
c15(["en"]):::literal
c13(["bd:serviceParam"]):::iri
c2(["wd:Q5"]):::iri
c6(["wd:Q274948"]):::iri
v1 --"p:direct/P31"--> c2
v1 --"p:P39"--> v2
v2 --"p:statement/P39"--> v3
v3 --"p:direct/P39"--> c6
v4 --"p:statement/P39"--> c6
a1 --"wikibase:timeValue"--> v5
a1 --"wikibase:timePrecision"--> c9
v1 --"p:P569"--> a2
a2 --"p:statement/value/P569"--> a1
bind0[/"if(month-from-dateTime(?dob) = '3^^xsd:integer'day-from-dateTime(?dob) >= '21^^xsd:integer','Aries',if(month-from-dateTime(?dob) = '4^^xsd:integer'day-from-dateTime(?dob) < '20^^xsd:integer','Aries',if(month-from-dateTime(?dob) = '4^^xsd:integer'day-from-dateTime(?dob) >= '20^^xsd:integer','Taurus',if(month-from-dateTime(?dob) = '5^^xsd:integer'day-from-dateTime(?dob) < '21^^xsd:integer','Taurus',if(month-from-dateTime(?dob) = '5^^xsd:integer'day-from-dateTime(?dob) >= '21^^xsd:integer','Gemini',if(month-from-dateTime(?dob) = '6^^xsd:integer'day-from-dateTime(?dob) < '21^^xsd:integer','Gemini',if(month-from-dateTime(?dob) = '6^^xsd:integer'day-from-dateTime(?dob) >= '21^^xsd:integer','Cancer',if(month-from-dateTime(?dob) = '7^^xsd:integer'day-from-dateTime(?dob) < '23^^xsd:integer','Cancer',if(month-from-dateTime(?dob) = '7^^xsd:integer'day-from-dateTime(?dob) >= '23^^xsd:integer','Leo',if(month-from-dateTime(?dob) = '8^^xsd:integer'day-from-dateTime(?dob) < '23^^xsd:integer','Leo',if(month-from-dateTime(?dob) = '8^^xsd:integer'day-from-dateTime(?dob) >= '23^^xsd:integer','Virgo',if(month-from-dateTime(?dob) = '9^^xsd:integer'day-from-dateTime(?dob) < '23^^xsd:integer','Virgo',if(month-from-dateTime(?dob) = '9^^xsd:integer'day-from-dateTime(?dob) >= '23^^xsd:integer','Libra',if(month-from-dateTime(?dob) = '10^^xsd:integer'day-from-dateTime(?dob) < '23^^xsd:integer','Libra',if(month-from-dateTime(?dob) = '10^^xsd:integer'day-from-dateTime(?dob) >= '23^^xsd:integer','Scorpio',if(month-from-dateTime(?dob) = '11^^xsd:integer'day-from-dateTime(?dob) < '22^^xsd:integer','Scorpio',if(month-from-dateTime(?dob) = '11^^xsd:integer'day-from-dateTime(?dob) >= '23^^xsd:integer','Sagittarius',if(month-from-dateTime(?dob) = '12^^xsd:integer'day-from-dateTime(?dob) < '22^^xsd:integer','Sagittarius',if(month-from-dateTime(?dob) = '12^^xsd:integer'day-from-dateTime(?dob) >= '22^^xsd:integer','Capricorn',if(month-from-dateTime(?dob) = '1^^xsd:integer'day-from-dateTime(?dob) < '20^^xsd:integer','Capricorn',if(month-from-dateTime(?dob) = '1^^xsd:integer'day-from-dateTime(?dob) >= '20^^xsd:integer','Aquarius',if(month-from-dateTime(?dob) = '2^^xsd:integer'day-from-dateTime(?dob) < '19^^xsd:integer','Aquarius',if(month-from-dateTime(?dob) = '2^^xsd:integer'day-from-dateTime(?dob) >= '19^^xsd:integer','Pisces',if(month-from-dateTime(?dob) = '3^^xsd:integer'day-from-dateTime(?dob) < '21^^xsd:integer','Pisces','unknown (this should never happen)'))))))))))))))))))))))))"/]
v5 --o bind0
bind0 --as--o v6
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c13 --"wikibase:language"--> c15
end