Why does LEFT JOIN return fewer rows when I add a condition on the joined table in WHERE clause?

sql join where-clause left-join