query-663de2e514b155dfa73c5276cc2456a7
How to select distinct films with release dates in actors filmography?I tried this, but it gives me some film more then one time, because it has different release dates in different countries:
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#>
SELECT ?itemLabel ?date #(MIN(?date) AS ?mindate)
WHERE
{
?item wdt:P161 wd:Q193212 .
?item wdt:P577 ?date .
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}# GROUP BY ?item
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?date"):::projected
v1("?item")
c5(["bd:serviceParam"]):::iri
c2(["wd:Q193212"]):::iri
c7(["en"]):::literal
v1 --"wdt:P161"--> c2
v1 --"wdt:P577"--> v2
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c5 --"wikibase:language"--> c7
end