Using My SQL joins

Question

I am having trouble finishing my MySQL JOIN. I am unsure of the syntax for the last part of my query.

My Query:

$posts_query= "
SELECT *
FROM posts p
JOIN relations r ON p.user_id = r.recipient
WHERE (r.status = 1 OR r.status = 2)
AND (r.sender = '".$user_id."' OR p.user_id = '".$user_id."')


// How do I write this part?
AND skip where r.status = 1 and p.privacy = 2 where p.user_id != $user_id // 

ORDER BY p.post_id DESC;
";

Answer 1

Instead of 'skip', just set it so that the value isn't true, using NOT:

SELECT *
FROM posts p
JOIN relations r ON p.user_id = r.recipient
WHERE (r.status = 1 OR r.status = 2)
AND (r.sender = '$user_id' OR p.user_id = '$user_id')
AND NOT (r.status = 1 AND p.privacy = 2 AND p.user_id != '$user_id')
ORDER BY p.post_id DESC;"

Answer 2

SELECT *
FROM posts p
JOIN relations r ON p.user_id = r.recipient
WHERE r.status in (1,2)
AND (r.sender = '$user_id' OR p.user_id = '$user_id')
AND NOT ( r.status = 1 and p.privacy = 2 AND p.user_id != '$user_id' )
ORDER BY p.post_id DESC;