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.