SELECT DISTINCT
?mainTopic ?relatedTopic
WHERE {
?url
a fo-site-abstract:URL ;
skos:prefLabel "/hunger-games" ;
fo-site-abstract:hasTopic ?mainTopic
.
OPTIONAL {
?mainTopic fo-site-abstract:hasTopic* | ^fo-site-abstract:hasTopic* ?relatedTopic .
?relatedTopic a fo-publisher:Topic .
FILTER(?mainTopic != ?relatedTopic && ?relatedTopic != ?url)
}
}
+---------------------------------+--------------------------------------------------+
| mainTopic | relatedTopic |
+---------------------------------+--------------------------------------------------+
| r29:Story-Book-The_Hunger_Games | r29:ProductDomain-Katniss_Side_Braids |
| r29:Story-Book-The_Hunger_Games | r29:Event-The_Hunger_Games |
| r29:Story-Book-The_Hunger_Games | r29:Story-Movie-The_Hunger_Games |
| r29:Story-Book-The_Hunger_Games | r29:Story-BlogArticle-Hunger_Games_Katniss_Braid |
| r29:Story-Book-The_Hunger_Games | r29:Writer-Suzanne_Collins |
| r29:Story-Book-The_Hunger_Games | r29:Trend-Wearing_Braids |
+---------------------------------+--------------------------------------------------+
This is the result page of the same query executed from our code:
----------------------------------------------------------------
| mainTopic | relatedTopic |
================================================================
| r29:Story-Book-The_Hunger_Games | r29:Writer-Suzanne_Collins |
----------------------------------------------------------------