query-13f004e696c1cfefead6c92dab9951f4

rq turtle/ttl

Characters with the most appearances SELECT ?value ?valueLabel ?ct ?sampleitem ?sampleitemLabel WHERE { { SELECT ?value (count(*) as ?ct) (SAMPLE(?item) as ?sampleitem) WHERE { ?item wdt:P674 ?value } GROUP BY ?value ORDER BY DESC(?ct) } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } } ORDER BY DESC(?ct) ASC(?value)

Use at

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

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX bd: <http://www.bigdata.com/rdf#>
# Characters with the most appearances
SELECT ?value ?valueLabel ?ct ?sampleitem ?sampleitemLabel
WHERE
{
  {
    SELECT ?value (count(*) as ?ct) (SAMPLE(?item) as ?sampleitem)
    WHERE
    {
      ?item wdt:P674 ?value
    }
    GROUP BY ?value
    ORDER BY DESC(?ct)
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
ORDER BY DESC(?ct) ASC(?value)

Query found at

• https://www.wikidata.org/wiki/Wikidata:WikiProject_Star_Trek/Characters