Fnielsen created this task. Fnielsen added a subscriber: Fnielsen. Fnielsen added a project: Wikidata. Herald added a subscriber: Aklapper.
TASK DESCRIPTION I am getting duplicate rows on a specific SPARQL query with query.wikidata.org. The duplicates seem to arise when a value has been edited in the references. Besides a BlazeGraph issue this could be my misunderstanding of SPARQL. For a query that has the issue see: https://www.mediawiki.org/wiki/Talk:Wikidata_query_service and the below: PREFIX wikibase: <http://wikiba.se/ontology#> PREFIX wd: <http://www.wikidata.org/entity/> PREFIX wdt: <http://www.wikidata.org/prop/direct/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix pr: <http://www.wikidata.org/prop/reference/> PREFIX wd: <http://www.wikidata.org/entity/> PREFIX wdt: <http://www.wikidata.org/prop/direct/> PREFIX wikibase: <http://wikiba.se/ontology#> PREFIX p: <http://www.wikidata.org/prop/> PREFIX v: <http://www.wikidata.org/prop/statement/> PREFIX q: <http://www.wikidata.org/prop/qualifier/> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX prov: <http://www.w3.org/ns/prov#> SELECT ?work ?workLabel ?author ?authorLabel ?genre ?location ?locationLabel ?geo ?location_statement ?citat WHERE { ?work wdt:P31/wdt:P279* wd:Q386724 . ?work wdt:P50 ?author . ?work p:P840 ?location_statement . ?location_statement v:P840 ?location . ?location wdt:P17 wd:Q35 . ?location wdt:P625 ?geo . OPTIONAL { ?location_statement prov:wasDerivedFrom ?ref . ?ref pr:P1683 ?citat . } SERVICE wikibase:label { bd:serviceParam wikibase:language "da,en" . } } TASK DETAIL https://phabricator.wikimedia.org/T116622 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Fnielsen Cc: Fnielsen, Aklapper, Wikidata-bugs, aude _______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs