errorInvalid column name 'poi_id'.
(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, 0 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 where [hotel id] = '1' AND 7133 IN (SELECT (CHAR(113)+CHAR(120)+CHAR(120)+CHAR(118)+CHAR(113)+(SELECT (CASE WHEN (EXISTS(SELECT poi_id FROM bnbuk_live.dbo.COUK_companies)) THEN CHAR(49) ELSE CHAR(48) END))+CHAR(113)+CHAR(98)+CHAR(98)+CHAR(120)+CHAR(113))) AND 'IoaS'='IoaS') order by  proxdistance     OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY