query-4d6635bb934f7fe7dacb5b575a167aa9

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
SELECT ?item (count(?m_items) as ?m) (count(?all_items) as ?total) 
{ 
  {?item wdt:P31 wd:Q11879590 . ?m_items wdt:P21 wd:Q6581097 ; wdt:P735 ?item ; wdt:P31 wd:Q5 } 
 UNION 
  {?item wdt:P31 wd:Q11879590 . ?all_items wdt:P21 [] ; wdt:P735 ?item ; wdt:P31 wd:Q5 }
} 
GROUP BY ?item
HAVING (?m / ?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 v2("?item"):::projected v6("?m") v4("?m_items"):::projected v6("?total") a1((" ")) c3(["wd:Q11879590"]):::iri c5(["wd:Q6581097"]):::iri c7(["wd:Q5"]):::iri f0[["?m / ?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(?m_items)"/] v4 --o bind3 bind3 --as--o v6 bind4[/"count(?all_items)"/] v5 --o bind4 bind4 --as--o v6