Project:SPARQL

This page is a repository of sparql queries that should work efficiently

All items with de number that do not have an arxiv id and do not contain a substring in the description

SELECT ?item ?desc ?denr WHERE {
  ?item wdt:P1451 ?denr . 
 
  ?item schema:description ?desc .
  FILTER(!CONTAINS(?desc, "zbMATH")) .

  OPTIONAL { ?item wdt:P21 ?tmp . }
  FILTER(!BOUND(?tmp))
}

All items that share a de number

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