Все_Статусы_По_Ребенку

select pp.uid,
       pp.full_reg_datetime,
       pp.install_datetime,
       pp.last_active_datetime,
       pch.*
from analytics.parent_properties pp
join
  (select *
   from logs.parent_child_history
   where parent in (117738119,
                    118601881,
                    118653549)) as pch on pch.parent = pp.id
where pp.uid in ('naf1g8psa6',
                 '4d994jeo67',
                 '3g1n3l9683')
order by pp.id,
         pch.ts;