SampleQueries

From SIOC Wiki

Jump to: navigation, search

This page contains sample SPARQL queries that can be performed over SIOC data.

Get the Usergroups Uldis is involved in: {{{ PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX sioc: <http://rdfs.org/sioc/ns#> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> SELECT DISTINCT ?name ?group ?description WHERE {

?x rdf:type sioc:User .
?x sioc:name ?name .
?u sioc:has_member ?x .
{ ?u sioc:name ?group  } UNION
{ ?u sioc:description ?group } . 
FILTER REGEX(str(?name), "^Uldis Bojars$") 

} }}}

Comments on last month's topics: {{{ PREFIX sioc: <http://rdfs.org/sioc/ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> SELECT ?post ?reply ?date WHERE

 { 
 ?post sioc:has_reply ?reply .
 ?post sioc:created_at ?date .
 FILTER (xsd:dateTime(?date) >= "2006-05-01T00:00:00Z"^^xsd:dateTime) 

} }}}

"Original" posts, i.e. not replies {{{ PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX sioc: <http://rdfs.org/sioc/ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT DISTINCT ?post ?title ?date ?author WHERE {

 ?post sioc:title ?title .
 ?post sioc:created_at ?date .
 ?post sioc:has_creator ?_y .
 ?_y rdfs:label ?author .
 OPTIONAL { ?_z sioc:has_reply ?post }
 FILTER (!bound(?_z))

} ORDER BY ?start }}}}

Personal tools