Changes between Version 3 and Version 4 of CMD2RDF/Queries

Timestamp:

05/21/14 09:49:15 (10 years ago)

Author:

xnrn@gmx.net

Comment:

--

CMD2RDF/Queries

@@ -6 +6 @@
 == Profiles and Components - Schemas
 
-List all profiles:
+List all profiles with their id and number of instances:
 {{{ 
 #!sql
 PREFIX cmdm: <http://www.clarin.eu/cmd/general.rdf#>
-SELECT ?p WHERE { ?p rdfs:subClassOf cmdm:Profile }
+
+SELECT SAMPLE(?p) as  ?profile SAMPLE(?pid) as ?pid COUNT(?i) as ?count WHERE { ?p rdfs:subClassOf cmdm:Profile. 
+?p dcterms:identifier ?pid.
+?i a ?p.
+ }
+GROUP by ?p ?pid
+ORDER BY DESC(?count)
 }}}
-[[http://clarin.aac.ac.at/isparql/view/?query=PREFIX%20cmdm%3A%20%3Chttp%3A%2F%2Fwww.clarin.eu%2Fcmd%2Fgeneral.rdf%23%3E%0A%0ASELECT%20%3Fp%20WHERE%20{%20%3Fp%20rdfs%3AsubClassOf%20cmdm%3AProfile%20}&endpoint=%2Fsparql&maxrows=50&timeout=&default-graph-uri=&view=1&amode=0&raw_iris=true|​result in clarin.aac.ac.at-virtuoso]]
+[[http://clarin.aac.ac.at/isparql/view/?query=PREFIX%20cmdm%3A%20%3Chttp%3A%2F%2Fwww.clarin.eu%2Fcmd%2Fgeneral.rdf%23%3E%0A%0A%0ASELECT%20SAMPLE%28%3Fp%29%20as%20%20%3Fprofile%20SAMPLE%28%3Fpid%29%20as%20%3Fpid%20COUNT%28%3Fi%29%20as%20%3Fcount%20WHERE%20{%20%3Fp%20rdfs%3AsubClassOf%20cmdm%3AProfile.%20%0A%3Fp%20dcterms%3Aidentifier%20%3Fpid.%0A%3Fi%20a%20%3Fp.%0A%20}%0AGROUP%20by%20%3Fp%20%3Fpid%0AORDER%20BY%20DESC%28%3Fcount%29&endpoint=%2Fsparql&maxrows=50&timeout=&default-graph-uri=&view=1&amode=0&raw_iris=false|result in clarin.aac.ac.at-virtuoso]], 
+[[http://clarin.aac.ac.at/isparql/view/?query=PREFIX%20cmdm%3A%20%3Chttp%3A%2F%2Fwww.clarin.eu%2Fcmd%2Fgeneral.rdf%23%3E%0A%0ASELECT%20%3Fp%20WHERE%20{%20%3Fp%20rdfs%3AsubClassOf%20cmdm%3AProfile%20}&endpoint=%2Fsparql&maxrows=50&timeout=&default-graph-uri=&view=1&amode=0&raw_iris=true|​just profiles]]
 
 List the `cmdm:contains` relation pairs,