Reputation: 17
Im trying to get and events stream. More specifically the posts and comments about the particular event. I can get the event with no problem.
SELECT eid,pic, name, start_time, location, ticket_uri, venue FROM event WHERE creator =
What I need are the comments/stream/posts underneath. I've spent a few days on this with no luck. Here is a sample page Im trying to get the info from:
https://www.facebook.com/events/336787446434356/
I want all the pics, vids comments etc..
Thank you
Upvotes: 0
Views: 115
Reputation: 3674
You can use the following FQL to retrieve posts related to a particular event:
SELECT post_id, message FROM stream WHERE source_id = {Event_Id} LIMIT 500
Similarly, you can perform the following multi-query to retrieve the comments:
SELECT text FROM comment WHERE post_id IN
(SELECT post_id FROM stream WHERE source_id = {Event_Id} LIMIT 500)
Replace the {Event_Id} with the Id of your Event.
Upvotes: 0