SPARQL examples

This page is automatically parsed by the query page to provide examples.

Simple Queries

Complete Dependency Graph

1. defaultView:Graph

PREFIX wdt: <https://graphit.ur.de/prop/direct/> SELECT ?item ?itemLabel ?class ?classLabel ?image ?dependency ?dependencyLabel WHERE {

 ?item wdt:P1 ?dependency.
 ?item wdt:P2 ?class
 OPTIONAL{ ?item wdt:P9 ?image.}
 OPTIONAL{ ?class wdt:P9 ?image.}
 SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

}

Central topics (topics with a high number of dependencies)

1. defaultView:Graph

PREFIX wd: <https://graphit.ur.de/entity/> PREFIX wds: <https://graphit.ur.de/entity/statement/> PREFIX wdv: <https://graphit.ur.de/value/> PREFIX wdt: <https://graphit.ur.de/prop/direct/> PREFIX p: <https://graphit.ur.de/prop/> PREFIX ps: <https://graphit.ur.de/prop/statement/> PREFIX pq: <https://graphit.ur.de/prop/qualifier/>

SELECT ?dependency ?dependencyLabel ?prerequisites ?prerequisite ?prerequisiteLabel WHERE {

 {
 SELECT ?dependency ?dependencyLabel (COUNT(DISTINCT ?prerequisite) as ?prerequisites) WHERE {
     ?prerequisite wdt:P1 ?dependency.      
 } GROUP BY ?dependency ?dependencyLabel
 }
 ?prerequisite wdt:P1 ?dependency.
 SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

}

Advanced topics (topics with a high number of prerequisites)

1. defaultView:Graph

PREFIX wd: <https://graphit.ur.de/entity/> PREFIX wds: <https://graphit.ur.de/entity/statement/> PREFIX wdv: <https://graphit.ur.de/value/> PREFIX wdt: <https://graphit.ur.de/prop/direct/> PREFIX p: <https://graphit.ur.de/prop/> PREFIX ps: <https://graphit.ur.de/prop/statement/> PREFIX pq: <https://graphit.ur.de/prop/qualifier/>

SELECT ?prerequisite ?prerequisiteLabel ?dependencies ?dependency ?dependencyLabel WHERE {

 {
 SELECT ?prerequisite ?prerequisiteLabel (COUNT(DISTINCT ?dependency) as ?dependencies) WHERE {
     ?prerequisite wdt:P1 ?dependency.      
 } GROUP BY ?prerequisite ?prerequisiteLabel
 }
 ?prerequisite wdt:P1 ?dependency.
 SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

}

Topics that Max Mustermann has completed

1. defaultView:Timeline

PREFIX wd: <https://graphit.ur.de/entity/> PREFIX wds: <https://graphit.ur.de/entity/statement/> PREFIX wdv: <https://graphit.ur.de/value/> PREFIX wdt: <https://graphit.ur.de/prop/direct/> PREFIX p: <https://graphit.ur.de/prop/> PREFIX ps: <https://graphit.ur.de/prop/statement/> PREFIX pq: <https://graphit.ur.de/prop/qualifier/> SELECT ?topic ?topicLabel ?image ?date WHERE {

 BIND(wd:Q157 as ?user).
 ?user p:P12 ?statement.
 ?statement ps:P12 ?topic.
 ?statement pq:P19 ?date.
 OPTIONAL{ ?topic wdt:P11 ?image.}
 SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

}