query-7e32975aba87623509d02f19e5224862

rq turtle/ttl

TODO

Use at

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/>
SELECT ?item ?dob ?dod ?sitelinks ?lang_wiki_sitelinks WHERE {
  {
    SELECT ?item ?sitelinks (COUNT(?article) AS ?lang_wiki_sitelinks) WHERE {

      ?item wikibase:sitelinks ?sitelinks .  FILTER (?sitelinks > 200)
      ?item wdt:P31 wd:Q5 .
      ?article schema:about ?item ;
        schema:isPartOf / wikibase:wikiGroup "wikipedia" .
    }
    GROUP BY ?item ?sitelinks HAVING (?lang_wiki_sitelinks > 200)
  }
  OPTIONAL { ?item wdt:P569 ?dob }
  OPTIONAL { ?item wdt:P570 ?dod } 
}
ORDER BY DESC(?lang_wiki_sitelinks)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?article") v5("?dob"):::projected v6("?dod"):::projected v3("?item"):::projected v5("?lang_wiki_sitelinks"):::projected v2("?sitelinks"):::projected a1((" ")) c4(["wd:Q5"]):::iri c8(["wikipedia"]):::literal f0[["?lang_wiki_sitelinks > '200^^xsd:integer'"]] f0 --> v5 f1[["?sitelinks > '200^^xsd:integer'"]] f1 --> v2 v3 --"wikibase:sitelinks"--> v2 v3 --"wdt:P31"--> c4 v4 --"schema:about"--> v3 v4 --"schema:isPartOf"--> a1 a1 --"wikibase:wikiGroup"--> c8 bind3[/"count(?article)"/] v4 --o bind3 bind3 --as--o v5 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v3 -."wdt:P569".-> v5 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v3 -."wdt:P570".-> v6 end