Changeset 34732


Ignore:
Timestamp:
2021-01-29T14:19:42+13:00 (3 years ago)
Author:
davidb
Message:

Tidy up

Location:
main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/prepare
Files:
2 edited

Legend:

Unmodified
Added
Removed

  • main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/prepare/problem-artists.sparql

    r34645 r34732  
    11
    22
    3 SELECT DISTINCT ?country ?year ?entrant
     3SELECT DISTINCT ?countries_in_esc_by_year ?year ?country ?entrant
    44WHERE {
    55    ?countries_in_esc_by_year skos:broader dbc:Countries_in_the_Eurovision_Song_Contest_by_year.
    … …  
    1111    ?country_in_year dbp:country ?country.
    1212    ?country_in_year dbp:entrant ?entrant.
     13      FILTER (isLITERAL(?entrant)).
    1314    ?country_in_year dbp:song ?song
    14     FILTER (isLITERAL(?entrant))
    1515}
    16 ORDER BY DESC(?countries_in_esc_by_year)
     16ORDER BY ASC(?countries_in_esc_by_year)

  • main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/prepare/problem-songs.sparql

    r34645 r34732  
    11
    22
    3 SELECT DISTINCT ?country ?year ?song
     3SELECT DISTINCT ?country_in_year ?year ?country ?song
    44WHERE {
    55    ?countries_in_esc_by_year skos:broader dbc:Countries_in_the_Eurovision_Song_Contest_by_year.
    … …  
    1414    FILTER (isLITERAL(?song))
    1515}
    16 ORDER BY DESC(?countries_in_esc_by_year)
     16ORDER BY ASC(?countries_in_esc_by_year)
Note: See TracChangeset for help on using the changeset viewer.