WHERE clause before INNER JOIN

The where clause will be executed before the join so that it doesn’t join unnecessary records. So your code is fine the way it is.