Skip to content

Instantly share code, notes, and snippets.

@marijn

marijn/SELECT_PAGES_THAT_ARE_NOT_APPS.sql

Created August 30, 2012 13:11
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save marijn/3528232 to your computer and use it in GitHub Desktop.
Save marijn/3528232 to your computer and use it in GitHub Desktop.
Download ZIP
FQL for selecting pages that are not FB apps
Raw
SELECT_PAGES_THAT_ARE_NOT_APPS.sql
SELECT page_id, name, description, page_url FROM page WHERE page_id IN (
SELECT page_id FROM page_admin WHERE uid=me() AND NOT (
page_id IN (
SELECT page_id, type FROM page_admin WHERE uid=me() AND type = 'APPLICATION'
)
)
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment