Вывести пользователей Mysql?

Question

[Analka]

Как вывести всех пользователей, которых я не лайнкул в таблице likes и соответствую условию

накидал так, но ничего не выводит

SELECT * FROM `users`
    LEFT join `user_attributes` on user_attributes.user_id = users.id
    left join likes on likes.like_user != users.id and likes.user_id = 1
    where user_attributes.gender = 2 and user_attributes.city = "Витебск" and user_attributes.age BETWEEN 18 and 25 LIMIT 4

Answer 1

[Arman]

?

SELECT * FROM `users`
LEFT join `user_attributes` on user_attributes.user_id = users.id
where 
user_attributes.gender = 2 
and user_attributes.city = "Витебск" 
and user_attributes.age BETWEEN 18 and 25 
and not exists (select * from likes where likes.like_user = users.id)
LIMIT 4