I thought I was querying fine until I saw the result had some same events appearing a few times. Could anyone explain why?
Query:
PREFIX dbo: <http://dbpedia.org/ontology/>
SELECT ?event ?eventLabel
WHERE
{ ?event a dbo:MilitaryConflict ;
dbo:date ?date .
FILTER ( ?date >= "1918-01-01"^^xsd:date && ?date <= "2018-12-31"^^xsd:date ).
FILTER(LANG(?eventLabel) = "nl").
OPTIONAL { ?event rdfs:label ?eventLabel.}}
Result:
To eliminate duplicate rows --
SELECT ?event ?eventLabel
-- should be made --
SELECT DISTINCT ?event ?eventLabel