fql.queryテストコンソール

fql.query – Facebook Developers
いつもURL忘れるのでメモ。
これも
Facebook Query Language (FQL) – Facebook Developers
user – Facebook Developers
application – Facebook Developers

主なところはこんな感じかな？
自分自身とその友達の一覧取得

SELECT uid, name FROM user WHERE uid = me() OR uid IN (SELECT uid2 FROM friend WHERE uid1 = me())

ページをLikeしている自分の友だちの一覧

SELECT uid, name FROM user WHERE uid IN( SELECT uid FROM page_fan WHERE page_id = [pageID] AND uid IN (SELECT uid2 FROM friend WHERE uid1 = me()))

アプリを使用している自分の友だち一覧

SELECT uid, name, is_app_user FROM user WHERE uid IN (SELECT uid2 FROM friend WHERE uid1 = me())

自分がLikeしたFacebookObject

SELECT url FROM object_url WHERE id IN(SELECT object_id FROM like WHERE user_id=me())