Skip to content

Instantly share code, notes, and snippets.

@castroalves

castroalves/fql-get-user-partner.sql

Last active August 29, 2015 14:00
Show Gist options
  • Save castroalves/f5cefca4a4f7329b04c0 to your computer and use it in GitHub Desktop.
Save castroalves/f5cefca4a4f7329b04c0 to your computer and use it in GitHub Desktop.
Download ZIP
FQL to Get Someone's Partner (GF, BF, Spouse, etc)
Raw
fql-get-user-partner.sql
# Change FRIEND_UID with the ID of your friend
SELECT uid, name
FROM user
WHERE uid IN (
SELECT significant_other_id
FROM user
WHERE uid IN (
SELECT uid2 FROM friend WHERE uid1 = me() AND uid2 = FRIEND_UID
) AND significant_other_id != ""
)
@castroalves
Copy link
Author

Change FRIEND_UID with the ID of your friend

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