query-9e17497c6c86b046ada00cbaa028017c

rq turtle/ttl

Count of forms with and without pronunciation audio for given languages

Use at

• https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ontolex: <http://www.w3.org/ns/lemon/ontolex#>
PREFIX dct: <http://purl.org/dc/terms/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT
  ?language
  ?languageLabel
  ?total
  ?without
  ?with
  ?ratio
{
   {
  SELECT ?language (COUNT(*) AS ?with) {
    {
  SELECT ?language {
    VALUES ?language {
      wd:Q1321
    }
  }
}
    [] dct:language ?language;
       ontolex:lexicalForm [wdt:P443 []]
  }
  GROUP BY ?language
}
   {
  SELECT ?language (COUNT(*) AS ?total) {
     {
  SELECT ?language {
    VALUES ?language {
      wd:Q1321
    }
  }
}
    [] dct:language ?language;
       ontolex:lexicalForm [].
  }
  GROUP BY ?language
}
  BIND((?total - ?with) AS ?without)
  BIND(CONCAT(STR((?with/?total)), " %") AS ?ratio)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
ORDER BY DESC(?without)

Query found at

• https://www.wikidata.org/wiki/User:Rdrg109/1/13