Welcome, Mike.
That query needs some TLC, edit your post to change the query and script into code blocks. This way we can easily copy and paste them to help you out.
Wiki - how to post code on this forum - General Discussion - Inductive Automation Forum