Help
Difference between revisions of "SPARQL/test"
< Help:SPARQLThis page is a temporary demo showcasting new support for Wikidata Query Service.
(→Issue) |
|||
| Line 59: | Line 59: | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE]". } | ||
} | } | ||
| + | </query> | ||
| + | |} | ||
| + | |||
| + | == Francophones == | ||
| + | To run on WCQS.<ref name="DFQS">https://www.dictionnairedesfrancophones.org/sparql</ref> | ||
| + | |||
| + | {| style="width:100%" | ||
| + | |- style="vertical-align:top;" | ||
| + | |style="padding: 0 3em;width:60%"| | ||
| + | <syntaxhighlight lang="sparql"> | ||
| + | #defaultEndpoint:Francophones | ||
| + | PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> | ||
| + | PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> | ||
| + | SELECT * WHERE { | ||
| + | ?sub ?pred ?obj . | ||
| + | } LIMIT 10 | ||
| + | </syntaxhighlight> | ||
| + | || | ||
| + | <query _pagination="10"> | ||
| + | #defaultEndpoint:Francophones | ||
| + | PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> | ||
| + | PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> | ||
| + | SELECT * WHERE { | ||
| + | ?sub ?pred ?obj . | ||
| + | } LIMIT 10 | ||
</query> | </query> | ||
|} | |} | ||
Revision as of 13:15, 23 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]". }
}
|
|
Francophones
To run on WCQS.[2]
#defaultEndpoint:Francophones
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT * WHERE {
?sub ?pred ?obj .
} LIMIT 10
|
|
Commons
To run on WCQS.[3]
#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"
}
|
|
Issue
Wikimedia Commons Query Service's end point rejects external queries :
- Cross-Origin Request Blocked: The Same Origin Policy disallows reading the remote resource at https://commons.wikimedia.org/wiki/Special:OAuth/authenticate?oauth_token=b0685605ac44eb315c2571d1a0fb43db. (Reason: CORS header ‘Access-Control-Allow-Origin’ missing). Status code: 302.
According to commons:Commons:SPARQL_query_service#Release_notes :
- OAuth is currently not working. See https://stackoverflow.com/questions/65303450/how-to-authenticate-to-wikimedia-commons-query-service-using-oauth-in-python#comment115828158_65424900. This is so that we can contact abusive bots and/or users and block them selectively as a last resort if needed.
See also phab:T297995.