• Replace DISTINCT with TOP 1 in the correlated subquery.


    N 56°04'39.16"
    E 12°55'05.25"