Project:DMV-Talk: Difference between revisions
From MaRDI portal
No edit summary |
|||
(4 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
CRAN Packages | ==== CRAN Packages ==== | ||
{{SPARQL|query= | |||
{{SPARQL|query=PREFIX wdt: <https://portal.mardi4nfdi.de/prop/direct/> | PREFIX wdt: <https://portal.mardi4nfdi.de/prop/direct/> | ||
SELECT ?item ?name | SELECT ?item ?name | ||
WHERE { | WHERE { | ||
Line 8: | Line 8: | ||
}} | }} | ||
Formulae from the DLMF{{SPARQL|query= | * Cran packages with publications | ||
{{SPARQL|query= | |||
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 ==== | |||
{{SPARQL|query= | |||
PREFIX wdt: <https://portal.mardi4nfdi.de/prop/direct/> | PREFIX wdt: <https://portal.mardi4nfdi.de/prop/direct/> | ||
Line 27: | Line 38: | ||
}} | }} | ||
===== Paper with many authors ===== | |||
{{SPARQL|query= | |||
#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 | |||
}} |
Latest revision as of 14:12, 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