SELECT campaign.id,campaign.status,campaign.base_campaign,campaign.name,ad_group.id,ad_group.status,ad_group.base_ad_group,ad_group.name,ad_group_ad.ad.name,ad_group_ad.status,ad_group_ad.ad.id,ad_group_ad.ad.type,ad_group_ad.ad.final_mobile_urls,ad_group_ad.ad.final_app_urls,ad_group_ad.ad.final_urls,ad_group_ad.ad.tracking_url_template,ad_group_ad.ad.display_url,ad_group_ad.ad.text_ad.headline,ad_group_ad.ad.text_ad.description1,ad_group_ad.ad.text_ad.description2,ad_group_ad.ad.call_only_ad.description1,ad_group_ad.ad.call_only_ad.description2,ad_group_ad.ad.expanded_dynamic_search_ad.description,ad_group_ad.ad.expanded_text_ad.headline_part1,ad_group_ad.ad.expanded_text_ad.headline_part2,ad_group_ad.ad.expanded_text_ad.description,ad_group_ad.ad.expanded_text_ad.description2,ad_group_ad.ad.expanded_text_ad.path1,ad_group_ad.ad.expanded_text_ad.path2,ad_group_ad.ad.image_ad.image_url,ad_group_ad.ad.image_ad.name,ad_group_ad.ad.legacy_responsive_display_ad.description,ad_group_ad.ad.legacy_responsive_display_ad.business_name,ad_group_ad.ad.legacy_responsive_display_ad.short_headline,ad_group_ad.ad.legacy_responsive_display_ad.long_headline,ad_group_ad.ad.legacy_responsive_display_ad.marketing_image,ad_group_ad.ad.legacy_responsive_display_ad.square_logo_image,ad_group_ad.ad.legacy_responsive_display_ad.logo_image,ad_group_ad.ad.legacy_responsive_display_ad.square_marketing_image,ad_group_ad.ad.responsive_display_ad.descriptions,ad_group_ad.ad.responsive_display_ad.headlines,ad_group_ad.ad.responsive_display_ad.long_headline,ad_group_ad.ad.responsive_display_ad.marketing_images,ad_group_ad.ad.responsive_display_ad.square_logo_images,ad_group_ad.ad.responsive_display_ad.business_name,ad_group_ad.ad.responsive_search_ad.descriptions,ad_group_ad.ad.responsive_search_ad.headlines,ad_group_ad.ad.responsive_search_ad.path1,ad_group_ad.ad.responsive_search_ad.path2,ad_group_ad.ad.shopping_product_ad,ad_group_ad.ad.shopping_smart_ad,ad_group_ad.ad.video_ad.in_stream.action_headline,ad_group_ad.ad.video_ad.out_stream.headline,ad_group_ad.ad.video_ad.out_stream.description
FROM ad_group_ad
WHERE campaign.status NOT IN ("REMOVED") AND ad_group.status NOT IN ("REMOVED") AND ad_group_ad.status NOT IN ("REMOVED")