As soon as you filter on the table you’re joining with in the where clause it becomes an inner join.
FROM foo
LEFT JOIN bar ON ...
/* Makes it an inner join: */
WHERE bar.baz ...