Some fun with the semantic web

I've recently been playing with the semantic web (for the uninitiated, the semantic web is a structuring of web content in terms of what it depicts instead of just a bunch of linked text files) and have come up with the following two queries -- let me know if you find these useful!

For SPARQL (I.e., dbpedia), the following should return how many competitors each country is sending to the London 2012 Olympics:

SELECT ?country ?competitors WHERE {
?s foaf:page ?country . 
?s rdf:type <http://dbpedia.org/ontology/OlympicResult>.
?s <http://dbpedia.org/property/games> "2012"^^<http://www.w3.org/2001/XMLSchema#int> .
?s dbpprop:competitors ?competitors
} order by desc(?competitors)

See results by going here.

Meanwhile, if you want a MQL query (I.e., Freebase), use the following to give a comprehensive array of Golden Raspberry Award "winners":

        query: {
              "id": "/en/golden_raspberry_awards",
              "type": "/award/award",
              "category": [{
                "name": null,
                "name!=" : "Razzie Award for Worst Actor of the Decade", 
                "AND:name!=" : "Razzie Award for Worst Actress of the Decade",
                "nominees": [{          
                      "year": null,
                      "award_nominee": [],
                      "nominated_for": [],
                     "sort": "-year"
                    }], /* nominees */
                "winners": [{
                  "s1:/type/reflect/any_master" : [{
                    "type": "/award/award_winner",
                    "name": null,
                    "key" : [{
                      "namespace" : "/wikipedia/en",
                      "value": null,
                      "limit": 1
                        }] /* key */
                    }], /* award_winner */
                  "s2:/type/reflect/any_master" : [{
                    "type": "/award/award_winning_work",
                    "name": null,
                    }] /* award_winning_work */
                }] /* winners */
            }] /* category */
        }  /* query */      

Output here.

I'll be writing a fairly comprehensive blog tutorial on this sometime in the next few weeks; follow me on Twitter for updates.