I'm trying to build a query for fetch wall_posts and profile fields for several user_id. First see the images at: http://www.dropmocks.com/mBjQ7P. The table with id_user_rq, id_user_ap is the table where I handle the relations. Meaning 1 and 2 are friends and 1 and 3 are friends too because the directionality is 1,2 | 2,1 and 1,3 | 3,1. So what I need here is to get the wall_post for users 1,2,3 and also the profile data for the same users. Wall_posts is image #2 and profile is the first image. I've tried this query:
SELECT DISTINCT
default_profiles.*,default_wall_posts.*,
UNIX_TIMESTAMP( ) - default_wall_posts.date_created AS pass_time
FROM
(default_wall_posts)
LEFT JOIN default_profiles
ON (default_profiles.user_id = default_wall_posts.userid)
AND (default_wall_posts.userid = 2 OR default_wall_posts.userid = 3)
WHERE
default_wall_posts.userid = 1 AND
(
default_wall_posts.userid = 2 AND
default_wall_posts.userid = 3
)
ORDER BY
default_wall_posts.date_created DESC;
But it's not working because I only get the wall_posts and profile fields for user 1. What I'm doing wrong?
Cheers and thanks in advance