User:Plagiat/sandbox/sparql pdc oom

query Q24809945: Current PDC Order of Merit

• items
  • Current PDC Order of Merit (Q24809945)
• properties
  • participant (P710)
  • ranking (P1352)
  • prize money (P2121)
  • number of wins (P1355)
  • country for sport (P1532)
• predicates
  • p:P710 entity to statement ?participantS
  • v:P710 value to statement ?participant
  • q:P1352 qualifier value to statement ?ranking

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX q: <http://www.wikidata.org/prop/qualifier/>
PREFIX v: <http://www.wikidata.org/prop/statement/>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX prov: <http://www.w3.org/ns/prov#> 
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>

#query Q24809945: Current PDC Order of Merit
SELECT ?participant ?participantLabel ?ranking ?prize_money ?balance ?team WHERE {
  wd:Q24809945 p:P710 ?participantS.
  ?participantS v:P710 ?participant ;  #name
                q:P1352 ?ranking ;     #ranking
                q:P2121 ?prize_money . #prize money

  OPTIONAL { ?participantS q:P1355 ?balance . } #wins posistions
  
  OPTIONAL { ?participant wdt:P1532 ?_team .
             ?_team rdfs:label ?team filter (lang(?team) = "en") .
  }
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "nl,de,en". }

}
ORDER BY DESC(?prize_money)
LIMIT 100

Try it!