SQL Query very slow

[Larz60+]

Mark87 -- I appreciate your effort, however Please check post date before answering, as this post is over a month old.
This item has long since been solved, and my SQL expertise are almost beck to 10 year ago levels.