query-b6426ba5591664f75a6c31f6854be4b8

rq turtle/ttl

V2) 08:55, 4 January 2021 (UTC) talk (Sebastian Wallroth. --Dipsacus fullonum by New version

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 ps: <http://www.wikidata.org/prop/statement/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT DISTINCT ?item ?articlecount
WHERE
{

{
  SELECT ?item
  WHERE
  {
    ?item wdt:P570 ?deathdate .

    FILTER ( ?deathdate < "1947-00-00"^^xsd:date && ?deathdate >= "1946-00-00"^^xsd:date )
  }
}  ?item wikibase:sitelinks ?articlecount .
  ?item p:P106 ?occupationStatement .
  ?occupationStatement ps:P106/wdt:P279* wd:Q2500638 .

  MINUS { ?occupationStatement wikibase:rank wikibase:DeprecatedRank . }
}
ORDER BY DESC (?articlecount)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v1("?articlecount"):::projected v2("?deathdate") v3("?item"):::projected v4("?occupationStatement") a1((" ")) c8(["wd:Q2500638"]):::iri c10(["wikibase:DeprecatedRank"]):::iri f0[["?deathdate < '1947-00-00^^xsd:date'?deathdate >= '1946-00-00^^xsd:date'"]] f0 --> v2 v3 --"p:direct/P570"--> v2 v3 --"wikibase:sitelinks"--> v1 v3 --"p:P106"--> v4 v4 --"p:statement/P106"--> a1 a1 --"p:direct/P279"--> c8 subgraph minus1["MINUS"] style minus1 stroke-width:6px,fill:pink,stroke:red; v4 --"wikibase:rank"--> c10 end