query-f1680d84b34eb476f61720bbedd49d98

rq turtle/ttl

People with more than one date of deathHello! By tweaking the example query about buildings in more than one country, I got as far as the following but that times out (not necessarily surprising given there are so many humans? But even adding a LIMIT to the inside query does not help)

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#>
SELECT ?item ?itemLabel ?count
WHERE
{
  {
    SELECT ?item (COUNT(DISTINCT ?dob) AS ?count) WHERE {
      ?item wdt:P31 wd:Q5 .
      ?item wdt:P569 ?dob .
    }
    GROUP BY ?item
    LIMIT 10
  }
  FILTER ( ?count > 1 )
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
}
ORDER BY DESC(?count) ?itemL

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2019/03