query-251a2187ae938a1a436a2606b38bc9d7
) and thus only one value will be returned with wdt:. Help:Ranking results than before - some items have two images, so they show up twice. DISTINCT prevents exact duplicate lines, but will allow two lines with different data. Ideally, this should not happen very often - for properties like the image, one should be set to "preferred" (see moreCounterintuitively, this may return If you do find these duplicate lines, one way around it is to sample the offending variables to pick a single value, like so:
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 ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?person ?personLabel ?seat ?seatLabel ?party ?partyLabel (SAMPLE(?image) as ?imagesample) WHERE
{
?person wdt:P31 wd:Q5 . ?person p:P39 ?ps .
?ps ps:P39 ?term . ?term wdt:P279 wd:Q16707842 .
?ps pq:P580 ?start . ?ps pq:P4100 ?party . ?ps pq:P768 ?seat .
FILTER NOT EXISTS { ?ps pq:P582 ?end } .
OPTIONAL { ?person wdt:P18 ?image } .
SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
} group by ?person ?personLabel ?seat ?seatLabel ?party ?partyLabel
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?end")
v8("?image"):::projected
v9("?imagesample")
v6("?party"):::projected
v3("?person"):::projected
v1("?ps")
v7("?seat"):::projected
v5("?start")
v4("?term")
c7(["wd:Q16707842"]):::iri
c15(["en"]):::literal
c13(["bd:serviceParam"]):::iri
c3(["wd:Q5"]):::iri
f0[["not "]]
subgraph f0e0["Exists Clause"]
e0v1 --"p:qualifier/P582"--> e0v2
e0v2("?end"):::projected
e0v1("?ps"):::projected
end
f0--EXISTS--> f0e0
f0 --> v1
f0 --> c1
f0 --> v2
v1 --"p:qualifier/P582"--> v2
v3 --"p:direct/P31"--> c3
v3 --"p:P39"--> v1
v1 --"p:statement/P39"--> v4
v4 --"p:direct/P279"--> c7
v1 --"p:qualifier/P580"--> v5
v1 --"p:qualifier/P4100"--> v6
v1 --"p:qualifier/P768"--> v7
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v3 -."p:direct/P18".-> v8
end
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c13 --"wikibase:language"--> c15
end
bind2[/"sample(?image)"/]
v8 --o bind2
bind2 --as--o v9