left joins all tables otherwise reports are missing see #8
updates title