query-5394926e6bbe4f93af81a090a4d164aa

rq turtle/ttl

Finding items with duplicate valuesI tried to find duplicate property values, i.e. cases where an item has two different statements for the same property with the same value:

Use at

• https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
SELECT DISTINCT ?item
WHERE {
  ?item ?claim ?statement1, ?statement2 FILTER(?statement1 != ?statement2).
  ?property wikibase:claim ?claim;
            wikibase:statementProperty ?statement.
  ?statement1 ?statement ?value.
  ?statement2 ?statement ?value.
}

Query found at

• https://www.wikidata.org/wiki/Wikidata:Request_a_query/Archive/2022/10