[eluser]flyenig[/eluser]
If you go on myspace, or facebook, or twitter, they have an activity stream of all your friends - Their Status', pictures that has been recently uploaded, etc.
How would their sql statement look like to retrive the statuses of every friend?