Re: [Dbpedia-discussion] Help with my first dbpedia select - Simpsons Episodes almost working

[Mohamed Morsey]

Hi Teddy,

On 01/08/2013 01:10 PM, Andy 'Ted' Tedford wrote:

Hi all,

I've tried and tried but I cannot understand how to get my select to do what I want.

here is what I have and it works fine

PREFIX owl: <http://www.w3.org/2002/07/owl#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX : <http://dbpedia.org/resource/>
PREFIX dbpedia2: <http://dbpedia.org/property/>
PREFIX dbpedia: <http://dbpedia.org/>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX dbprop: <http://dbpedia.org/property/>
SELECT * WHERE {

?episode <http://purl.org/dc/terms/subject><http://dbpedia.org/resource/Category:The_Simpsons_(season_10)_episodes <http://dbpedia.org/resource/Category:The_Simpsons_%28season_10%29_episodes>> .

    ?episode dbpedia2:season ?season .
    ?episode dbpedia2:airdate ?created .

?episode dbpedia2:blackboard ?blackboard .FILTER ( lang(?comment) = "en" ).

    ?episode dbpedia2:episodeName ?episodeName .
    ?episode dbpedia2:episodeNo ?episodeNo .
    ?episode rdfs:comment ?comment . FILTER ( lang(?comment) = "en" )
}

All I want to do is change it so that it returns all seasons, not just season 10. I know there is a listing of series here -

http://dbpedia.org/page/Category:The_Simpsons_episodes

try the following one:

   SELECT * WHERE {
        ?episode <http://purl.org/dc/terms/subject> ?seasonOfChoice.
        ?seasonOfChoice skos:broader
   <http://dbpedia.org/resource/Category:The_Simpsons_episodes>.
        ?episode dbpedia2:season ?season .
        ?episode dbpedia2:airdate ?created .
        ?episode dbpedia2:blackboard ?blackboard .FILTER (
   lang(?comment) = "en" ).
        ?episode dbpedia2:episodeName ?episodeName .
        ?episode dbpedia2:episodeNo ?episodeNo .
        ?episode rdfs:comment ?comment . FILTER ( lang(?comment) = "en" )
   }

So if someone could please take pity on a newby and let me know how to change the select?

--
Teddy

Hope it helps.

--
Kind Regards
Mohamed Morsey
Department of Computer Science
University of Leipzig


------------------------------------------------------------------------------
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512
_______________________________________________
Dbpedia-discussion mailing list
Dbpedia-discussion@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion