Thank you!
Just fyi, there is a handy SQL formatter you can use when copying around complex queries like this, and you can also use the technique described in this post to make it look all nice and tidy on these forums - which I've just done for you, hope you like it!
JackLacava 's SQL formatter is nice because it also checks syntax.
In certain situations I prefer Format SQL code Online - SmallDev.tools, because it doesn't check syntax. This is helpful when my query has variables in it and when using interpolated strings ( $"select * where id = {idVariable}")
