¡@

Home 

php Programming Glossary: 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

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.. ua.activityID sa.activityID LEFT OUTER JOIN movies m ON ua.imdbID m.imdbID LEFT OUTER JOIN persons p ON ua.personID p.personID.. sa.activityID LEFT OUTER JOIN movies m ON ua.imdbID m.imdbID LEFT OUTER JOIN persons p ON ua.personID p.personID LEFT OUTER..