I'm looking for a way to fetch only unread messages from a users 'Inbox'.

Is this possible to do by using select with YQL?

So far, every query I try returns every single message in the users 'Inbox'.
e.g.
select * from ymail.messages where numMid='3'
select * from ymail.messages limit 10
select * from ymail.messages where messageInfo.flags.isRead='0'

Thanks,
  Johnny