FQL Queries in the Facebook Checkins Explorer

gistfile1.js

{checkins: 'SELECT coords, author_uid, message,target_id, target_type, timestamp FROM checkin WHERE author_uid IN (SELECT uid2 FROM friend WHERE uid1 = me()) AND timestamp > "'+(Math.round((new Date()).getTime()/1000)-365*24*60*60) + '" ORDER BY timestamp DESC LIMIT 0,100',
names: 'SELECT name,uid,pic_small,profile_url FROM user WHERE uid IN (SELECT author_uid FROM #checkins)',
events: 'SELECT name,page_id,page_url FROM page WHERE page_id IN (SELECT target_id FROM #checkins)'}