SELECT f_ai,'a' as ltype,ai_main.ID, lat,lon,photourl,'' as price_low,name,address,city,state,'' as r5,ai_main.ID as hotelID,'' as r38,'' as r16, 0 as distance, '0' as accesslevel,website as hotelurl FROM ai_main inner join ai_main_zips on ai_main_zips.ID = ai_Main.ID where cityID = 1112