Skip to content

Instantly share code, notes, and snippets.

@joujiahe
Created February 6, 2014 11:28
Show Gist options
  • Save joujiahe/8842439 to your computer and use it in GitHub Desktop.
Save joujiahe/8842439 to your computer and use it in GitHub Desktop.
FQL for getting Facebook messages and order by created time
SELECT body, source, viewer_id, created_time FROM message WHERE thread_id IN (SELECT thread_id FROM thread WHERE folder_id = 1 AND me() IN (recipients)) ORDER BY created_time DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment