Search code examples
facebookfacebook-graph-apicountcommentsphotos

Counting total photo comments of a user

I'm trying to count the total comments to all photos of a user. My query below works but it fails on some users with lots of photos and comments.

Any idea why it fails on some users? Can the query below be improved?

SELECT '' FROM comment WHERE object_id IN (SELECT aid, object_id FROM photo WHERE aid IN (SELECT aid FROM album WHERE owner = $uid )) LIMIT 5000
Solution

  • What exactly are you trying to SELECT?
    You can not do "*" selects on FQL tables to select all fields - you have to specify exactly which fields you want.