简单的说。我需要帮助构建 FQL 多查询请求,该请求将执行以下操作:
- 然后从登录用户的好友列表中获取 UID,
- 使用这些 ID 获取过去两周的所有评论和消息(来自流)
- 最后,将这些结果与用户名连接起来
这是我迄今为止的疑问:
[1] GRAB_UID:
SELECT uid2 FROM friend WHERE uid1 = me()
[2] 抓取流(错过了两周的部分,并且可能完全错误):
SELECT type, created_time, post_id, comments, actor_id, target_id, message
FROM stream
WHERE filter_key IN
(SELECT filter_key FROM stream_filter WHERE uid = me())
AND actor_id IN
(SELECT uid2 FROM friend WHERE uid1 = me())
)';
[3] GRAB_USRNAMES:
SELECT uid, name, username, pic_square, current_location, profile_url
FROM user WHERE uid IN
(SELECT uid2 FROM friend WHERE uid1 = me())
我真的需要一位大师来提出此类请求,我非常感谢他的帮助。