query-cd0abe83007b3ca59ed2ed945b8ae1c0

rq turtle/ttl

Quick query for items with most values of the property P486 after User:Infovarius, 2019-07-15 SELECT ?item ?itemLabel ?cnt { { SELECT ?item (COUNT(?value) AS ?cnt) { ?item wdt:P486 ?value FILTER(STRSTARTS(?value, 'D')) } GROUP BY ?item ORDER BY DESC(?cnt) LIMIT 100 } SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } ORDER BY DESC(?cnt)

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#>
# Quick query for items with most values of the property P486 after User:Infovarius, 2019-07-15
SELECT ?item ?itemLabel ?cnt
{
  {
       SELECT ?item (COUNT(?value) AS ?cnt)
       {
          ?item wdt:P486 ?value
          FILTER(STRSTARTS(?value, 'D'))
       }
       GROUP BY ?item ORDER BY DESC(?cnt) LIMIT 100
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
ORDER BY DESC(?cnt)

Query found at

• https://www.wikidata.org/wiki/Wikidata:ScienceSource_project/MeSH_and_cleanup_dashboard