Changeset 35097
- Timestamp:
- 2021-04-22T14:58:32+12:00 (3 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/dataviz/got-nul-point-after-winning.xsl
r35056 r35097 21 21 PREFIX gsdlextracted: <http://greenstone.org/gsdlextracted#> 22 22 23 SELECT (?country ) (COUNT(?country) AS ?freqCount)23 SELECT (?country AS ?Country) (COUNT(?country) AS ?freqCount) 24 24 WHERE { 25 25 GRAPH <</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>> { 26 # ?esc_entrant_uri dc:Relation.isPartOf <</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>>.27 28 26 ?esc_entrant_uri gsdlextracted:Country ?country. 29 27 ?esc_entrant_uri gsdlextracted:Place ?place. … … 35 33 BIND(?year_int + 1 AS ?next_year_int). 36 34 BIND(str(?next_year_int) AS ?next_year). 37 38 # ?esc_entrant_uri gsdlextracted:Final "true".39 35 40 36 ?next_esc_entrant_uri gsdlextracted:Country ?country. 41 37 ?next_esc_entrant_uri gsdlextracted:Year ?next_year. 42 38 39 # The following block tests for 'nul point' 43 40 ?next_esc_entrant_uri gsdlextracted:VoteGrandTotal ?total. 44 41 BIND(xsd:integer(?total) AS ?total_int). 45 FILTER(?total_int = 0). 42 FILTER(?total_int = 0). 43 44 # If you want to see who went from first to last place 45 # (which could still mean you scored some points) then 46 # comment out the block above, and uncommment the following 47 # one 48 49 # ?next_esc_entrant_uri gsdlextracted:ReverseFinishingPos ?rev_finishing_pos. 50 # BIND(xsd:integer(?rev_finishing_pos) AS ?rev_finishing_pos_int). 51 # FILTER(?rev_finishing_pos_int = 1). 46 52 } 47 53 }
Note:
See TracChangeset
for help on using the changeset viewer.