select f.id, f.sname, a.* from fin f 
left join (
  select max(i_time) as mmaaxx, fin, l_price, best_buy, deal_max, deal_min from inf_ac group by fin
) a on f.id = a.fin;