从粉丝页面获取事件的 FQL 查询错误

Question

我正在尝试获取粉丝页面创建的所有活动。我使用了下面的查询。

SELECT eid, name, description, pic_big, start_time, end_time, location 
FROM event 
WHERE creator = 142258389139112 
      AND eid IN (SELECT eid FROM event_member WHERE uid = 142258389139112)

好的，这工作正常，但我在 FQL 文档中看到，如果我不指定 <表 event_member 中的 code>start_time 它只会返回未来的事件，但我需要粉丝页面创建的所有事件，这包括事件过去的时间。

我尝试使用此查询：

SELECT eid, name, description, pic_big, start_time, end_time, location 
FROM event 
WHERE creator = 142258389139112 
      AND eid IN (
          SELECT eid 
          FROM event_member 
          WHERE uid = 142258389139112 
                AND start_time > 1316649600 
          ORDER BY start_time
      )

但它返回此错误：

“错误代码”：604， "error_msg": "无法同时通过 'eid' 和 'start_time' 查询",

当我尝试使用我的 uid 时，通常会查询该函数：

SELECT eid, name, description, pic_big, start_time, end_time, location 
FROM event 
WHERE creator = 142258389139112 
      AND eid IN (
          SELECT eid 
          FROM event_member 
          WHERE uid = me() 
                AND start_time > 1316649600 
          ORDER BY start_time
      )

Answer 1

您有一个小语法错误，请参阅下面的工作查询。

SELECT eid, name, description, pic_big, start_time, end_time, location 
FROM event
WHERE creator = 142258389139112 
AND eid IN (SELECT eid FROM event_member WHERE uid = 142258389139112)
AND start_time > 1316649600
ORDER BY start_time

我希望这有帮助。