How to get total number of albums of all facebook friends?

How to get total number of albums of all facebook friends?

I want to retrieve all facebook friends total albums in one go.

Anyone have have idea how to query "album" table in FB

plz share ur thoughts开发者_C百科 thanks

I've came across this link earlier today, sound similar to your question
FQL for returning all album names and object id's of the albums for ALL friends of a user

If you removed the "LIMIT 25" as ifaour mentioned from his example side note, the query would look like this and do the task

SELECT aid, owner, name FROM album WHERE owner IN (SELECT uid2 FROM friend WHERE uid1=me())

2nd step: let's put it into a multi-query format

{"query1":"SELECT aid, owner, name FROM album WHERE owner IN (SELECT uid2 FROM friend WHERE uid1=me())","query2":"SELECT owner, album_object_id, object_id FROM photo WHERE aid IN (SELECT aid FROM #query1)"}

I guess you'll need to modify the fields in query2 to fit it into your scenario

These will return as 2 big fat json objects with 5000 results limit... which I haven't figured out a solution to query the next 5000 and the rest...

Also, I think there's a bug in both FQL and Graph API, some of my friends' albums are NOT showing in the result... (yes, with the right permission and necessary scopes to browse and query...) I've fired a bug report for this issue