ads_with_targets (view)

0 rows where target_names contains "people_who_match:interests:African-American Civil Rights Movement (1954—68)", target_names contains "people_who_match:interests:African-American culture", target_names contains "people_who_match:interests:Black (Color)" and target_names contains "people_who_match:interests:Black Consciousness Movement"

descending

This data as json

id	file	clicks	impressions	text	url	spend_amount	spend_currency	created	ended	target_names

CREATE VIEW ads_with_targets as select ads.*, json_group_array(targets.name) as target_names from ads
  join ad_targets on ad_targets.ad_id = ads.id
  join targets on ad_targets.target_id = targets.id
  group by ad_targets.ad_id