YQL for Tweeter Tweets

Question

How can I get a list of tweets of specific Twitter account subscribers? I can get a list of follower IDs with this:

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

My guess was that to get tweets for all of these identifiers, I would have to write:

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

but I just don't get the results.

note - for comparison, the following request, which receives tweets of friends (which I adhere to unlike the one who follows me), works:

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')

Answer 1

Have you tried adding itemPath criteria?

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