query-650e74406af224db3af302dd22b1b8f1

rq turtle/ttl

, which gives you further insight into my frail grip on aggregation.(COUNT(DISTINCT ?river) ... or (COUNT(?river) ... or (COUNT(?count_linked_items) ...But if I now try to count how many rivers have particular counts of incoming links, I get batshit insane numbers - there's now one instance of a river with 648 incoming links. It doesn't seem to make any difference whether I 19:02, 4 March 2022 (UTC) JuraPlenty of places could be located on a given river and plenty of bridges (and roads?) could cross a river. --- What numbers are you looking for?

Use at

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

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?property ?propertyLabel ?count ?sample ?sampleLabel
WHERE
{

{
  SELECT ?property (count(distinct ?bla) as ?count) (SAMPLE(?bla) as ?sample)
  {
    ?bla ?predicate wd:Q19721  .
    ?property wikibase:directClaim ?predicate . 
  }
  group by ?property 
}  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } 
} 
ORDER BY DESC(?count)

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2022/03