https://evansmith.dev/general/developer/sql-screw-ups-outer-join-filters/
SQL Screw-ups: Outer Join Filters