{"Status":"InvalidRequest","RequestID":"7bb8175a-1c3d-4775-9309-74469f243766","Results":[{"Object":{"Name":null,"ObjectID":"6e11e397-5aac-4f6c-a293-31a6fd000772","CategoryID":291840,"QueryText":"SELECT \n SubscriberKey, \n Email, \n First_Name, \n LastName, \n locale, \n user_id, \n fb_id, \n id, \n page_id, \n num_actions_l28, \n account_id, \n account_status, \n legal_rev_l28, \n record_id, \n created_date, \n timezone_gmtoffset \nFROM \n (\n SELECT \n TOP 250 \n SubscriberKey, \n Email, \n First_Name, \n LastName, \n locale, \n user_id, \n fb_id, \n id, \n page_id, \n num_actions_l28, \n account_id, \n account_status, \n legal_rev_l28, \n record_id, \n created_date, \n timezone_gmtoffset \n FROM \n sbg_2024_q2_sofa_fa_mtgfb_under200_xyz_master_de \n WHERE \n (Email LIKE '%@gmail.com%' OR Email LIKE '%@google.com%') \n AND \n SubscriberKey NOT IN (SELECT SubscriberKey FROM [sbg_2024_q2_sofa_fa_mtgfb_under200_xyz_log_de]) \n AND \n account_id NOT in (SELECT account_id from [sbg_2024_q2_sofa_fa_mtgfb_under200_xyz_supression_de])\n AND \n Email NOT in (SELECT EmailAddress from [Meta_Unsubscribe_list_de]) \n UNION \n SELECT \n TOP 750 \n SubscriberKey, \n Email, \n First_Name, \n LastName, \n locale, \n user_id, \n fb_id, \n id, \n page_id, \n num_actions_l28, \n account_id, \n account_status, \n legal_rev_l28, \n record_id, \n created_date, \n timezone_gmtoffset \n FROM \n sbg_2024_q2_sofa_fa_mtgfb_under200_xyz_master_de \n WHERE \n (Email LIKE '%@yahoo.com%' OR Email LIKE '%@aol.com%')\n AND \n SubscriberKey NOT IN (SELECT SubscriberKey FROM [sbg_2024_q2_sofa_fa_mtgfb_under200_xyz_log_de]) \n AND \n account_id NOT in (SELECT account_id from [sbg_2024_q2_sofa_fa_mtgfb_under200_xyz_supression_de])\n AND \n Email NOT in (SELECT EmailAddress from [Meta_Unsubscribe_list_de]) \n UNION \n SELECT \n TOP 750 \n SubscriberKey, \n Email, \n First_Name, \n LastName, \n locale, \n user_id, \n fb_id, \n id, \n page_id, \n num_actions_l28, \n account_id, \n account_status, \n legal_rev_l28, \n record_id, \n created_date, \n timezone_gmtoffset \n FROM \n sbg_2024_q2_sofa_fa_mtgfb_under200_xyz_master_de \n WHERE \n (Email LIKE '%@hotmail.com%' OR \n Email LIKE '%@outlook.com%' OR \n Email LIKE '%@live.com%')\n AND \n SubscriberKey NOT IN (SELECT SubscriberKey FROM [sbg_2024_q2_sofa_fa_mtgfb_under200_xyz_log_de]) \n AND \n account_id NOT in (SELECT account_id from [sbg_2024_q2_sofa_fa_mtgfb_under200_xyz_supression_de])\n AND \n Email NOT in (SELECT EmailAddress from [Meta_Unsubscribe_list_de]) \n UNION \n SELECT \n TOP 750 \n SubscriberKey, \n Email, \n First_Name, \n LastName, \n locale, \n user_id, \n fb_id, \n id, \n page_id, \n num_actions_l28, \n account_id, \n account_status, \n legal_rev_l28, \n record_id, \n created_date, \n timezone_gmtoffset \n FROM \n sbg_2024_q2_sofa_fa_mtgfb_under200_xyz_master_de \n WHERE\n Email NOT LIKE '%@gmail.com%' AND \n Email NOT LIKE '%@yahoo.com%' AND \n Email NOT LIKE '%@aol.com%' AND \n Email NOT LIKE '%@hotmail.com%' AND \n Email NOT LIKE '%@outlook.com%' AND \n Email NOT LIKE '%@live.com%' \n AND \n SubscriberKey NOT IN (SELECT SubscriberKey FROM [sbg_2024_q2_sofa_fa_mtgfb_under200_xyz_log_de]) \n AND \n account_id NOT in (SELECT account_id from [sbg_2024_q2_sofa_fa_mtgfb_under200_xyz_supression_de])\n AND \n Email NOT in (SELECT EmailAddress from [Meta_Unsubscribe_list_de]) \n ) as emails","TargetType":"DE","DataExtensionTarget":{"Name":"sbg_2024_q2_sofa_fa_mtgfb_under200_xyz_de","Description":null,"Keyword":null,"Client":null,"PartnerKey":null,"PartnerProperties":null,"CreatedDate":"0001-01-01T00:00:00.000","ModifiedDate":null,"ID":0,"ObjectID":null,"CustomerKey":"DF0F644D-775D-49B8-9645-2F51DB4F8B68","Owner":null,"CorrelationID":null,"ObjectState":null,"IsPlatformObject":false},"TargetUpdateType":"Overwrite","FileSpec":null,"FileType":null,"Status":null,"InteractionObjectID":null,"Description":"2024-09-19 12:09:SS","Keyword":null,"Client":null,"PartnerKey":null,"PartnerProperties":null,"CreatedDate":"0001-01-01T00:00:00.000","ModifiedDate":null,"ID":0,"CustomerKey":null,"Owner":null,"CorrelationID":null,"ObjectState":null,"IsPlatformObject":false},"UpdateResults":null,"ParentPropertyName":null,"StatusCode":"Error","StatusMessage":"Error saving the Query field.Invalid column name 'record_id'.
","OrdinalID":0,"ErrorCode":9999999,"RequestID":null,"ConversationID":null,"OverallStatusCode":"InvalidRequest","RequestType":"Synchronous","ResultType":null,"ResultDetailXML":null}]}
Lookup:success
Total:2500
Lookup:success
date:undefined