error.NET Framework runtime has been stopped.
(select  'false' as shortlistbasketid,0 as customAvailable,[County/Department] as cd,latitude,longitude,isnull(externalimageurl,'/layout/noimg.jpg') as externalimageurl,address1,address2,postcode,description,provider,[hotel id] as a1,a2,a3,a4,a5,a6,a7,[hotel id] as HotelId,establishmentname,town, geography::STGeomFromText('POINT(-5.0935 50.4158)', 4326).STDistance(coordinates)/1609.34  as proxdistance  ,case when ourrank = 0 then 'N/A' else 	cast(ourrank as varchar(30))  end as vOurRank,t1,t2,t3,t4,t5,t6,t7,t1 as total,1 as availorderstr,1 as noofnight,homehyperlinkbo,homehyperlinklr,homehyperlinkhb,homehyperlinkev,bookingcomid,lateroomsid,eviivoid,hostelbookersid,homehyperlink,status,[rooms from] as roomprice,source,0,0,[ourrank] from #TEMP   left join COUK_BestPrice on  #TEMP.[hotel id] = COUK_BestPrice.hotelid and isnumeric([Rooms From]) = 1  and ( geography::STGeomFromText('POINT(-5.0935 50.4158)', 4326).STDistance(coordinates)/1609.34<=25)) order by  proxdistance     OFFSET 0 ROWS FETCH NEXT 30 ROWS ONLY