Skip to content

Instantly share code, notes, and snippets.

@bluefuton

bluefuton/gist:1308809

Created October 24, 2011 11:23
Show Gist options
  • Save bluefuton/1308809 to your computer and use it in GitHub Desktop.
Save bluefuton/1308809 to your computer and use it in GitHub Desktop.
Download ZIP
FQL: get photos of me and a friend
Raw
gistfile1.sql
SELECT pid, src_big
FROM photo
WHERE pid IN(
SELECT pid
FROM photo_tag
WHERE subject = me()
)
AND pid IN(
SELECT pid
FROM photo_tag
WHERE subject = <friend_user_id>
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment