Hi Teddy, you can try with the following
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 { ?subject skos:broader <http://dbpedia.org/resource/Category:The_Simpsons_episodes> . ?episode <http://purl.org/dc/terms/subject> ?subject . ?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" ) } Is that what you need? Regards Andrea 2013/1/8 Andy 'Ted' Tedford <tedfordte...@googlemail.com>: > 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> > . > ?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 > > So if someone could please take pity on a newby and let me know how to > change the select? > -- > Teddy > > ------------------------------------------------------------------------------ > 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 > ------------------------------------------------------------------------------ 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
