Facebook mutual friends

Question

I am trying to sort my friends by the number of mutual friends we have. I tried getting the number of mutual friends one by one and creating an id->no_of_mutual_friend key value pair but that just takes way too long, because I have to call the facebook API over a 1000 times.

Is there an easier way to do this by using FQL?

Not a duplicate, Cthulhu; they're very different questions. – Mark Amery Oct 20 '12 at 00:09 — Mark Amery, Oct 20 '12 at 00:09

score 3 · Accepted Answer · answered Oct 20 '12 at 00:05

3

This do what you need?

SELECT uid, mutual_friend_count
FROM user
WHERE uid IN 
    (SELECT uid1 
     FROM friend 
     WHERE uid2 = me()) 
ORDER BY mutual_friend_count DESC

answered Oct 20 '12 at 00:05

Mark Amery

143,130
81
406
459

yes thank you, much more faster – s_curry_s Oct 20 '12 at 23:57

Facebook mutual friends

1 Answers1