From Facebook Developer Wiki

Description

The FQL status table. Query this table to return one or more of a user's statuses.

To structure your query, use the table name (status in this case) in the FROM clause. The items in the Name column correspond to columns in the table that can be referenced in the SELECT and WHERE clauses.

In order to make your query indexable, the WHERE in your query should contain an = or IN clause for the uid column.

Optimization: When querying this table for many users, be sure to give specific time limit within the last week. I.e. instead of

select uid,status_id,message from status where uid in (select uid2 from friend where uid1= uid)

use

select uid,status_id,message from status where uid in (select uid2 from friend where uid1= uid) AND time > {time in the last week}

Columns

Indexable	Name	Type	Description
*	uid	int	The user ID of the current user.
	status_id	string	The ID of the status message.
	time	string	The date and time the status message was posted.
	source	string	The application that published the status originally.
	message	string	The content of the status message.

See Also

• Sample FQL Queries
• status.set
• status.get