preslavrachev/find_friend_app_users.sql

Created May 2, 2013 08:05

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/preslavrachev/5500832.js"></script>
Save preslavrachev/5500832 to your computer and use it in GitHub Desktop.

Download ZIP

Find which friends of yours are using a particular Facebook-connected application. Unlike other approaches, using this FQL query, one will fetch only those among one's friends, who are actually using the application. The application in question depends on the access token being passed in the request

Raw

find_friend_app_users.sql

SELECT uid,name,is_app_user FROM user WHERE is_app_user AND uid IN (SELECT uid2 FROM friend WHERE uid1 = me())

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment