Friday, December 14, 2012

Check Out Facebook Friends with Most Friend FQL

Here's a fun FQL to find out who among your FB friends has the most friends:

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

Just copy and paste from the above query codes and paste it to:

I also added the mutual_friend_count for more fun. You can add as many objects you want to "query" from the table documentation here:

The Output? Of course, the data in JSON format.

No comments:

Post a Comment