left joins all tables otherwise reports are missing see #8