|
Last change
on this file since 34733 was 34733, checked in by davidb, 3 years ago |
|
Rename to reflect the LOD field that it focuses on
|
|
File size:
548 bytes
|
| Line | |
|---|
| 1 |
|
|---|
| 2 |
|
|---|
| 3 | SELECT DISTINCT ?countries_in_esc_by_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 | ?country_in_year dbp:entrant ?entrant.
|
|---|
| 13 | FILTER (isLITERAL(?entrant)).
|
|---|
| 14 | ?country_in_year dbp:song ?song
|
|---|
| 15 | }
|
|---|
| 16 | ORDER BY ASC(?countries_in_esc_by_year)
|
|---|
Note:
See
TracBrowser
for help on using the repository browser.
