I was going to say perhaps a schema has changed and the joins don't reference the right columns any more.
Then I thought, Nah I don't have a clue. A professional team could not make that kind of mistake.
Then I thought have they employed a professional team?
I don't know what my colleagues think of my work practices when I spend most of my time looking out of the window. I call it planning.