facebook - FQL : Selecting friend's photos

Question

这个 FQL 试图为我的 friend 获取照片

[1]

{"query1":"SELECT owner, object_id, src_big FROM photo
WHERE owner IN (SELECT uid2 FROM friend WHERE uid1=me())"}

思考几秒钟后提供此错误响应...

{"error_code":1,"error_msg":"An unknown error occurred"}

但是这个为我的 friend 获取相册的查询将起作用并返回相册信息的 JSON 对象

[2]

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

为什么 [2] 有效而 [1] 无效？

Answer 1

的确，这很奇怪。但这一个做你想要的:

SELECT owner, object_id, src_big 
FROM photo WHERE aid IN (
     SELECT aid FROM album WHERE owner in (
          SELECT uid2 FROM friend WHERE uid1=me()
     )
)

享受分页的乐趣!