Without the data it is somewhat difficult to see what is going on; try your
SQL after

1. replacing INNER JOIN by a comma
2. removing the ON clause and including its condition in the WHERE clause
instead.