query-f3914d5aba95f7296d64012152fd8710
Mad melone(P582)end time
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
OPTIONAL {
?player p:P1532 ?represents_statement.
?represents_statement ps:P1532 ?represents.
# Select only truthy statements
?represents_statement wikibase:rank ?represents_rank.
FILTER (?represents_rank = wikibase:PreferredRank ||
?represents_rank = wikibase:NormalRank && NOT EXISTS { ?player p:P1532/wikibase:rank wikibase:PreferredRank. })
# Select only statements without an end time
FILTER NOT EXISTS { ?represents_statement pq:P582 []. }
}