|
|
|
SELECT activities.actid, activities.userid, activities.acttype, activities.acttypeobject, activities.acttypeid, activities.actnotes, activities.datetime, users.username, users.avatar, friends.userid
FROM activities, users, friends
WHERE activities.userid = users.userid
AND friends.userid = activities.userid
AND friends.friendid = '1'
AND friends.state = '1'
OR activities.userid = users.userid
AND friends.friendid = activities.userid
AND friends.userid = '1'
AND friends.state = '1'
OR activities.userid = users.userid
AND activities.userid = '1'
OR activities.userid = users.userid
AND activities.userid = '0'
GROUP BY activities.actid
ORDER BY activities.datetime DESC LIMIT 25 |
test
|
|
|
