query-ce638d96cbd84af6c4d7ca376267eeb3

rq turtle/ttl

Propertiesinstance of (P31)

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 ?itemLabel ?property ?propertyLabel ?claim WHERE {
  VALUES ?COVID { wd:Q81068910 wd:Q84263196 wd:Q82069695 } 
  { ?COVID ?predicate1 ?item . }
  UNION
  { ?item ?predicate2 ?COVID . } 
  FILTER NOT EXISTS {?item wdt:P31 wd:Q5 . }
  FILTER NOT EXISTS {?item wdt:P31 wd:Q13442814 . }
}  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("?COVID") v9("?count") v2("?item") v8("?language"):::projected v7("?page"):::projected v4("?predicate1") v5("?predicate2") v6("?wikipedia") c2(["wd:Q13442814"]):::iri c3(["wd:Q5"]):::iri c5(["wikipedia"]):::literal f0[["not "]] subgraph f0e0["Exists Clause"] e0v1 --"wdt:P31"--> e0c2 e0v1("?item"):::projected e0c2(["wd:Q13442814"]):::iri end f0--EXISTS--> f0e0 f0 --> v2 f0 --> c1 f0 --> c2 v2 --"wdt:P31"--> c2 f1[["not "]] subgraph f1e1["Exists Clause"] e1v1 --"wdt:P31"--> e1c2 e1v1("?item"):::projected e1c2(["wd:Q5"]):::iri end f1--EXISTS--> f1e1 f1 --> v2 f1 --> c1 f1 --> c3 v2 --"wdt:P31"--> c3 bind2[/VALUES ?COVID/] bind2-->v3 bind20(["wd:Q81068910"]) bind20 --> bind2 bind21(["wd:Q84263196"]) bind21 --> bind2 bind22(["wd:Q82069695"]) bind22 --> bind2 subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; v2 -->v5--> v3 end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; v3 -->v4--> v2 end union0r <== or ==> union0l end v6 --"wikibase:wikiGroup"--> c5 v7 --"schema:about"--> v2 v7 --"schema:isPartOf"--> v6 v7 --"schema:inLanguage"--> v8 bind4[/"count(?page)"/] v7 --o bind4 bind4 --as--o v9