Wrong left join!

other threads have no answer on this
I have send to support but support doesnt exist,
the project is ms sql with asp.net core and quasar
as you can see the join on tables is left but on code it does inner
that returns nothing if all fields are not filed on records.!!!
any solutions?