YQL Open Data Table Interface to Freebase

This app provides YQL interface files to Freebase.

A Raw MQL Call

• Call Format:

                  USE "http://opendatatables.freebaseapps.com/mqlread" AS mytable;  
                  SELECT * FROM mytable WHERE query = '{"id":"/en/blade_runner", "name":null}'
                

• In the YQL Console

Joining Freebase with other services

• Image search for actors that were in Blade Runner:
  

                  USE "http://opendatatables.freebaseapps.com/mqlread" AS mytable;  
                  select * from search.images where query in (SELECT starring.actor FROM mytable 
                      WHERE query ='[{"id":"/en/blade_runner","type":"/film/film","starring":[{"actor":null}]}]') 
                  and mimetype like "%jpeg%"
                

• In the YQL Console

---

Note: YQL aggressively caches Open Data Table definitions.
You can force YQL to reread the definition by adding a trailing "/<anything>" to any of these Open Data Tables.
For instance: USE "http://opendatatables.freebaseapps.com/mqlread/xxx" AS mytable;