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
}
- 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
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
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 .
GROUP by ?item ORDER by DESC(?cnt) LIMIT 5 }}