You missed quoting the part where I describe the on clauses you need to distinguish between "them" and "me"Me: u.uid in (player...) and (s.uid = u.uid)Them: u.uid in (player...) and (s.uid <> u.uid)
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных