---++BBC SPARQL Collection
%TOC%
---+++All Programmes Related To James Bond
PREFIX po:
PREFIX rdfs:
SELECT ?uri ?label
WHERE
{
?uri po:category
;
rdfs:label ?label.
}
---+++Find All Eastenders Broadcasta After A Given Date
## Find all eastenders broadcasta after 2009-01-01,
## along with the broadcast version & type
PREFIX event:
PREFIX tl:
PREFIX po:
PREFIX xsd:
SELECT ?version_type ?broadcast_start
WHERE
{
po:episode ?episode .
?episode po:version ?version .
?version a ?version_type .
?broadcast po:broadcast_of ?version .
?broadcast event:time ?time .
?time tl:start ?broadcast_start .
FILTER ( (?version_type != )
&& (?broadcast_start > "2009-01-01T00:00:00Z"^^xsd:dateTime) )
}
---+++Find All Programmes That Featured Both The Foo Fighters And All Green
PREFIX po:
PREFIX rdfs:
PREFIX mo:
PREFIX foaf:
PREFIX event:
PREFIX tl:
PREFIX owl:
SELECT DISTINCT ?programme ?label
WHERE
{
?event1 po:track ?track1 .
?track1 foaf:maker ?maker1 .
?maker1 owl:sameAs .
?event2 po:track ?track2 .
?track2 foaf:maker ?maker2 .
?maker2 owl:sameAs .
?event1 event:time ?t1 .
?event2 event:time ?t2 .
?t1 tl:timeline ?tl .
?t2 tl:timeline ?tl .
?version po:time ?t .
?t tl:timeline ?tl .
?programme po:version ?version .
?programme rdfs:label ?label .
}
---+++Get Short Synopsis Of Eastenders Episodes
PREFIX po:
PREFIX dc:
SELECT ?t ?o
WHERE
{
po:episode ?e .
?e a po:Episode .
?e po:short_synopsis ?o .
?e dc:title ?t
}
---+++Get Short Synopsis Of Eastenders Episodes ( With Graph )
PREFIX po:
PREFIX dc:
SELECT ?g ?t ?o
WHERE
{
graph ?g
{
po:episode ?e .
?e a po:Episode .
?e po:short_synopsis ?o .
?e dc:title ?t
}
}
---+++ Get Reviews Where John Paul Jones Has Been Involved
PREFIX mo:
PREFIX foaf:
PREFIX dc:
PREFIX rev:
PREFIX po:
SELECT DISTINCT ?r_name, ?rev
WHERE
{
{
foaf:made ?r1 .
?r1 a mo:Record .
?r1 dc:title ?r_name .
?r1 rev:hasReview ?rev
}
UNION
{
mo:member_of ?b1 .
?b1 foaf:made ?r1 .
?r1 a mo:Record .
?r1 dc:title ?r_name .
?r1 rev:hasReview ?rev
}
}