Question

I m trying to develop this code:

$users = $facebook->api(array(
   method  =>  fql.query ,
   query  =>    "SELECT uid, last_name, pic_big"
             + " FROM user WHERE uid IN ("
             + "     SELECT uid" 
             + "     FROM page_fan"
             + "     WHERE page_id= 411133928921438 " 
             + "         AND uid IN ("
             + "             SELECT uid2 FROM friend WHERE uid1 = me()"
             + "         )"
             + ")"
));

想法是,除了NOTIN外,我不想使用经营者,但FQL没有像NOTIN、EXCEPT这样的支持经营者。 • 如何与联邦土地调查局合作?

Answer 1

There is no NOT IN operator in FQL. You could do a simple select using IN and use PHP for negation. It s a little overhead, but as far as I know it s the only way.

我发现了一个相关员额:link,载于。

Answer 2

Febook确实支持NOT IN。你们只得把它放在足够的位置上。

例如,寻找不是目前用户的用户或朋友参加的活动的用户,向目前的用户提供:

SELECT uid, name FROM user WHERE uid IN (
  SELECT uid FROM event_member WHERE eid=209798352393506
)
AND NOT (uid=me())
AND NOT (uid IN (
  SELECT uid1 FROM friend WHERE uid2=me()
))

Answer 3

仅找到了一条途径:NOT IN,必须共享高兴的消息;]

SELECT post_id, actor_id, message FROM stream WHERE source_id in(a, b, c) and NOT (actor_id in (a, b, c))

这将使用户能够从多个网页上获取信息,即用户的所有职位或不是网页本身、卡片人的所有网页。

友情链接