query-8491f90e6ad2b3750f9f7364496f3b02

rq turtle/ttl

Frauen mit Bezug zu Hannover sortiert nach der Anzahl der Verlinkungen

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#>
SELECT ?item ?itemLabel ?itemDescription ?number ?image
WHERE {
   {
  SELECT ?number (COUNT(*) AS ?total) {
    [] wikibase:sitelinks ?number .
  } GROUP BY ?number
}.
  FILTER (?number > 5) .
  ?item wikibase:sitelinks ?number .
  ?item wdt:P31 wd:Q5;
        wdt:P21 wd:Q6581072.
  {?item wdt:P19 wd:Q1715} # Geburtsort
  UNION
  {?item wdt:P20 wd:Q1715} # Sterbeort
  UNION 
  {?item wdt:P937 wd:Q1715} # Wirkungsort 
  OPTIONAL { ?item wdt:P18 ?image. } 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],de,en". }
} ORDER BY DESC(?number)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?image"):::projected v3("?item"):::projected v1("?number"):::projected v2("?total") a1((" ")) c8(["wd:Q1715"]):::iri c6(["wd:Q6581072"]):::iri c13(["bd:serviceParam"]):::iri c4(["wd:Q5"]):::iri c15(["#91;AUTO_LANGUAGE#93;,de,en"]):::literal f0[["?number > '5^^xsd:integer'"]] f0 --> v1 a1 --"wikibase:sitelinks"--> v1 bind2[/"count(*)"/] bind2 --as--o v2 v3 --"wikibase:sitelinks"--> v1 v3 --"wdt:P31"--> c4 v3 --"wdt:P21"--> c6 subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; subgraph union1[" Union "] subgraph union1l[" "] style union1l fill:#abf,stroke-dasharray: 3 3; v3 --"wdt:P937"--> c8 end subgraph union1r[" "] style union1r fill:#abf,stroke-dasharray: 3 3; v3 --"wdt:P20"--> c8 end union1r <== or ==> union1l end end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; v3 --"wdt:P19"--> c8 end union0r <== or ==> union0l end subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v3 -."wdt:P18".-> v4 end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c13 --"wikibase:language"--> c15 end