• I'd also agree you're better off posting the execution plan rather than just removing elements of your query.

    Admittedly, the more experienced you are, the more likely you will be able to spot code smells but still...