query-48e829fbf624adb429e8a3538a3c152e

rq turtle/ttl

PropertiesDisease Ontology ID (P699)instance of (P31)subclass of (P279)

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 ?language (COUNT (?page) AS ?count) 
WHERE {
   {
  SELECT DISTINCT ?item WHERE {
    { ?item wdt:P699 ?DO_ID .}
    UNION
    { ?item wdt:P31*/wdt:P279* wd:Q11190 }
    UNION  {
      ?item wdt:P31*/wdt:P279* wd:Q12136 .
    }
    UNION {
      ?item wdt:P31*/wdt:P279* wd:Q796194 .
    }
    UNION {
      ?item wdt:P31*/wdt:P279* wd:Q12140 .
    }
  }
  LIMIT 100000
}  ?wikipedia wikibase:wikiGroup "wikipedia".
  ?page     schema:about ?item ;
            schema:isPartOf ?wikipedia .
  ?page schema:inLanguage ?language
}
GROUP BY ?language
ORDER BY DESC(?count)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?DO_ID") v7("?count") v2("?item") v6("?language"):::projected v5("?page"):::projected v4("?wikipedia") a1((" ")) a2((" ")) a3((" ")) a4((" ")) c7(["wd:Q12140"]):::iri c6(["wd:Q796194"]):::iri c4(["wd:Q11190"]):::iri c9(["wikipedia"]):::literal c5(["wd:Q12136"]):::iri 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; subgraph union2[" Union "] subgraph union2l[" "] style union2l fill:#abf,stroke-dasharray: 3 3; subgraph union3[" Union "] subgraph union3l[" "] style union3l fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P31"--> a4 a4 --"wdt:P279"--> c7 end subgraph union3r[" "] style union3r fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P31"--> a3 a3 --"wdt:P279"--> c6 end union3r <== or ==> union3l end end subgraph union2r[" "] style union2r fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P31"--> a2 a2 --"wdt:P279"--> c5 end union2r <== or ==> union2l end end subgraph union1r[" "] style union1r fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P31"--> a1 a1 --"wdt:P279"--> c4 end union1r <== or ==> union1l end end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P699"--> v3 end union0r <== or ==> union0l end v4 --"wikibase:wikiGroup"--> c9 v5 --"schema:about"--> v2 v5 --"schema:isPartOf"--> v4 v5 --"schema:inLanguage"--> v6 bind1[/"count(?page)"/] v5 --o bind1 bind1 --as--o v7