added a note about the weird joins