My Programming Tricks
Saturday, December 15, 2012
Check Out Facebook Friends with Most Mutual Friend FQL
As in my previous
post
, here's the modified version to list out friends with most mutual friends in Facebook.
SELECT
name,uid,mutual_friend_count
FROM
user
WHERE
uid
IN (SELECT
uid1
FROM
friend
WHERE
uid2
=me()) ORDER BY
mutual_friend_count
DESC
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment