Re: Displaying chat by punished users only to themselves (db fiddle attached)

[Alexander Farber]

I am probably needing LEFT JOIN LATERAL here (and am completely lost)?

Or to switch to CTE as you suggest