I'm falling in the camp that says the query was wrong, with the table on the left being the wrong table.

If the query had been right it would have been a more intriguing question, but as it stands, just feel a bit... off.