query-693df288a67ec71fbad07ce240830e39

rq turtle/ttl

Matematici morti nel 1947 con valore SHARE Cat id e numero di sitelink SELECT ?item ?itemLabel ?dateOfDeath (COUNT(DISTINCT ?sitelink) AS ?sites) WHERE { ?item wdt:P31 wd:Q5. ?item (wdt:P106/wdt:P279*) wd:Q170790. ?item wdt:P3987 ?SHAREid. ?item wdt:P570 ?dateOfDeath. ?sitelink schema:about ?item. SERVICE wikibase:label { bd:serviceParam wikibase:language "en". } FILTER((?dateOfDeath >= "1947-01-01T00:00:00"^^xsd:dateTime) && (?dateOfDeath <= "1947-12-31T23:59:59"^^xsd:dateTime)) } GROUP BY ?item ?itemLabel ?dateOfDeath ORDER BY DESC(?sites)

Use at

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX schema: <http://schema.org/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#Matematici morti nel 1947 con valore SHARE Cat id e numero di sitelink
SELECT ?item ?itemLabel ?dateOfDeath (COUNT(DISTINCT ?sitelink) AS ?sites) WHERE {
  ?item wdt:P31 wd:Q5.
  ?item (wdt:P106/wdt:P279*) wd:Q170790.
  ?item wdt:P3987 ?SHAREid.
  ?item wdt:P570 ?dateOfDeath.
  ?sitelink schema:about ?item.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
  FILTER((?dateOfDeath >= "1947-01-01T00:00:00"^^xsd:dateTime) && (?dateOfDeath <= "1947-12-31T23:59:59"^^xsd:dateTime))
}
GROUP BY ?item ?itemLabel ?dateOfDeath
ORDER BY DESC(?sites)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?SHAREid") v2("?dateOfDeath"):::projected v3("?item"):::projected v5("?sitelink"):::projected v6("?sites") a1((" ")) c7(["wd:Q170790"]):::iri c14(["en"]):::literal c12(["bd:serviceParam"]):::iri c4(["wd:Q5"]):::iri f0[["?dateOfDeath >= '1947-01-01T00:00:00^^xsd:dateTime'?dateOfDeath <= '1947-12-31T23:59:59^^xsd:dateTime'"]] f0 --> v2 v3 --"wdt:P31"--> c4 v3 --"wdt:P106"--> a1 a1 --"wdt:P279"--> c7 v3 --"wdt:P3987"--> v4 v3 --"wdt:P570"--> v2 v5 --"schema:about"--> v3 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c12 --"wikibase:language"--> c14 end bind2[/"count(?sitelink)"/] v5 --o bind2 bind2 --as--o v6