How do I make a left join between a table (left side) and two inner joined tables (right) with a where clause on tables on the right?

[chirag-garg]

Because its an OUTER JOIN you need to be very careful on how you put the WHERE clause based on right tables
So it has to be either

OR it should be included along with JOIN condition as

Putting it in the WHERE clause along with LEFT JOIN will reduce it to INNER JOIN unless you put an additional condition to handle NULLs