The extra constraints in the `WHERE` will affect rows returned by this query. That may be ok for you but it makes the joins not purely left.
The extra constraints in the `WHERE` will affect rows returned by this query. That may be ok for you but it makes the joins not purely left.