Changeset 35064

Timestamp:

2021-04-12T20:48:08+12:00 (3 years ago)

Author:

davidb

Message:

Updated query to use DISTINCT (and inner SELECT), since countries have more than on entry in 1956

File:

• main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/pages/sgvizler.xsl (modified) (2 diffs)

main/trunk/model-sites-dev/eurovision-lod/collect/eurovision/transform/pages/sgvizler.xsl

@@ -211 +211 @@
 
         <div id="ssv-orig" style="display: none;">
-<!-- -->
-<xsl:text>
+          <!--
 PREFIX rdfs: &lt;http://www.w3.org/2000/01/rdf-schema#&gt;
 PREFIX gsdlextracted: &lt;http://greenstone.org/gsdlextracted#&gt;
@@ -222 +221 @@
 }
 GROUP BY ?country ORDER BY DESC(?freqCount)
+-->
+<!-- -->
+<xsl:text>
+PREFIX rdfs: &lt;http://www.w3.org/2000/01/rdf-schema#&gt;
+PREFIX gsdlextracted: &lt;http://greenstone.org/gsdlextracted#&gt;
+
+SELECT ?country (COUNT(?country) AS ?freqCount)      
+WHERE {
+    GRAPH &lt;</xsl:text><xsl:value-of select="$graphURI"/><xsl:text>&gt;  {
+        { 
+            SELECT DISTINCT ?country ?year WHERE {
+                ?s gsdlextracted:Country ?country.
+                ?s gsdlextracted:Year ?year.
+           } ORDER BY ?country ?year
+        }
+    }
+}
+GROUP BY ?country ORDER BY DESC(?freqCount)
+
 </xsl:text>
         </div>