select advertiser, advertiser_id,'Adjust' as MMP, outcome_ltag from advertiser_lookup where outcome_ltag in ( select distinct(l_tag) from new_pixel where user_agent ='adjust.com' and date = '2024-03-22') union select advertiser, advertiser_id, 'AppsFlyer' as MMP, outcome_ltag from advertiser_lookup where outcome_ltag in ( select distinct(l_tag) from new_pixel where user_agent ='http-kit/2.0' and date = '2024-03-22') union select advertiser, advertiser_id, 'Singular' as MMP, outcome_ltag from advertiser_lookup where outcome_ltag in ( select distinct(l_tag) from new_pixel where user_agent ='Apsalar-Postback' and date = '2024-03-22') union select advertiser, advertiser_id, 'Kochava' as MMP, outcome_ltag from advertiser_lookup where outcome_ltag in ( select distinct(l_tag) from new_pixel where u11_tag ='Kochava' and date = '2024-03-22') order by MMP