YQL用于推特关注者的推文

select id from xml where url='http://twitter.com/followers/ids/sqlservercentrl.xml'

我的假设是,为了检索所有这些id的推文,我应该能够写:

select title from twitter.user.timeline
where id in (select id from xml where url='http://twitter.com/followers/ids/sqlservercentrl.xml')

但我没有得到任何结果。

笔记

select title from twitter.user.timeline
where id in (select id from xml where url='http://twitter.com/statuses/friends/sqlservercentrl.xml' and itemPath='users.user')