Help
Difference between revisions of "SPARQL/test"
< Help:SPARQL
m (Yug moved page User:Yug/test to Help:SPARQL/test without leaving a redirect) |
|||
| Line 1: | Line 1: | ||
| + | == Lingualibre == | ||
| + | {| style="width:100%" | ||
| + | |- style="vertical-align:top;" | ||
| + | |style="padding: 0 3em;width:60%"| | ||
| + | <syntaxhighlight lang="sparql"> | ||
| + | #defaultEndpoint:Lingualibre | ||
| + | SELECT | ||
| + | (COUNT(DISTINCT ?speaker) AS ?speakers) | ||
| + | (COUNT(DISTINCT ?record) AS ?records) | ||
| + | WHERE { | ||
| + | ?record prop:P2 entity:Q2 . | ||
| + | ?record prop:P6 ?date . | ||
| + | ?record prop:P5 ?speaker . | ||
| + | # Filters: | ||
| + | FILTER(?date >= "2018-07-01T00:00:00Z"^^xsd:dateTime) | ||
| + | FILTER(?date < "2019-01-01T00:00:00Z"^^xsd:dateTime) | ||
| + | } | ||
| + | </syntaxhighlight> | ||
| + | || | ||
| + | <query> | ||
| + | #defaultEndpoint:Lingualibre | ||
| + | SELECT | ||
| + | (COUNT(DISTINCT ?speaker) AS ?speakers) | ||
| + | (COUNT(DISTINCT ?record) AS ?records) | ||
| + | WHERE { | ||
| + | ?record prop:P2 entity:Q2 . | ||
| + | ?record prop:P6 ?date . | ||
| + | ?record prop:P5 ?speaker . | ||
| + | # Filters: | ||
| + | FILTER(?date >= "2018-07-01T00:00:00Z"^^xsd:dateTime) | ||
| + | FILTER(?date < "2019-01-01T00:00:00Z"^^xsd:dateTime) | ||
| + | } | ||
| + | </query> | ||
| + | |} | ||
| + | |||
=== Wikidata === | === Wikidata === | ||
To run on WDQS.<ref name="WDQS">https://w.wiki/6TBV</ref> | To run on WDQS.<ref name="WDQS">https://w.wiki/6TBV</ref> | ||
Revision as of 10:27, 22 March 2023
Lingualibre
#defaultEndpoint:Lingualibre
SELECT
(COUNT(DISTINCT ?speaker) AS ?speakers)
(COUNT(DISTINCT ?record) AS ?records)
WHERE {
?record prop:P2 entity:Q2 .
?record prop:P6 ?date .
?record prop:P5 ?speaker .
# Filters:
FILTER(?date >= "2018-07-01T00:00:00Z"^^xsd:dateTime)
FILTER(?date < "2019-01-01T00:00:00Z"^^xsd:dateTime)
}
|
|
Wikidata
To run on WDQS.[1]
#defaultEndpoint:Wikidata
SELECT DISTINCT ?item ?itemLabel
WHERE {
?item p:P31 ?statement0.
?statement0 (ps:P31/(wdt:P279*)) wd:Q34228.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". }
}
|
|
Commons
To run on WCQS.[2]
#defaultEndpoint:Commons
SELECT ?item
WHERE {
?item wdt:P31 wd:Q108167708 . # Filter: P31 'instance of' Q108167708 'record'
?item wdt:P407 wd:Q1860 . # Filter: P407 'language' is Q1860 'English'
?item wdt:P9533 "apple"@en. # Filter: P9533 'transcription' is "apple"
}
|
|