Project:SPARQL: Difference between revisions

From MaRDI portal
No edit summary
No edit summary
 
Line 1: Line 1:
This page is a repository of sparql queries that should work efficiently
This page is a repository of sparql queries that should work efficiently


=== All items with de number that do not contain a substring in the description ===
=== All items with de number that do not have an arxiv id and do not contain a substring in the description ===
<syntaxhighlight lang="sparql">
<syntaxhighlight lang="sparql">
SELECT ?item ?desc WHERE {
SELECT ?item ?desc ?denr WHERE {
   ?item wdt:P1451 [] .
   ?item wdt:P1451 ?denr .  
 
   ?item schema:description ?desc .
   ?item schema:description ?desc .
   FILTER(!CONTAINS(?desc, "zbMATH")) .
   FILTER(!CONTAINS(?desc, "zbMATH")) .
  OPTIONAL { ?item wdt:P21 ?tmp . }
  FILTER(!BOUND(?tmp))
}
}
</syntaxhighlight>
</syntaxhighlight>

Latest revision as of 10:54, 2 June 2025

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))
}