SPARQL examples: Difference between revisions
(test) |
(test) |
||
| Line 3: | Line 3: | ||
== Simple Queries == | == Simple Queries == | ||
=== Complete Dependency Graph === | === Complete Dependency Graph === | ||
{{SPARQL|query= | |||
#defaultView:Graph | #defaultView:Graph | ||
PREFIX wdt: <https://graphit.ur.de/prop/direct/> | PREFIX wdt: <https://graphit.ur.de/prop/direct/> | ||
| Line 12: | Line 13: | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | ||
} | } | ||
}} | |||
=== Central topics (topics with a high number of dependencies) === | === Central topics (topics with a high number of dependencies) === | ||
{{SPARQL|query= | |||
#defaultView:Graph | #defaultView:Graph | ||
PREFIX wd: <https://graphit.ur.de/entity/> | PREFIX wd: <https://graphit.ur.de/entity/> | ||
| Line 33: | Line 35: | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | ||
} | } | ||
}} | |||
=== Advanced topics (topics with a high number of prerequisites) === | === Advanced topics (topics with a high number of prerequisites) === | ||
{{SPARQL|query= | |||
#defaultView:Graph | #defaultView:Graph | ||
PREFIX wd: <https://graphit.ur.de/entity/> | PREFIX wd: <https://graphit.ur.de/entity/> | ||
| Line 54: | Line 57: | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | ||
} | } | ||
}} | |||
=== Topics that Max Mustermann has completed === | === Topics that Max Mustermann has completed === | ||
{{SPARQL|query= | |||
#defaultView:Timeline | #defaultView:Timeline | ||
PREFIX wd: <https://graphit.ur.de/entity/> | PREFIX wd: <https://graphit.ur.de/entity/> | ||
| Line 72: | Line 77: | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | ||
} | } | ||
}} | |||
== Not yet implemented == | == Not yet implemented == | ||
Revision as of 22:19, 5 May 2023
This page is automatically parsed by the query page to provide examples.
Simple Queries
Complete Dependency Graph
#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)
#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)
#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
#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". }
}