Try this one:
PREFIX dbprop: <http://dbpedia.org/property/>
PREFIX dcterms: <http://purl.org/dc/terms/>
SELECT DISTINCT * WHERE {
?episode dcterms:subject ?subject ;
dbprop:season ?season ;
dbprop:airdate ?created ;
dbprop:blackboard ?blackboard ;
dbprop:episodeName ?episodeName ;
dbprop:episodeNo ?episodeNo ;
rdfs:comment ?comment .
FILTER ( langMatches( lang( ?comment ), "EN" ) ) .
FILTER regex( ?subject, "^
http://dbpedia.org/resource/Category:The_Simpsons_.*episodes$";, "i" )
}
On Tue, Jan 8, 2013 at 2:10 PM, Andy 'Ted' Tedford <
tedfordte...@googlemail.com> 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> .
> ?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
>
>
--
David Riccitelli
-- check the Swagger for WordLift <http://bit.ly/VtoM5H>
********************************************************************************
InsideOut10 s.r.l.
P.IVA: IT-11381771002
Fax: +39 0110708239
---
LinkedIn: http://it.linkedin.com/in/riccitelli
Twitter: ziodave
---
Layar Partner
Network<http://www.layar.com/publishing/developers/list/?page=1&country=&city=&keyword=insideout10&lpn=1>
********************************************************************************
------------------------------------------------------------------------------
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
