errorInvalid column name 't0'.
Invalid column name 'a0'.
Invalid column name 'a0'.
Invalid column name 't0'.
Invalid column name 'a0'.
Invalid column name 'a0'.
Invalid column name 't0'.
Invalid column name 'a0'.
Invalid column name 'a0'.
Invalid column name 't0'.
Invalid column name 'a0'.
Invalid column name 't0'.
Invalid column name 'a0'.
Invalid column name 'a0'.
Invalid column name 'a9999'.
(select  '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,NETINDIA_BestPrice.provider,a1,a2,a3,a4,a5,a6,a7,[hotel id] as HotelId,establishmentname,town, geography::STGeomFromText('POINT(69.9667 21.2500)', 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(t0 as money) as total,(1-(cast(a0 as decimal))) as availorderstr,1 as noofnight,homehyperlinkbo,homehyperlinklr,homehyperlinkhb,homehyperlinkev,bookingcomid,lateroomsid,eviivoid,hostelbookersid,homehyperlink,status,[rooms from] as roomprice,source,(cast(t0 as money))/IIF((1-(cast(a0 as decimal)))<=0,1,(1-(cast(a0 as decimal)))) as pricesort,cast(a9999 as decimal) as availsort,[ourrank] from dbo.#TEMP     left join NETINDIA_BestPrice on  #TEMP.[hotel id] = NETINDIA_BestPrice.hotelid  and (((cast(t0 as money))/IIF((1-(cast(a0 as decimal)))<=0,1,(1-(cast(a0 as decimal)))) between 1 and  200) or  ((cast(t0 as money))/IIF((1-(cast(a0 as decimal)))<=0,1,(1-(cast(a0 as decimal)))) = 0))   and ( geography::STGeomFromText('POINT(69.9667 21.2500)', 4326).STDistance(coordinates)/1609.34<=10) ) order by  proxdistance     OFFSET 0 ROWS FETCH NEXT 30 ROWS ONLY