FQL我正在参加特定活动的朋友 [英] FQL my friends who are attending a particular event

问题描述

我正在努力寻找所有正在参加特定事件的朋友。我认为正确的方法是使用FQL。这样做的查询是什么？

解决方案

根据 event_member fql表：

  SELECT uid FROM event_member WHERE eid = ... AND rsvp_status ='attending'
  

我想你可以使用这样的东西：

  SELECT uid FROM event_member WHERE eid = ... AND rsvp_status ='attending'AND uid IN（SELECT uid2 FROM friend WHERE uid1 = me（））
  

I am trying to find all my friends who are are attending a particular event of interest. I think the right way to do it is with FQL. What would be the query to do that?

解决方案

Based on the example in the event_member fql table:

SELECT uid FROM event_member WHERE eid = ... AND rsvp_status = 'attending'

I suppose you could use something like:

SELECT uid FROM event_member WHERE eid = ... AND rsvp_status = 'attending' AND uid IN (SELECT uid2 FROM friend WHERE uid1 = me())

这篇关于FQL我正在参加特定活动的朋友的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！