Составляю такой запрос
Код: Выделить всё
SELECT u.user_email, c*
FROM competition c
LEFT JOIN users u ON c.user_id = u.user_id
WHERE (SELECT COUNT(*) FROM competition WHERE ip = competition.ip) < 2
Код: Выделить всё
SELECT u.user_email, c*
FROM competition c
LEFT JOIN users u ON c.user_id = u.user_id
WHERE (SELECT COUNT(*) FROM competition WHERE ip = competition.ip) < 2
Код: Выделить всё
select
user.*,
competition.*
from user
left join competition on competition.user_id = user.id
where competition.user_id in (
select user_id
from competition
group by ip
having count(user_id) == 1
)
Код: Выделить всё
having count(user_id) == 1