I have a question regarding facebook FQL and it expected behavior. I have a specific example to share.
I am querying the FacebookJapan (id: 365989369023) Page with this fql query in the fql console:
SELECT post_id, actor_id, message
FROM stream
WHERE source_id = 365989369023
When doing this query, I receive back posts that aren't even written by facebookJapan (can confirm with the actor_id and I can't even find these posts on FacebookJapan's Page.
However, when explicitly writing out:
SELECT post_id, actor_id, message
FROM stream
WHERE source_id = 365989369023 AND actor_id = 365989369023
I actually get the posts that I would expect and mirrors the actual FacebookJapan's page.
However, this isn't an ideal solution because I'm querying other Pages and would like to grab all the posts and not just those with the same actor_id as the Page id itself.
Am I doing something wrong? I really can't find anything wrong with the first FQL statement. If you have time, I would kindly ask to confirm if things aren't working right with this particular query and Page id. Thank you!
The first query seems fine to me, what exactly is the problem? My understanding of the stream table is that it should be returning posts on the page's wall regardless of who posted them - is that not what ordinarily happens?