Project:Zbmath id deduplication

SPARQL queries

Find all items that have more than one zbmath de number

SELECT ?item (COUNT(?value) AS ?valueCount) (GROUP_CONCAT(?value; separator=",") AS ?values)
WHERE {
  ?item wdt:P1451 ?value.
}
GROUP BY ?item
HAVING (COUNT(?value) > 1)

Find all items that have more than one zbmath de number and check if other items have the same one

SELECT ?item ?value ?otherItem
WHERE {
  {
    SELECT ?item
    WHERE {
      ?item wdt:P1451 ?value.
    }
    GROUP BY ?item
    HAVING (COUNT(?value) > 1)
  }
  ?item wdt:P1451 ?value.
  OPTIONAL {
    ?otherItem wdt:P1451 ?value.
    FILTER (?otherItem != ?item)
  }
}