SELECT DISTINCT ad_account_id, ad_account_name,
                campaign_id, campaign_name,
                adgroup_id, adgroup_name
FROM all_ads_details
WHERE campaign_id IN (some list)
      adgroup_name IN (some_list)
LIMIT 10;