query-32b84937c4933871305551d172251ec6

rq turtle/ttl

"Awesome" people born on Wikidata birthday

Use at

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#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

SELECT ?human ?humanLabel (count(*) as ?count) WHERE {
  ?human wdt:P31 wd:Q5 ;
     wdt:P569 ?date .
  ?thing wdt:P138 ?human .

  FILTER (
    datatype(?date) = xsd:dateTime &&
    month(?date) = 10 &&
    day(?date) = 29
    )

  SERVICE wikibase:label {  bd:serviceParam wikibase:language "en,de,da,no,fr,sv" . }
  }
GROUP BY ?human ?humanLabel
ORDER BY DESC(?count)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?count") v2("?date") v3("?human"):::projected v4("?thing") c11(["en,de,da,no,fr,sv"]):::literal c9(["bd:serviceParam"]):::iri c5(["wd:Q5"]):::iri f0[["?date = 'xsd:dateTime'month-from-dateTime(?date) = '10^^xsd:integer'day-from-dateTime(?date) = '29^^xsd:integer'"]] f0 --> v2 v3 --"wdt:P31"--> c5 v3 --"wdt:P569"--> v2 v4 --"wdt:P138"--> v3 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c9 --"wikibase:language"--> c11 end bind2[/"count(*)"/] bind2 --as--o v5