query-e9cbd59646df5bd21c14ab1e4433621b

rq turtle/ttl

diferents valors del qualif P1480 i en quants items/statements es fa servir

SELECT ?P1480value ?P1480valueLabel ?items ?statements WHERE { { SELECT ?P1480value (COUNT(DISTINCT(?item)) as ?items) (COUNT(?value) as ?statements) WHERE { ?prop pq:P1480 ?P1480value . hint:Query hint:optimizer "None" . ?item ?p ?prop . ?property wikibase:claim ?p . ?property wikibase:statementProperty ?ps . ?prop ?ps ?value . } GROUP BY ?P1480value ORDER BY DESC(?items) DESC(?statements) LIMIT 100 } SERVICE wikibase:label { bd:serviceParam wikibase:language "ca,en" } } ORDER BY DESC(?items) DESC(?statements)

Use at

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

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#diferents valors del qualif P1480 i en quants items/statements es fa servir

SELECT ?P1480value ?P1480valueLabel ?items ?statements
WHERE
{
  {
    SELECT ?P1480value (COUNT(DISTINCT(?item)) as ?items) (COUNT(?value) as ?statements)
    WHERE
    {
        ?prop pq:P1480 ?P1480value .

      ?item ?p ?prop .
      ?property wikibase:claim ?p .
        ?property wikibase:statementProperty ?ps .
        ?prop ?ps ?value .
    }
    GROUP BY ?P1480value
    ORDER BY DESC(?items) DESC(?statements)
    LIMIT 100
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "ca,en"  }
}
ORDER BY DESC(?items) DESC(?statements)

Query found at

• https://www.wikidata.org/wiki/User:Amadalvarez/Queries