Project:DMV-Talk: Difference between revisions

From MaRDI portal
No edit summary
Line 44: Line 44:
PREFIX wd: <https://portal.mardi4nfdi.de/entity/>
PREFIX wd: <https://portal.mardi4nfdi.de/entity/>


SELECT ?item (COUNT(*) as ?cnt)  
SELECT ?item (COUNT(*) as ?cnt) (GROUP_CONCAT(?authorLabel;separator="; ") as ?authors)  
WHERE { ?item wdt:P31 wd:Q56887 ; wdt:P226 "14E30" ; wdt:P16 ?author}
WHERE { ?item wdt:P31 wd:Q56887 ; wdt:P226 "14E30" ; wdt:P16 ?author.
      SERVICE wikibase:label { bd:serviceParam wikibase:language "en".
                            ?author rdfs:label ?authorLabel .}}
GROUP by ?item
GROUP by ?item
ORDER by DESC(?cnt)
ORDER by DESC(?cnt)
LIMIT 5
LIMIT 5
}}
}}

Revision as of 14:11, 24 September 2023

CRAN Packages

PREFIX wdt: <https://portal.mardi4nfdi.de/prop/direct/>
SELECT ?item ?name
WHERE {
  ?item wdt:P229 ?name
}
Try it!
  • Cran packages with publications
PREFIX wdt: <https://portal.mardi4nfdi.de/prop/direct/>
SELECT ?item ?name (SAMPLE(?cites) as ?Publication)
WHERE {
  ?item wdt:P229 ?name ; wdt:P223 ?cites
} GROUP by ?item ?name
Try it!

Formulae from the DLMF

PREFIX wdt: <https://portal.mardi4nfdi.de/prop/direct/>
PREFIX wd: <https://portal.mardi4nfdi.de/entity/>

SELECT (?dep2nd as ?qId) ?dlmfid ?definesLabel ?formula
WHERE {
  ?item wdt:P4 wd:Q1818 .
         ?item wdt:P3 ?defines .
       ?dep2nd wdt:P4 ?defines 
       FILTER( NOT EXISTS { ?dep2nd wdt:P4 wd:1818.})
         OPTIONAL{?dep2nd wdt:P2 ?dlmfid .}
                OPTIONAL{?dep2nd wdt:P14 ?formula .}      
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }

      }
Limit 10
Try it!
Paper with many authors
#title:Most authors in MSC 14E30
PREFIX wdt: <https://portal.mardi4nfdi.de/prop/direct/>
PREFIX wd: <https://portal.mardi4nfdi.de/entity/>

SELECT ?item (COUNT(*) as ?cnt) (GROUP_CONCAT(?authorLabel;separator="; ") as ?authors) 
WHERE { ?item wdt:P31 wd:Q56887 ; wdt:P226 "14E30" ; wdt:P16 ?author.
      SERVICE wikibase:label { bd:serviceParam wikibase:language "en". 
                             ?author rdfs:label ?authorLabel .
Most authors in MSC 14E30

GROUP by ?item ORDER by DESC(?cnt) LIMIT 5 }}