query-58e7d23138e37c7eb14cb7a987e36696

rq turtle/ttl

How much are items about rivers used in Wikidata (one country)

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 bd: <http://www.bigdata.com/rdf#>
#title:How much are items about rivers used in Wikidata: river items used as value (sample country: France)
#defaultView:BarChart
# based on query by https://www.wikidata.org/wiki/User:Tagishsimon , 2022-03-05
SELECT (STR(?claims) as ?no_of_incoming_links) (COUNT(?claims) as ?no_of_rivers) (SAMPLE(?river) as ?sample_river)
WHERE
{

{
  SELECT ?river (count(?item) as ?items) (count(distinct ?item) as ?claims) WHERE {

{
  SELECT distinct ?river WHERE {
    ?river wdt:P31/wdt:P279* wd:Q55659167. 
    ?river wdt:P17 wd:Q142 . # sample country
  } 
}    OPTIONAL { ?item ?predicate ?river .
    ?property wikibase:directClaim ?predicate . } 
    } group by ?river 
}  # SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],fr,en". } 
} 
GROUP BY ?claims 
ORDER BY DESC(?claims)

Query found at

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