query-bc2c589e47a009392b10519e9498abbb

rq turtle/ttl

Count of usage examples with and without pronunciation audio

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT
  ?total
  ?with
  ?without
{
   {
  SELECT (COUNT(*) AS ?with) {
    [] p:P5831 [pq:P443 []]
  }
}
   {
  SELECT (COUNT(*) AS ?total) {
    [] wdt:P5831 [].
  }
}
  BIND((?total - ?with) AS ?without)
}

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?total"):::projected v1("?with"):::projected v3("?without"):::projected a3((" ")) a2((" ")) a4((" ")) a1((" ")) a5((" ")) a1 --"p:qualifier/P443"--> a2 a3 --"p:P5831"--> a1 bind1[/"count(*)"/] bind1 --as--o v1 a4 --"p:direct/P5831"--> a5 bind3[/"count(*)"/] bind3 --as--o v2 bind4[/"?total - ?with"/] v2 --o bind4 v1 --o bind4 bind4 --as--o v3