I have 3 tables: Users, Community & Posts.

I want to retrieve posts of users that Joe dont follow `(id_user=1)`

**Users**

```
    id_user  |  name
       1        Joe
       2        Doe
       3        Moe
       4        Roe
       5        Clin

```

**Community**

```
  id_follower | id_followed
       1            3
       1            5

```

**Posts**

```
    id_post   | id_user | post  
      24            4       hi
      25            5       hello
      26            1       how are you
      27            3       come on
      28            4       let go
      29            2       get out

```

What I'm expecting to retrieve is 

```
      24            4       hi - by Roe
      28            4       let go  - by Roe
      29            2       get out  - by Doe     

```

I tried this but not working

```
SELECT p*
FROM community as c
LEFT JOIN users as u ON u.id_user=c.id_followed
LEFT JOIN posts as p ON p.id_user!=c.id_followed 
WHERE c.id_follower=1 AND u.id_user!=1 

```