Project:DMV-Talk: Difference between revisions
From MaRDI portal
Created page with "<syntaxhighlight lang=SPARQL> 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..." |
|||
(7 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
< | ==== CRAN Packages ==== | ||
{{SPARQL|query= | |||
PREFIX wdt: <https://portal.mardi4nfdi.de/prop/direct/> | |||
SELECT ?item ?name | |||
WHERE { | |||
?item wdt:P229 ?name | |||
} | |||
}} | |||
* 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 16: | Line 36: | ||
} | } | ||
Limit 10 | Limit 10 | ||
}} | |||
===== Paper with many authors ===== | |||
{{SPARQL|query= | |||
#title:Most authors in MSC 14E30 | |||
PREFIX wdt: <https://portal.mardi4nfdi.de/prop/direct/> | PREFIX wdt: <https://portal.mardi4nfdi.de/prop/direct/> | ||
PREFIX wd: <https://portal.mardi4nfdi.de/entity/> | PREFIX wd: <https://portal.mardi4nfdi.de/entity/> | ||
SELECT ( | SELECT ?item (COUNT(*) as ?cnt) (GROUP_CONCAT(?authorLabel;separator="; ") as ?authors) | ||
WHERE { | 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