SELECT  
t2_ad, t2_ad, 92,  t2_sd,  t2_sd, 92,  t1_dc,  tab3.name_full,297,  t2_arm,  tab4.name_full,294,  t2_mdt, tab5.name_full,  
387, t2_ims, tab6.name_full, 382,  t1_id,  t1_id, 0,  t1_uuid,  t1_uuid,  0
FROM
(SELECT * FROM (
(SELECT tab2.arrive_date as t2_ad, tab2.send_date as t2_sd, tab1.data_category as t1_dc, tab2.Arm as t2_arm, tab2.id_messages_direction_types as t2_mdt,
   tab2.id_message_settings as t2_ims, tab1.id as t1_id, tab1.uuid as t1_uuid
   FROM s_content.selected_parameters_values as tab1 
   INNER JOIN s_fast.messages_titles as tab2 ON tab2.id=tab1.id_message_header,
   LATERAL (SELECT * FROM s_content.selected_parameters_values as tab1 
   WHERE tab2.id=tab1.id_message_header
   ORDER BY  tab1.id  LIMIT 100) foo1)  as foo3
UNION ALL
(SELECT tab2.arrive_date as t2_ad, tab2.send_date as t2_sd, tab1.data_category as t1_dc, tab2.Arm as t2_arm, tab2.id_messages_direction_types as t2_mdt,
   tab2.id_message_settings as t2_ims, tab1.id as t1_id, tab1.uuid as t1_uuid
   FROM s_content.selected_parameters_values as tab1
   LEFT JOIN s_fast.messages_titles as tab2 ON tab2.id=tab1.id_message_header
   WHERE tab2.id IS NULL    
   ORDER BY tab1.id LIMIT 100) as foo2 ) as _t
)
LEFT JOIN s_content.categories_data as tab3 ON tab3.id=_t.t1_dc  
LEFT JOIN s_content.data_sources as tab4 ON tab4.id=_t.t2_arm   
LEFT JOIN s_content.id_messages_direction_types as tab5 ON tab5.id=_t.t2_mdt   
LEFT JOIN s_content.messages_settings as tab6 ON tab6.id=_t.t2_ims
ORDER BY  _t.t2_ad, _t.t1_id LIMIT 100