Facebook FQL查询类似于朋友签到 [英] facebook fql query similar to friends checkins

问题描述

正在寻找与以下搜索等效的fql.希望通过朋友获取所有签到信息以及地点名称.

Looking for the fql equivalente to the search below. Looking to get all checkins by friends and the name of the place.

https://graph.facebook.com/search?type=checkin&access_token = ...

temp_time = 2周前

temp_time = 2 weeks ago

如果在下面，请向我获取签到的页面ID(位置)和作者ID(用户)

If below, gets me the the page ID(place) and Author ID (user) of checkins

SELECT author_uid, page_id FROM checkin WHERE timestamp > #{temp_time} AND author_uid IN(SELECT uid2 FROM friend WHERE uid1=me())

在响应中包括用户名和位置详细信息的sql或fql语句是什么.理想情况下，用户应该是其中包含位置细节的人.

What would be the sql or fql statement to include the user name and place details with the response. Ideally, would be user with the place detail in it.

推荐答案

假定位置名称与相应页面的名称相同:

Assuming the name of the location is the same as it's respective page:

SELECT checkin_id, author_uid, page_id FROM checkin 
WHERE author_uid IN (SELECT uid2 FROM friend WHERE uid1 = me()) 
AND page_id IN (SELECT page_id FROM page WHERE name = 'PAGE NAME')

---

FQL仅允许在FROM子句中使用一个表，因此，我认为不可能从单个FQL语句获取所需的所有数据，因为您将需要同时来自两个

---

FQL only permits one table within the FROM clause, as such, I don't think it is possible to get all the data you want from a single FQL statement because you would require data from both user and page tables.

这篇关于Facebook FQL查询类似于朋友签到的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！