Skip to content

Instantly share code, notes, and snippets.

@castroalves

castroalves/fql-get-friends-other-states.sql

Created April 29, 2014 21:41
Show Gist options
  • Save castroalves/c58bc23e995270b28626 to your computer and use it in GitHub Desktop.
Save castroalves/c58bc23e995270b28626 to your computer and use it in GitHub Desktop.
Download ZIP
FQL to Get Friends From States Other Than Yours
Raw
fql-get-friends-other-states.sql
{
'query1': 'SELECT hometown_location.state FROM user WHERE uid = me()',
'query2': 'SELECT uid, name, hometown_location FROM user WHERE uid IN ( SELECT uid2 FROM friend WHERE uid1 = me() ) AND NOT ( hometown_location.state IN ( SELECT hometown_location.state FROM #query1 ) ) AND hometown_location != ""'
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment