If you never used or heard of LATERAL [JOIN] I suggest checking that out because it is pretty awesome and handy.

https://www.postgresql.org/docs/current/queries-table-expres...