¡@

Home 

php Programming Glossary: ua.imdbid

User activity feed (ala facebook). How to group similar activities?

http://stackoverflow.com/questions/4115337/user-activity-feed-ala-facebook-how-to-group-similar-activities

a really big JOIN to get all the data SELECT ua.datetime ua.imdbID ua.personID sa.activityID sa.activity m.title m.year p.name.. ON ua.activityID sa.activityID LEFT OUTER JOIN movies m ON ua.imdbID m.imdbID LEFT OUTER JOIN persons p ON ua.personID p.personID.. umv ON umv.userID ua.userID AND umv.imdbID ua.imdbID LEFT OUTER JOIN user_persons_vote upv ON upv.userID ua.userID..