query-763cbc92bbe59f39c3ed8e331962e8dc
Classical scholars born or dead today SELECT ?person ?personLabel ?personDescription (YEAR(?dateBirth) as ?yearBirth) (YEAR(?dateDeath) as ?yearDeath) WHERE { { ?person wdt:P106 wd:Q2468727 . } UNION { ?person wdt:P106 ?occ . ?occ wdt:P279 wd:Q2468727 } { ?person wdt:P569 ?dateBirth . BIND(MONTH(NOW()) AS ?nowMonthBirth) BIND(DAY(NOW()) AS ?nowDayBirth) FILTER (MONTH(?dateBirth) = ?nowMonthBirth && DAY(?dateBirth) = ?nowDayBirth) } UNION { ?person wdt:P570 ?dateDeath . BIND(MONTH(NOW()) AS ?nowMonthDeath) BIND(DAY(NOW()) AS ?nowDayDeath) FILTER (MONTH(?dateDeath) = ?nowMonthDeath && DAY(?dateDeath) = ?nowDayDeath) } SERVICE wikibase:label { bd:serviceParam wikibase:language "en,[AUTO_LANGUAGE]". } } ORDER BY ?yearDeath ?yearBirth
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 bd: <http://www.bigdata.com/rdf#>
# Classical scholars born or dead today
SELECT ?person ?personLabel ?personDescription (YEAR(?dateBirth) as ?yearBirth) (YEAR(?dateDeath) as ?yearDeath)
WHERE {
{ ?person wdt:P106 wd:Q2468727 . } UNION { ?person wdt:P106 ?occ . ?occ wdt:P279 wd:Q2468727 }
{ ?person wdt:P569 ?dateBirth .
BIND(MONTH(NOW()) AS ?nowMonthBirth)
BIND(DAY(NOW()) AS ?nowDayBirth)
FILTER (MONTH(?dateBirth) = ?nowMonthBirth && DAY(?dateBirth) = ?nowDayBirth) }
UNION { ?person wdt:P570 ?dateDeath .
BIND(MONTH(NOW()) AS ?nowMonthDeath)
BIND(DAY(NOW()) AS ?nowDayDeath)
FILTER (MONTH(?dateDeath) = ?nowMonthDeath && DAY(?dateDeath) = ?nowDayDeath) }
SERVICE wikibase:label { bd:serviceParam wikibase:language "en,[AUTO_LANGUAGE]". }
}
ORDER BY ?yearDeath ?yearBirth