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:

https://developers.facebook.com/tools/explorer



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:

http://developers.facebook.com/docs/reference/fql/user

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

No comments:

Post a Comment