FQL查询选择上过同一所大学的朋友

Question

所以我有一个基本的FQL查询，它可以提取用户的所有朋友：

$fql = "SELECT name FROM user WHERE uid IN (SELECT uid1 FROM friend WHERE uid2=me())";

我需要能够根据他们的学校缩小返回用户的范围。我知道你可以做这样的查询：

$fql = "SELECT name FROM user WHERE sex='male' AND uid IN (SELECT uid1 FROM friend WHERE uid2=me())";

这将只返回男性朋友。有没有添加另一个条款，比如：

AND WHERE sex='male'

除了学校信息中的id与其他id相等的地方。我已经要求用户授予我friends_education_shistory权限，所以这应该是一个问题。我想做的是，只拉一个特定大学的朋友来展示他们。

我也知道教育信息是一个数组。看起来是这样的：

( [id] => 103767646329157 [name] => Savannah Country Day School ) [year] => Array ( [id] => 137616982934053 [name] => 2006 ) [type] => High School ) [1] => Array ( [school] => Array ( [id] => 110256772337516 [name] => American University Center of Provence ) [type] => College ) [2] => Array ( [school] => Array ( [id] => 12527153330 [name] => University of Virginia ) [year] => Array ( [id] => 142963519060927 [name] => 2010 ) [concentration] => Array ( [0] => Array ( [id] => 154992221223448 [name] => English ) ) [type] => College ) ) )

我可以在type=学院的地方获取信息吗？

提前感谢

Answer 1

从用户处选择名称uid IN（从朋友处选择uid1 uid2=me（））和"犹他州"IN附属

这将吸引所有在网络"犹他州"（犹他大学）的朋友。