query-e5930a81ad0e3f6fb33f8e5eac4d538c

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
SELECT ?item (count(?f_items) as ?f) (count(?all_items) as ?total) 
{ 
  {?item wdt:P31 wd:Q12308941 . ?f_items wdt:P21 wd:Q6581072 ; wdt:P735 ?item ; wdt:P31 wd:Q5 } 
 UNION 
  {?item wdt:P31 wd:Q12308941 . ?all_items wdt:P21 [] ; wdt:P735 ?item ; wdt:P31 wd:Q5 }
} 
GROUP BY ?item
HAVING (?f / ?total > 0.95)
ORDER BY DESC(?total) ?item
LIMIT 100

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?all_items"):::projected v6("?f") v4("?f_items"):::projected v2("?item"):::projected v6("?total") a1((" ")) c3(["wd:Q12308941"]):::iri c7(["wd:Q5"]):::iri c5(["wd:Q6581072"]):::iri f0[["?f / ?total > '0.95^^xsd:decimal'"]] f0 --> v6 f0 --> v6 subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P31"--> c3 v5 --"wdt:P21"--> a1 v5 --"wdt:P735"--> v2 v5 --"wdt:P31"--> c7 end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; v2 --"wdt:P31"--> c3 v4 --"wdt:P21"--> c5 v4 --"wdt:P735"--> v2 v4 --"wdt:P31"--> c7 end union0r <== or ==> union0l end bind3[/"count(?f_items)"/] v4 --o bind3 bind3 --as--o v6 bind4[/"count(?all_items)"/] v5 --o bind4 bind4 --as--o v6