SELECT sd.Num as Num,sd.Type as Type,sd.Value as Value,li.Date as Date,li.uid as Unit FROM save_data sd INNER JOIN ( SELECT Num_i as Num, Date, ul.uname as uid FROM info inf INNER JOIN ( SELECT uNum,uName as uname FROM units_list) as ul ON inf.Prib_id = ul.uNum ORDER BY inf.Num_i DESC) as li ON li.Num = sd.Num