query-b18ddc4adb8588dbc1b0fc9740deb3fe

rq turtle/ttl

But it did not helped, probably because it takes in account that ?date is distinct. 00:12, 23 December 2016 (UTC)) talk (BunykWhen I try to use group by aggregation, it gives me "Bad aggregate" error. How to write it properly, so I have distinct films with first release date in filmography? -- Oh, I see, I need to group by ?itemLabel, not ?item.

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 (MAX(?date) AS ?maxdate)
WHERE
{
    ?item wdt:P161 wd:Q193212 .
    ?item wdt:P577 ?date .

    SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}  GROUP BY ?itemLabel

Query found at

• https://www.wikidata.org/wiki/Wikidata:Project_chat/Archive/2016/12