SELECT
campaign.id,
ad_group.id,
ad_group_ad.ad.id,
asset.id
FROM ad_group_ad_asset_view
where
campaign.id=<xxx>