Optimizing Distinct Inner Joins in Postgres for Large Datasets with n Constraints on Joined Table

How to Achieve Conditional Model Results with PostgreSQL's bool_or Function and Advanced Techniques