LEFT JOIN issue with SQL_WHERE clause

[Denis_Sineiko]

I have an issue with displaying JOINED tables together.

This is what I have:

And this is what I would like to have:

The difference between these two pictures is that in the first one I’m using SQL_WHERE in the JOIN and in the second one - not

Does anyone know how to display data the same as in the second picture BUT with sql_where in the join?