php Programming Glossary: ua.personid
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 big JOIN to get all the data SELECT ua.datetime ua.imdbID ua.personID sa.activityID sa.activity m.title m.year p.name umv.vote upv.vote.. m ON ua.imdbID m.imdbID LEFT OUTER JOIN persons p ON ua.personID p.personID LEFT OUTER JOIN user_movies_vote umv ON umv.userID.. upv ON upv.userID ua.userID AND upv.personID ua.personID LEFT OUTER JOIN reviews r ON r.userID ua.userID AND r.imdbID..
|
