A LEFT JOIN without an ON clause is not a LEFT JOIN, it's an INNER JOIN. It could be what you want, but then you should write it as an INNER JOIN, otherwise you'll really confuse the next person (or just yourself) looking back to it in a few years. You shouldn't do "INNER JOIN" + WHERE as a habit either, but at least it will work. "LEFT JOIN" + WHERE doesn't actually work.