|
Last change
on this file since 34850 was 34850, checked in by davidb, 3 years ago |
|
Filename change to better reflect the SPARQL endpoint used; also query change to get back every relevant entry that is a string (so companion field is no longer being restricted to be a IRI
|
|
File size:
588 bytes
|
| Line | |
|---|
| 1 | prefix dct: <http://purl.org/dc/terms/>
|
|---|
| 2 |
|
|---|
| 3 | SELECT DISTINCT ?country_in_year ?year ?country ?entrant
|
|---|
| 4 | WHERE {
|
|---|
| 5 | ?countries_in_esc_by_year skos:broader dbc:Countries_in_the_Eurovision_Song_Contest_by_year.
|
|---|
| 6 |
|
|---|
| 7 | ?country_in_year dct:subject ?countries_in_esc_by_year.
|
|---|
| 8 | bind( REPLACE(str(?country_in_year), ".*(\\d{4})", "$1") as ?year).
|
|---|
| 9 | FILTER ( xsd:integer(?year) < 2020).
|
|---|
| 10 |
|
|---|
| 11 | ?country_in_year dbp:country ?country.
|
|---|
| 12 |
|
|---|
| 13 | ?country_in_year dbp:entrant ?entrant
|
|---|
| 14 | FILTER (isLITERAL(?entrant)).
|
|---|
| 15 |
|
|---|
| 16 | ?country_in_year dbp:song ?song.
|
|---|
| 17 |
|
|---|
| 18 | }
|
|---|
| 19 | ORDER BY ASC(?countries_in_esc_by_year)
|
|---|
Note:
See
TracBrowser
for help on using the repository browser.
