title: Looking for help with YQL movie showtimes
body: <p>I had been using the undocumented Yahoo movies API until it was pulled a few days ago, so I'm looking for another way to retrieve local movie showtimes (ideally by theater).  I found <strong><a href="https://stackoverflow.com/questions/1329377/yahoo-movies-api-documentation/1655952#1655952">this thread</a></strong> about YQL datatables on SO, and the last post looked really promising.  I just can't seem to figure out how to query the data to return local movies and showtimes. I've been trying variations on "SELECT * from movies.showtimes where location='myzip'" with no success.  Any ideas?</p>