Can you cut and paste that as formatted text, please? See Wiki - how to post code on this forum. That way the columns will line up and my head won't hurt.
In the jumble it appears that wastewaterlog has
- Key_name: WastWaterLogt_stampndx
based on - Column_name: t_stamp
so that should be indexed properly.
Wasn't there a second table to be checked?