errorThe app domain with specified version id (1841) was unloaded due to memory pressure and could not be found. (select (COUNT(*) OVER()) as totalrecord,'false' as shortlistbasketid,(cast(a1 as decimal) + cast(a2 as decimal) + cast(a3 as decimal) + cast(a4 as decimal) + cast(a5 as decimal) + cast(a6 as decimal) + cast(a7 as decimal)) as custAvailable, [County/Department] as cd,latitude,longitude,isnull(externalimageurl,'/layout/noimg.jpg') as externalimageurl,address1,address2,postcode,description,NETIRELAND_BestPrice.provider,a1,a2,a3,a4,a5,a6,a7,NETIRELAND_BestPrice.HotelId,establishmentname,town, geography::STGeomFromText('POINT(-8.8611 51.6625)', 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,cast(t1 as money) as total,(1-(cast(a1 as decimal))) as availorderstr,1 as noofnight,homehyperlinkbo,homehyperlinklr,homehyperlinkhb,homehyperlinkev,bookingcomid,lateroomsid,eviivoid,hostelbookersid,homehyperlink,status,[rooms from] as roomprice,source,(cast(t1 as money))/IIF((1-(cast(a1 as decimal)))<=0,1,(1-(cast(a1 as decimal)))) as pricesort,cast(a1 as decimal) as availsort,[ourrank] from dbo.#TEMP inner join NETIRELAND_BestPrice on #TEMP.[hotel id] = NETIRELAND_BestPrice.hotelid and (((cast(t1 as money))/IIF((1-(cast(a1 as decimal)))<=0,1,(1-(cast(a1 as decimal)))) between 1 and 200) or ((cast(t1 as money))/IIF((1-(cast(a1 as decimal)))<=0,1,(1-(cast(a1 as decimal)))) = 0)) and ( geography::STGeomFromText('POINT(-8.8611 51.6625)', 4326).STDistance(coordinates)/1609.34<=10) ) order by availsort asc,custAvailable asc, proxdistance OFFSET 0 ROWS FETCH NEXT 30 ROWS ONLY