Re: LOD Happy Holidays

wait, wait, legacy SQL system update in progress ...

UPDATE "Santa"."List"
SET "Santa"."List"."Status" = 'nice'
WHERE "Santa"."List"."Name" IN ('Gannon Dick') AND "Santa"."List"."Status" = 'naughty';

(1 row affected)

Proceed.




________________________________
 From: David Wood <david@3roundstones.com>
To: "public-lod@w3.org community" <public-lod@w3.org> 
Sent: Friday, December 21, 2012 8:39 AM
Subject: LOD Happy Holidays
 
Hi all,

At http://dbpedia.org/sparql

SELECT ("Happy" as ?salutation) ?name1 ?name2 ?name3 ?name4 ?name5 WHERE {
  OPTIONAL {<http://dbpedia.org/resource/Hanukka> rdfs:label ?name1}
  OPTIONAL {<http://dbpedia.org/resource/Christmas> foaf:name ?name2}
  OPTIONAL {<http://dbpedia.org/resource/Kwanza> rdfs:label ?name3}
  OPTIONAL {<http://dbpedia.org/resource/Solstice> rdfs:label ?name4}
  FILTER langMatches( lang(?name4), "EN" )
  OPTIONAL {<http://dbpedia.org/resource/New_Year> rdfs:label ?name5}
  FILTER langMatches( lang(?name5), "EN" )
}

http://dbpedia.org/sparql?default-graph-uri=http%3A%2F%2Fdbpedia.org&query=SELECT+%28%22Happy%22+as+%3Fsalutation%29+%3Fname1+%3Fname2+%3Fname3+%3Fname4+%3Fname5+WHERE+%7B%0D%0A++OPTIONAL+%7B%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2FHanukka%3E+rdfs%3Alabel+%3Fname1%7D%0D%0A++OPTIONAL+%7B%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2FChristmas%3E+foaf%3Aname+%3Fname2%7D%0D%0A++OPTIONAL+%7B%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2FKwanza%3E+rdfs%3Alabel+%3Fname3%7D%0D%0A++OPTIONAL+%7B%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2FSolstice%3E+rdfs%3Alabel+%3Fname4%7D%0D%0A++FILTER+langMatches%28+lang%28%3Fname4%29%2C+%22EN%22+%29%0D%0A++OPTIONAL+%7B%3Chttp%3A%2F%2Fdbpedia.org%2Fresource%2FNew_Year%3E+rdfs%3Alabel+%3Fname5%7D%0D%0A++FILTER+langMatches%28+lang%28%3Fname5%29%2C+%22EN%22+%29%0D%0A%7D&format=text%2Fhtml&timeout=0&debug=on

Regards,
Dave
--
http://about.me/david_wood