get friend ids from friend_list using fql

Question

Forgive me if this has been answered before, but looking at the questions asked I did not see my answer already in StackOverlow. I am an experienced PHP programmer getting to know the Facebook API. I think the FQL implementation is pretty freaking cool. My knowledge of SQL statements will make the learning experience very smooth. However, Facebook's documentation seems to negate that a few times. I see a list of objects I can query, but I feel like the list is missing certain relational objects. For example: I wish to get a list of the authenticated user's friend_list and the user's friends that pertain to each of the lists. I can successfully retrieve an authenticated user's friend list and a list of their friends, but how do I get a list of the authenticated user's friends that pertain to each of his friend_lists objects?

Answer 1

Use the following fql:

SELECT flid, owner, name FROM friendlist WHERE owner=me()

For more details,

http://developers.facebook.com/docs/reference/fql/friendlist/

Answer 2

Ok, so further research has led me to find a complete list of the tables part of the FQL database. this can be found here : http://developers.facebook.com/docs/reference/fql/ on the left hand side is a list of tables and lo and behold, there a relational table for friends and friendlist called friendlist_member. So at this point I can get a list of the friendslists created by the authenticated user and then do another query to get a list of ids of the users in that friendlist. Finally I do a final query to get details like name and photos of those users.